|Which of the following describe design time objects? There are 3 correct answers to this question. Inactive Repository objects Catalog objects Active Native objects.
Where do you graphically create a design time role in SAP HANA?
Please choose the correct answer. In the Roles area under Security in SAP HANA studio In the Repository area in the development perspective in SAP HANA studio In the Security area of the SAP HANA web based development workbench In the Editor area of the SAP HANA web based development workbench.
When do you always have both an active and an inactive version of an information model available in the SAP HANA development system? Please choose the correct answer. When you selected Revert to Active on an inactive version When you edit an existing model When validation of a model fails When you create a new model.
True or False: SAP HANA is just a database. Please choose the correct answer. True False.
What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question. Filter expressions SAP client restrictions Generated columns Domain fix values Restricted columns.
You created a user-defined function with a return type of BIGINT. What type of function have you created? Please choose the correct answer. SQL function Scalar function Table function Window function.
What statement do you have to run before you can return table results from a procedure? Please choose the correct answer. CREATE TYPE CREATE VIEW CREATE TABLE CREATE TABLE TYPE.
What PAL algorithm category can you use for supervised learning? Please choose the correct answer. Social network analysis Classification Clustering Association.
What can be used to return multiple result sets? There are 2 correct answers to this question. Scalar function Table function Procedure View.
Which steps do you have to perform once before you can create SAP HANA development objects? There are 2 correct answers to this question. Create an SAP HANA XS project Create a predictive model using PAL Create a dataflow model in the AFM Create a repository workspace.
What is the recommended way to create full text indexes going forward?
Please choose the correct answer. Core Data Services SQL statements in the SQL Console Procedures Userdefined functions.
What character is used to terminate SQL statements? Please choose the correct answer. Response: . (period) : (colon) ; (semicolon) ? (question mark).
What should you keep in mind when using imperative logic in SQLScript? Please choose the correct answer. You can loop through records You can only use ifthen logic It delivers the best possible performance It matches SQL’s setoriented paradigm.
What statement is allowed in a user defined function? There are 2 correct answers to this question. COMMIT EXEC INSERT JOIN.
Which of the following data operations can you perform with SDA?
There are 3 correct answers to this question. Data federation Logical data warehouse Big data Physical data warehouse Realtime replication.
What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question. Use left outer joins instead of right outer joins Use unions instead of joins for combining large data sets Always specify the cardinality of a join Join as many tables as possible in an analytic view’s data foundation Always mark joins as dynamic to improve performance.
Which tasks are part of the migration tool workflow? There are 2 correct answers to this question. The tool produces a table function linked to a graphical calculation view The tool requires a graphical calculation view as input The tool requires a script-based calculation view as input The tool produces only a table function.
You are using the SAP HANA studio. Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed? There are 3 correct answers to this question. SAP HANA predictive analytics library (PAL) flows SAP HANA enterprise information manager (EIM) jobs SAP HANA smart data access (SDA) queries SAP HANA extended application services (XS) programs SAP HANA smart data streaming (SDS) projects.
What is a new and recommended way to work with SQL and SQLScript? Please choose the correct answer. Create runtime objects rather than design time objects Use table functions rather than scripted calculation views Use CE functions rather than SQL syntax Use procedure files rather than creating SQL and SQLScript via the package context menu.
True or False: When you mark an information model as deprecated, it no longer works.
Please choose the correct answer. True False.
Which of the following are features of a data warehouse? There are 3 correct answers to this question. Data governance Consolidation Both OLTP and OLAP in one system Realtime reporting A full transactional history.
You use parallelism to calculate a year-to-date value quickly, and you eliminate a table from the database. What are some of the implications of this action? There are 3 correct answers to this question. Smaller database backups Less code Better user interfaces Faster response times Faster inserts into the database.
Which of the following VDM views can be called by applications and reports? There are 2 correct answers to this question. Private views Query views Value help views Reuse Views.
Modeling package Shops is a sub-package of package Regions. You want to authorize a user to list the content of package Regions, but prevent listing the content of package Shops. How can you achieve this? Please choose the correct answer. Refactor package Shops to another package Assign REPO.EXPORT only to package Shops Assign REPO.READ privilege only to package Regions Revoke analytic privileges for models in package Shops.
You want to reuse a decision table on multiple tables with a similar data structure.
You design the decision table that passes a specific table name as an input parameter when you execute the decision table. What do you have to use in the data foundation to achieve this? Please choose the correct answer. A dynamic join A scripted calculation view A table type A virtual table.