EMT Practice Test

1. Question Content...

---

Question1: What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

Question2: Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

Question3: What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

Question4: Why would you create SQL in calculation views?

Question5: In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

Question6: Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

Question7: Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

Question8: What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

Question9: Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Question10: Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

Question11: What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

Question12: In a database module, what is the purpose of the .hdiconfig file?

Question13: You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

Question14: In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

Question15: What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

Question16: Which components are part of SAP HANA Cloud?Note: There are 2 correct answers to this question.

Question17: A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

Question18: You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

Question19: Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

Question20: You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.What could be the reason?

Question21: Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

Question22: Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

Question23: You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

Question24: Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

Question25: Why would you create calculation views of data category DIMENSION with type TIME?

Question26: You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Question27: Using the table in the diagram, you need to create a CUBE calculation view.

What is the simplest approach to create the output shown in the screenshot?

Question28: A calculation view includes a rank node that uses the source data and settings shown in the graphic.

Your query requests all columns of the rank node.How many rows are in the output of your query?