What type of SQL statements are supported in creating SQL explain plans in SAP HANA?
Correct
Incorrect
Question 2 of 13
2. Question
In which format does a data profiling outcome gets saved?
Correct
Incorrect
Question 3 of 13
3. Question
Which of the following element in a stored procedure in SQL statement is used to specify that the procedure cannot perform modifications in the database? (It can only be used to call other procedures)
Correct
Incorrect
Question 4 of 13
4. Question
Comment on the following statement.“If the name of a public and a private synonym is identical, then the system will give precedence to the private synonym.”
Correct
Incorrect
Question 5 of 13
5. Question
In which type of SQL statements are the keywords GRANT and REVOKE used in?
Correct
Incorrect
Question 6 of 13
6. Question
Which of the following mode of replication is ideal for multi-tier system replication setups whose primary concern is data security and protection?
Correct
Incorrect
Question 7 of 13
7. Question
Which compression technique cuts a long value ID array into small chunks of 1024 elements each?
Correct
Incorrect
Question 8 of 13
8. Question
Using which importing method can all the table definitions residing in SAP ERP source systems be imported?
Correct
Incorrect
Question 9 of 13
9. Question
Which of the following is a direct method of user authentication using tickets?
Correct
Incorrect
Question 10 of 13
10. Question
What type of HANA users cannot create objects in their database schema?
Correct
Incorrect
Question 11 of 13
11. Question
Which privilege grants the permission to access and modify all the packages in the repository?
Correct
Incorrect
Question 12 of 13
12. Question
What type of HANA license key are you using if it is to expire after 90 days?
Correct
Incorrect
Question 13 of 13
13. Question
What is the common target location of Audit trail targets of SAP HANA auditing information?
Correct
Incorrect
Hope, you liked the set of questions in this Quiz.
If you have any queries related to SAP HANA quiz questions and answers, feel free to ask in the comment section.
Did you like our efforts? If Yes, please give DataFlair 5 Stars on Google | Facebook
Hi, I’m enjoying your quiz and learning a lot about SAP HANA. I believe your answer to Q7 is incorrect. I believe what’s described is run-length encoding, not prefix encoding.
Hi, I’m enjoying your quiz and learning a lot about SAP HANA. I believe your answer to Q7 is incorrect. I believe what’s described is run-length encoding, not prefix encoding.