In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question.
A. The table contains data that you want to aggregate.
B. The table contains only a small number of records.
C. The table contains mainly distinct values per column across rows.
D. The table contains text that you want to search.
To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question
A. The new table always has a 2:2 mapping between the file and table columns
B. When loading new data in the table, it gets appended to the existing data
C. The application suggests the column name and data type for the new tables, and it is possible to edit them
D. The supported file types for upload are: .cssv, .xlls, and .xlsxxx
What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.
A. Sales
B. Stock
C. Procurement
D. Product
E. Services
When are referential joins executed in analytical views? Choose the correct answer
A. When fields are selected
B. When fields from both the tables are requested
C. When fields are optimized
D. When all the tables are optimized
What made SAP HANA possible?
There are 2 correct answers to this question.
A. CPU with single core network
B. Improved hardware technology
C. Technology and innovations
D. RAM limitation
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.
A. Innovation based on SAP HANA
B. Server based on SAP HANA
C. Data Mart based on SAP HANA
D. New or Native SAP HANA
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?
There are 2 correct answers to this question
A. High availability configuration
B. Services-Name and index server on all nodes
C. Shared file systems for only one server
D. Active clusters for all servers
What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.
A. Applying Code inspector
B. Display record of all database access
C. Detect redundant or identical select statements
D. Locate database performance issues
E. Locate work base issues
How to create a core data services view? There are 3 correct answers to this question.
A. Use data services tools for updates
B. Use the ABAP Development Tools for SAP NetWeaver.
C. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view
D. Use additional annotations ?marked with the @ sign
E. Use SQL capabilities for Netweaver
Discuss different types of engines associated with The SAP HANA architecture?
There are 2 correct answers to this question
A. Join engine
B. OLAP engine
C. Analytic engine
D. OPAX engine
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question
A. Automatically
B. Manually
C. By Importing a Landscape
D. By Resource console
Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.
A. New advanced SQL syntax Procedures
B. ABAP-Managed Database Procedures
C. Programming model
D. Table buffering
The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question.
A. Creating Method Implementations from the Method Definition
B. Creating Method Definitions from Implementation Parts
C. Creating Parts for Interface Methods
D. Creating interface from Method Calls
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.
A. Create a graph comparing the runtimes of ABAP code before and after optimization.
B. Combine information from static ABAP code scans with runtime data from the SQL Monitor.
C. Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
D. Estimate the new total runtime of optimized code.
How will you select a preference for Validation rules? Choose the correct answer
A. Windows- SAP HANA-Preferences-Modeler-Validation Rules
B. Windows- Modeler -Preferences-SAP HANA-Validation Rules
C. Windows- Preferences-SAP HANA-Modeler-Validation Rules
D. Windows- SAP HANA-Modeler-Preferences-Validation Rules