EMT Practice Test

1. Question Content...

---

Question1: Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

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

Question3: In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

Question4: Why would you create SQL in calculation views?

Question5: Which type of join supports a temporal condition in a calculation view?

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

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

Question8: What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

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

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

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

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

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

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

Question15: What is the objective of calculation view instantiation?

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

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: You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

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

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

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

Question22: What is the default view node for a cube?

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

Question24: Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

Question25: You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

Question26: Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

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

Question28: What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

Question29: You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?

Question30: Which are types of calculation views?
Note: There are 3 correct answers to this question

Question31: Which project structure object corresponds to a unique HDI container?

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

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

Question34: Why would you choose to implement a referential join?

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

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

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

Question38: Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

Question39: Why would you write your SQL code in a procedure instead of a function? Note: There are 3 correct answers to this question.

Question40: What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

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