EMT Practice Test

1. Question Content...

---

Question1: What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

Question2: Why might you use the Keep Flag property in an aggregation node?

Question3: Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

Question4: You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

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

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

Question7: In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

Question8: Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

Question9: In a calculation view, what is the purpose of a variable?

Question10: You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

Question11: You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Question12: Why would you enable Debug Query mode in a calculation view?

Question13: Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

Question14: 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?

Question15: 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.

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

Question17: 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?

Question18: Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

Question19: What is the SQL keyword used to process input parameters defined in a calculation view?

Question20: 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?

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

Question22: 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?

Question23: 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?

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

Question25: What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

Question26: Why would you use the Transparent Filter property in a calculation view?

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

Question28: Which tool generates and executes the SQL for a specific node of your calculation view?

Question29: What do you use in the definition of a dynamic SQL analytic privilege?

Question30: You have generated a calculation view properties file.What does it contain?

Question31: In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

Question32: What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.