- All Exams Instant Download
What do you observe in the SAP HANA database container?
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 build it. What do you observe in the SAP HANA database container?A...
What is displayed when null values are found in a column of data type NVARCHAR?
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?A . "?" B. "Null" C. "0" D. <empty string>View AnswerAnswer: D
What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.
What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.A . It must appear in the last DIMENSION in the star join node. B. It CANNOT be mixed in the same star join node with other...
What could be the reason?
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? A. You previewed the data with the technical user in SAP Web IDE for...
Why would you build a calculation view of type SQL Access only?
Why would you build a calculation view of type SQL Access only?A . To enable SQL access to your hierarchies B. To provide a data source that can only be consumed by a function or procedure C. To provide a high performance model when only attributes are required D. To...
Which are the components of SAP HANA Cloud? Note: There are 3 correct answers to this question.
Which are the components of SAP HANA Cloud? Note: There are 3 correct answers to this question.A . SAP Data Warehouse Cloud B. SAP HANA Cloud data lake C. Native Storage Extension D. SAP Analytics Cloud E. SAP HANA in-memory databaseView AnswerAnswer: A,B,D
Why should you define calculated column expressions using plain SQL and avoid using column engine language?
Why should you define calculated column expressions using plain SQL and avoid using column engine language?A . To prevent queries from unfolding B. To access the full set of SQL functions C. To allow imperative statements D. To benefit from additional SQL optimizationsView AnswerAnswer: D
When you preview calculation view A, what data do you see?
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?A . US for P1 and P2, and GE for P2 B. US for P1 and GE for P1...
