You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify? There are 2 correct answers to this question. Response:
A. LANGUAGE SQLSCRIPT B. WITH RESULTS VIEW C. SEQUENTIAL EXECUTION D. READS SQL DATA
Answer: BD
Question: 2
Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 correct answers to this question. Response:
A. The database administrator might type the name wrong. B. The database administrator should not get those privileges in the production system. C. The focus is on the business requirements. D. The focus is on the database administration requirements.
Answer: BC
Question: 3
Which technologies does SAP HANA use to load more data into memory? There are 3 correct answers to this question. Response:
A. Eliminate indices B. Use RAR compression C. Use dictionary compression D. Store data in column tables E. Use multicore CPU parallelism
Answer: ACD
Question: 4
What does SAP HANA load when starting up and before indicating that it is ready? There are 3 correct answers to this question. Response:
A. All row tables B. All system tables C. All partitions D. Some column tables E. Some row tables
Answer: ABD
Question: 5
For what type of data are SAP HANA calculation views of type dimension used? Please choose the correct answer. Response:
A. Transactional data B. Master data C. Materialized cube data D. Calculated data
Answer: B
Question: 6
What type of input parameters do you use to choose the data from a field in the current table? Please choose the correct answer. Response:
A. Direct B. Derived from table C. Value help D. Column
Answer: D
Question: 7
What happens when you activate an information model? ? There are 2 correct answers to this question. Response:
A. It generates a runtime object. B. It reverts to the active version. C. It checks the validation rules. D. It exports an active version.
Answer: AC
Question: 8
You want to publish your business intelligence content directly to SAP Cloud for Analytics. Which tool do you use? There are 2 correct answers to this question. Response:
A. SAP Predictive Analytics B. SAP Lumira C. SAP Crystal Reports for Enterprise D. SAP BusinessObjects Analysis Mason Rudolph Jersey , edition for Microsoft Office
Answer: AB
Question: 9
Which text feature do you use to find sentiment in textual data? Please choose the correct answer. Response:
A. Full-text index B. Fuzzy text search C. Text analysis D. Text mining
Answer: C
Question: 10
Global session variables can be used in SQLScript to share a scalar value between procedures and functions that are running in the same session. The value of a global session variable is not visible from another session. Please choose the correct answer. Response:
A. SET = ; B. SET = ; C. SET = ; D. SET = ;
Answer: A
Question: 11
Modeling package Shops is a subpackage of package Regions. You want to authorize a user to list the content of package Regions James Washington Jersey , but prevent listing the content of package Shops. How can you achieve this? Please choose the correct answer. Response:
A. Refactor package Shops to another package. B. Assign RT only to package Shops. C. Assign privilege only to package Regions. D. Revoke analytic privileges for models in package Shops.
Answer: A
Question: 12
Which deployment scenario can you use to accelerate reporting from an old SAP R3 4.6C system? Please choose the correct answer. Response:
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
Answer: C
Question: 13
You have logs from a website. How do you show the total number of website visitors that used a mobile phone? There are 2 correct answers to this question. Response:
A. Create a restricted column B. Create an action C. Create a filter expression D. Create a rank column
Answer: AC
Question: 14
For which data types does SAP HANA automatically create full-text indexes? There are 3 correct answers to this question. Response:
A. NVARCHAR B. SHORTTEXT C. BINTEXT D. CLOB E. TEXT
Answer: BCE
Question: 15
Refactoring is used with which of the following actions? Please choose the correct answer. Response:
A. Improving your modeling design B. Translating C. Transporting D. Documenting
Answer: A
Total Views: 57Word Count: 694See All articles From Author