123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Education >> View Article

C_hanatec_11 Exams Study Guides

Profile Picture
By Author: rocky hughes
Total Articles: 42
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Question: 1

You are installing SAP HANA using hdblcmgui and want to ensure that the SAP Hana database is automatically started when the host is restarted.
How do you accomplish this?
Please choose the correct answer.
Response:

A. set the environment parameter ‘auto start = yes’ before you execute hdblcmgui
B. set the environment parameters ‘auto start = true’ before you execute hdblcmgui
C. Execute hdblcmgui and select ‘restart instance after machine reboot?’
D. execute the resident hdblcmgui and set the parameter to ‘autostart = 1’

Answer: D

Question: 2

A user is locked due to too many failed login attempts Which SQL commands can solve this problem?
Please choose the correct answer.
Response:

A. ALTER USER DISABLE PASSWORD LIFETIME
B. ALTER USER RESET CONNECT ATTEMPT
C. ALTER USER FORCE PASSWORD CHANGE
D. ALTER USER ACTIVE USER NOW

Answer: B

Question: 3

You want to measure the impact of a new workload on the memory usage of the SAP HANA services ...
... Which memory indicator would you reset?
Please choose the correct answer.
Response:

A. virtual memory
B. Peak used memory
C. Used memory
D. Resident memory

Answer: B

Question: 4

Which delivered role is mandatory for a system administrator in SAP HANA?
Please choose the correct answer.
Response:

A. CONTENT_ADMIN
B. IC MODELER
C. SYS_ADMIN
D. SAP_ALL

Answer: A

Question: 5

How can you remove add data backups both from the backup catalog and physically from the server?
Please choose the correct answer.
Response:

A. Select a backup on the backup catalog tab of the backup console and select delete older backups from the context menu.
B. execute the command backup.sh -id -cl from the operating system
C. execute the SQL statement DELETE from m_backup_catalog where backup_ID = 2 from the SQL console
D. open a shell and delete all files under $(DIR_INSTANCE) backup data

Answer: A

Question: 6

What happens when an SAP Hana system is restarted?
There are 2 correct answers to this question
Response:

A. All row tables are loaded into the memory except the row table that are configured to be loaded on demand
B. column tables and column table attributes that were loaded before the restart reloaded into the memory asynchronously
C. tables and table attributes that are marked for preload are loaded into the memory synchronously
D. all row tables and row table attributes are loaded into the memory

Answer: CD

Question: 7

For one-step logon to the system on the PARMA host with instance number 01 as database user MONA with the password RED, which of the following command helps?
Please choose the correct answer.
Response:

A. hdbsql -n PARMA -i 1 -u MONA –p RED
B. hdbsql -n PARMA -p 1 -u MONA –i RED
C. hdbsql -i PARMA -n 1 -u MONA –p RED
D. hdbsql -p PARMA -i 1 -u MONA –n RED

Answer: A

Question: 8

Which monitoring view provides information on the analytic privileges that apply to a view and to authorized users?
Please choose the correct answer.
Response:

A. ACCESSIBLE_VIEWS
B. EFFECTIVE_PRIVILEGES
C. GRANTED_PRIVILEGES
D. EFFECTIVE_STRUCTURED_PRIVILEGES

Answer: D

Question: 9

For the most part, CDS works in SAP HANA XS advanced deployment infrastructure (HDI) just like it does in the SAP HANA XS classic Repository. Which of the following annotations are not supported in SAP HANA XS advanced HDI?
There are 3 correct answers to this question.
Response:

A. @Schema
B. @SearchIndex
C. @GenerateTableType
D. @WithStructuredPrivilegePost
E. @nokeyStructured

Answer: ABC

Question: 10

Trace files are used to troubleshoot problems in the SAP HANA database, which of the following Trace types helps to generate Trace files through its activation?
There are 3 correct answers to this question
Response:

A. SQL trace
B. Database trace
C. Performance trace
D. Security trace
E. System trace

Answer: ABC

Question: 11

Which of the following must be installed during the installation of SAP Landscape Transformation (SLT)?
There are 2 correct answers to this question.
Response:

A. SAP NetWeaver 7.02 or higher
B. DMIS add-on to the SAP source system
C. SAP HANADB libraries to the source system
D. Java stack for the SLT Server

Answer: AB

Total Views: 190Word Count: 662See All articles From Author

Add Comment

Education Articles

1. Top 10 Techniques For Brainstorming - Swiflearn
Author: Priyanshu Rawat

2. Top 8 On- Line Knowledge Science Programs
Author: ExcelR Solutions

3. Data Analyst Course In Kolkata With Placement Help
Author: Ravi Dulla

4. Rtl Design Training | Fpga Design Training Institutes With Placement
Author: manoj manuu

5. How Students Can Boost Their Performance With Online Education - Swiflearn
Author: Priyanshu Rawat

6. Best Mppsc Coaching Centres In Indore – Top Mppsc Exam Institutions
Author: jyiti makhija

7. Dussehra Essay In English 500 Words
Author: Dark Odisha

8. Mahalaxmi And Narayan Workshop By Neetu Jha | Pvhh
Author: PUSHPA VIVEKA HEALING HOME

9. Online Learning Can Replace Classroom Education
Author: Online learning can replace classroom education

10. Top Five Educational Apps For Children
Author: Ideal Education Point (NCPS)

11. Stenoguru Online Typing Speed Test Tool
Author: Stenoguru

12. Money Education Classes In Albuquerque - Swiflearn
Author: Priyanshu Rawat

13. The Best Assignment Writing Services In The Uk
Author: Joel Griffin

14. Bachelors Degree Program | Ug Admission For International Student
Author: karanpatil

15. Forex Trading Courses In Chennai
Author: Vasugi S

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: