EMT Practice Test

1. Question Content...

---

Question1: Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

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

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

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

Question5: You are building a new calculation view A that uses calculation view B, as shown in the diagram. When you preview the calculation view A, the Account Number is not masked.

What could be the reason?

Question6: 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 build the calculation view, the build fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

Question7: Which of the following supports data replication?

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

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

Question10: You want to join two tables in a calculation view.Why do you use a non-equi join?

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

Question12: You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

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

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

Question15: Why would you build a calculation view of type SQL Access only?

Question16: Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.

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

Question18: Why do you create calculation views of data category DIMENSION with type TIME?

Question19: Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

Question20: You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project.Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

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

Question22: You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.

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

Question24: You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option?Note: There are 2 correct answers to this question.

Question25: In an XS Advanced project, what is the purpose of the .hdiconfig file?

Question26: You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note:
There are 2 correct answers to this question.

Question27: Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

Question28: In SAP Web IDE, 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 build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

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