What type of file would you create in the SAP Web IDE for SAP HANA to do data cleaning?
Please choose the correct answer.
.hdbflowgraph .hdbtabledata .hdbcds .hdbgraphworkspace.
What is an example of a use of Text Analysis?
Please choose the correct answer.
Developing a user input field where misspellings are tolerated. Extraction of key facts from a business article. Extraction of key facts from entire database transactions Cluster documents that discuss similar topics.
You want to retrieve data from a web application. Which of the following could you use?
There are 3 correct answers to this question.
REST JDBC OData BICS JSON.
Why would you create a procedure?
There are 2 correct answers to this question.
If you need to define a calculated column expression If you need a mixture of scalar and tabular output parameters If you need to insert records into a table If you need to provide a data source to a graphical calculation view.
Which type of tables required extended storage?
Please choose the correct answer.
Multistore tables Column tables Row tables In-memory tables.
What is included with the Predictive Analysis Library (PAL)?
There are 2 correct answers to this question.
Text mining functions Flowgraphs Predictive algorithms Data preparation functions.
Refactoring is used with which of the following actions?
Please choose the correct answer.
Improving your modeling design Deployment Translating Documenting.
-In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function?
There are 2 correct answers to this question.
The function can return multiple values. The function must be of the type scalar. The generated value can be overwritten at runtime. The input parameter must be set to mandatory.
-You have logs from a website. How do you show the total number of website visitors that used a mobile phone?
There are 2 correct answers to this question.
Create a rank column. Create a hierarchy expression parameter. Create a filter expression. Create a restricted column.
-Which join type makes use of date ranges?
Please choose the correct answer.
Improving your modeling design Deployment Translating Documenting.
-Which of these does SAP HANA use to connect to BI tools?
There are 3 correct answers to this question.
ODBC JDBC IDOC ODBO.
-The company asks you to get data from IoT sensors. Which SAP tools could you use?
There are 3 correct answers to this question.
SAP Landscape Transformation Replication Server SAP HANA Remote Data Sync (RDSync) SAP SQL Anywhere SAP HANA streaming analytics SAP HANA smart data access (SDA).
-What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement?
Please choose the correct answer.
CONTAINS IN ANY LIKE.
-Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question.
When loading new data in a table that already contains data, the new data is appended to the existing data The supported file types for upload are .csv, and .txt The new table always has a 1:1 mapping between the file and table columns Renaming of columns and changing data types is allowedwhen loading data to new HANA tables.
-What tool generates files to help configure SAP Landscape Transformation Replication Server table replication?
Please choose the correct answer.
SAP HANA Live Extension Assistant SAP HANA Live Browser Authorization Assistant SAP HANA Studio.
-A referential join gives the same results as which other join type?
Please choose the correct answer.
Star join Left outer join Inner join Spatial join.
-What do you need to do after creating a new project with an HDB module?
Please choose the correct answer.
Convert the new module to an HDB module Select a space for running the project Create an .hdinamespace file.
-What statement is allowed in a user-defined function?
Please choose the correct answer.
COMMIT EXEC INSERT JOIN.
--Which of the following benefits characterize the use of a design time filter?
There are 3 correct answers to this question.
The filter is applied on the table before the query is executed. It is defined on the runtime in the SQL query. It is applied before a table join is executed. It reduces the result set of data. The filter is applied on the result set of a query.
Why do you create a time dimension calculation view?
Please choose the correct answer.
To provide date-based help values for a DIRECT type input parameter To support temporal joins in a cube calculation view with star schema To enable time dependency on parent-child hierarchies To enhance a calculation view with a drilldown on a time hierarchy.
-Which table partitioning types does SAP HANA support?
There are 3 correct answers to this question.
Round-robin Composite Hash Cluster Range.
-Which are true statements?
There are 3 correct answers to this question.
SAP HANA can be installed only by certified engineers for production purposes SAP HANA runs on Unix AP HANA is available in the cloud or on premise or a combination of both SAP HANA runs on Intel x86 and SPARC hardware platforms Customers can re-use their own certified hardware components in an SAP HANA system.
-Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 2 correct answers to this question.
Disaster recovery Backups High availability Failover.
-What are valid types of calculation view?
There are 3 correct answers to this question.
Dimension Dimension with star schema Cube with star schema Cube.
-Which of the following are valid types of privileges in SAP HANA?
There are 3 correct answers to this question.
Attribute privileges Data privileges System privileges Application privileges Package privileges.
-Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question.
Value help views Private views Query views Reuse views.
-What is normally used to build SAP HANA XSC applications inside SAP HANA?
There are 2 correct answers to this question
JavaScript Java SAPUI5 ABAP.
-What is a multistore table?
Please choose the correct answer.
-What is a multistore table?
Please choose the correct answer.
A table that can hold data in row and column orientation A table that can be shared across multiple instances of HANA A table that can distribute its partitions across memory and extended storage tiers.
|
