Exam Questions and Answers for C_HANAIMP_17 Study Guide Questions and Answers!
SAP Certified Application Associate - SAP HANA 2.0 (SPS05) Certification Sample Questions and Practice Exam
NEW QUESTION 14
Which deployment scenario can you use to accelerate reporting from an old SAP R/3 system?
Please choose the correct answer.
Response:
- A. SAP HANA as a database
- B. SAP HANA as a platform
- C. SAP HANA as a side-by-side accelerator
- D. SAP HANA Multitenant Database Containers (MDC)
Answer: C
NEW QUESTION 15
How can you optimize performance when writing SQL for use with calculation views?
There are 2 correct answers to this question.
Response:
- A. Use declarative language instead of cursors
- B. Use calculation engine (CE) functions instead of plain SQL
- C. Increase paralization by using variables to break up statements
- D. Control the flow logic using IF-THEN-ELSE conditions
Answer: A,C
NEW QUESTION 16
Which of these is used to build the virtual data model for SAP S/4HANA?
Please choose the correct answer.
Response:
- A. Universe
- B. SAP HANA CDS
- C. ABAP CDS
- D. SAP HANA Live
Answer: C
NEW QUESTION 17
Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot?
Please choose the correct answer.
Table A Output A
Year Value 2014 2015 2016
2014 100 300 500 200
2014 200
2015 100
2015 100
2015 200
2015 100
2015 200
Response:
- A. Create a filter expression that uses an OR operator
- B. Create a restricted column for each year
- C. Implement a union node and map each year as a separate column
Answer: C
NEW QUESTION 18
Which hierarchies can you enable for SQL access?
Please choose the correct answer.
Response:
- A. Time-dependent hierarchies in a dimension view
- B. Local hierarchies in a star join view
- C. Shared hierarchies in a star join view
- D. Level hierarchies in a calculation view of type cube
Answer: C
NEW QUESTION 19
What performance technique should you implement to improve join performance?
Please choose the correct answer.
Response:
- A. Do NOT use dynamic joins if you require optimal performance.
- B. Join on key fields between tables in a dimension view.
- C. Always use referential joins in star join views.
- D. Use joins instead of unions for combining large datasets.
Answer: B
NEW QUESTION 20
Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 2 correct answers to this question.
Response:
- A. Backups
- B. Disaster recovery
- C. High availability
- D. Failover
Answer: C,D
NEW QUESTION 21
Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?
Please choose the correct answer.
Response:
- A. Creating a REST web service in the SAP HANA XS engine
- B. Creating a CompositeProvider in SAP BW
- C. Creating a report in SAP Crystal Reports for Enterprise
- D. Creating business intelligence content with SAP Lumira, designer edition
Answer: D
NEW QUESTION 22
What is a multistore table?
Please choose the correct answer.
Response:
- A. A table that can hold data in row and column orientation
- B. A table that can distribute its partitions across memory and extended storage tiers
- C. A table that can be shared across multiple instances of HANA
- D. A table that can be shared across multiple instances of SAP HANA Cockpit
Answer: B
NEW QUESTION 23
What conditions must be met to ensure the Dynamic join feature works properly?
There are 2 correct answers to this question.
Response:
- A. At least one joined column must be specified in the query.
- B. Cardinality must be set
- C. The join must be defined on key columns
- D. Multiple columns must be defined in the join
Answer: A,D
NEW QUESTION 24
Your calculation view presents employee names which must only be seen by managers. Which steps are required to implement this?
There are 2 correct answers to this question.
Response:
- A. Include an anonymization node in the calculation view
- B. Set the column to hidden in the calculation view
- C. Create SQL expression to define the concealing logic for the column
- D. Assign the UNMASK privilege to the managers for the calculation view
Answer: A,C
NEW QUESTION 25
What is the correct sequence for loading data with SAP Data Services?
Please choose the correct answer.
Response:
- A. Load - Extract - Transform
- B. Load - Transform - Extract
- C. Extract - Transform - Load
- D. Extract - Load - Transform
Answer: C
NEW QUESTION 26
When can you expose a hierarchy that is defined in a calculation view for access with SQL?
Please choose the correct answer.
Response:
- A. When the hierarchy is a local hierarchy
- B. When the hierarchy is defined in a calculation view of DEFAULT
- C. When the hierarchy is defined in a calculation view of type CUBE
- D. When the hierarchy is a shared hierarchy
Answer: C
NEW QUESTION 27
In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?
Please choose the correct answer.
Response:
- A. CDS View
- B. Table function
- C. Scalar function
- D. Procedure
Answer: B
NEW QUESTION 28
A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
Response:
- A. Use a right outer join.
Filter to show only customers on the left table. - B. Use a left outer join.
Filter to show only the NULL values on the right table. - C. Use a right outer join.
Filter to show only the NULL values on the right table. - D. Use a left outer join.
Filter to show only customers on the right table.
Answer: B
NEW QUESTION 29
What is the recommended way to create full-text indexes?
Please choose the correct answer.
Response:
- A. Procedures
- B. Core Data Services
- C. SQL statements in the SQL console
- D. User-defined functions
Answer: B
NEW QUESTION 30
In Web IDE for SAP HANA, what can I create in a HDB module?
There are 3 correct answers to this question.
Response:
- A. Calculation View
- B. HTML file
- C. Analytic Privilege
- D. Flowgraph
Answer: A,C,D
NEW QUESTION 31
You have copied a design-time file from a source folder to a target folder that has the same namespace setting. In which of the following scenarios will a build of the copy design-time file be successful?
There are 2 correct answers to this question.
Response:
- A. The build of the copy design-time file will always be successful
- B. The source design-time file has been deleted from the source folder in the meantime.
- C. The source design-time file has been built once but the built has failed.
- D. The source design-time file has never been built.
Answer: C,D
NEW QUESTION 32
You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation view that is only consumed by one cube calculation view.
- In the dimension calculation view, you change the name of a column that is referenced by the cube calculation view.
- You then accidentally delete the design-time object of the cube calculation view.
During the build, which of the following scenarios are possible?
There are 2 correct answers to this question.
Response:
- A. When you build the HDB module, the build is successful.
- B. When you build only the dimension calculation view, the build fails.
- C. When you build only the dimension calculation view, the build is successful.
- D. When you build the HDB module, the build fails.
Answer: A,B
NEW QUESTION 33
Which sentence best describes SAP HANA Live?
Please choose the correct answer.
Response:
- A. Operational reporting moving back to the OLTP system
- B. Analytical reporting moving back to the OLTP system
- C. Analytical reporting moving back to the OLAP system
- D. Operational reporting moving back to the OLAP system
Answer: A
NEW QUESTION 34
Referring to the diagram which privileges would a user require to view United States data when querying the CUBE Calculation view?
Please choose the correct answer.
Response:
- A. ASELECT privilege and an analytic privilege (Country = United States) on the DIMENSION calculation view
- B. A SELECT privilege on the CUBE and an analytic privilege (Country = United States) on the DIMENSION calculation view
- C. SELECT privileges and Analytic Privileges on both views
- D. Analytic Privilege and SELECT privilege on the CUBE calculation view
Answer: B
NEW QUESTION 35
When can you use the referential join?
Please choose the correct answer.
Response:
- A. When you have to report on all posted facts
- B. When you have to report on facts with matching dimensions
- C. When you have to report on all dimensions to confirm if there are matching facts or not.
- D. When referential integrity is assured
Answer: D
NEW QUESTION 36
What information can you find in Performance Analysis Mode when you view the analysis for a Join node?
There are 2 correct answers to this question.
Response:
- A. Total number of records returned by the node
- B. Tables used by the join in the node
- C. Time taken by the join
- D. Suggested filter for the tables in the Join node
Answer: A,B
NEW QUESTION 37
What can be used to return multiple result sets?
Please choose the correct answer.
Response:
- A. Table function
- B. Scalar function
- C. Procedure
- D. View
Answer: C
NEW QUESTION 38
What are features of Business Suite on SAP HANA?
There are 2 correct answers to this question.
Response:
- A. Embedded Analytics
- B. ABAP is replaced with JAVA
- C. Massive performance improvement
- D. Combine operational analytics and transaction processin
Answer: C,D
NEW QUESTION 39
......
C_HANAIMP_17 certification dumps - SAP Certified Application Associate C_HANAIMP_17 guides - 100% valid: https://www.testkingit.com/SAP/latest-C_HANAIMP_17-exam-dumps.html