Practice Questions
These practice questions will help you evaluate your understanding of the topics covered in this chapter. The questions shown are similar in nature to those found on the certification examination. Although none of these questions will be found on the exam itself, they will allow you to review your knowledge of the subject. Select the correct answers and then check the completeness of your answers in the Practice Question Answers and Explanations section. Remember that on the exam you must select all correct answers and only correct answers to receive credit for the question.
- Which technologies does SAP HANA use to load more data into memory? (There are 3
correct answers.)
A. Eliminate indices
B. Use RAR compression
C. Use dictionary compression
D. Store data in column tables
E. Use multicore CPU parallelism - True or False: With SAP HANA, you can run OLAP and OLTP together in one system with good performance.
A. True
B. False - True or False: SAP HANA contains both row and column tables.
A. True
B. False - How do you move code to SAP HANA? (There are 2 correct answers.)
A. Delete the application server
B. Use stored procedures in SAP HANA
C. Use graphical data models in SAP HANA
D. Use row tables in SAP HANA - In which SAP HANA solution do you eliminate stored data, like year-to-date figures?
A. SAP BW on SAP HANA
B. SAP CRM on SAP HANA
C. SAP S/4HANA
D. SAP HANA Enterprise Cloud - Which deployment scenario can you use to accelerate reporting from an old SAP R/3 4.6C system?
A. SAP HANA as a database
B. SAP HANA as a platform
C. SAP HANA as a sidecar solution
D. SAP HANA multitenant database containers - In which deployment scenarios does security stay in the application server, and end users do not log into the SAP HANA system? (There are 2 correct answers.)
A. SAP HANA as a platform with an SAP HANA XS application
B. SAP HANA as a database
C. SAP HANA as a sidecar solution
D. SAP HANA as an accelerator - For which deployment scenario does SAP deliver prebuilt data models?
A. SAP HANA as a platform
B. SAP HANA as a sidecar solution
C. SAP HANA as an accelerator
D. SAP HANA on the cloud - True or False: SAP HANA is just a database.
A. True
B. False - What is normally used to build SAP HANA XS applications inside SAP HANA? (There are 2 correct answers.)
A. Java
B. JavaScript
C. SAPUI5
D. ABAP - Which type of cloud solution is SAP HANA Enterprise Cloud (HEC) an example of?
A. Platform as a Service (PaaS)
B. Infrastructure as a Service (IaaS)
C. Software as a Service (SaaS)
D. Managed Cloud as a Service (MCaaS) - Which type of cloud solution is Amazon Web Services (AWS) an example of?
A. Hybrid cloud
B. Public cloud
C. Private cloud
D. Community cloud - True or False: VMware vSphere virtual machines are fully supported for productive SAP HANA instances.
A. True
B. False - You use parallelism to calculate a year-to-date value quickly, and you eliminate a table from the database. What are some of the implications of this action? (There are 3 correct answers)
A. Smaller database backups
B. Less code
C. Better user interfaces
D. Faster response times
E. Faster inserts into the database - What enables the delta buffer technique to speed up both reads and inserts in SAP HANA?
A. Using column-based tables only
B. Using row-based tables only
C. Using both row-based and column-based tables
D. Using only the insert-only technique - What technique is used to convert record updates into insert statements in the delta
buffer?
A. Unsorted inserts
B. Insert-only
C. Sorted inserts
D. Parallelism - What phrase describes the main table area in the delta merge scenario?
A. Read-optimized
B. Write-optimized
C. Unsorted inserts
D. Row store - What does the C in ACID-compliant stand for?
A. Complexity
B. Consistency
C. Complete
D. Constant - Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution? (There are 3 correct answers.)
A. Partitioning
B. Disaster recovery
C. High availability
D. Failover
E. Backups - Which words are associated with the log volume? (There are 2 correct answers.)
A. Synchronous
B. Transaction manager
C. Page manager
D. Savepoint - Of which SAP HANA process are the transaction manager and page manager a part?
A. SAP HANA XS server
B. Statistics server
C. Index server
D. Name server - What type of load does SAP HANA perform when starting up?
A. Lazy load
B. Complete load
C. Fast load
D. Log load - What does SAP HANA load when starting up and before indicating that it is ready? (There are 3 correct answers.)
A. All row tables
B. All system tables
C. All partitions
D. Some column tables
E. Some row tables