[Dec-2021] C_HANATEC_17 Pre-Exam Practice Tests | Exam Questions and Answers for SAP Certified Technology Associate Study Guide
SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Certification Sample Questions
NEW QUESTION 117
You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory allocated and service 2 has 40 GB allocated. What is the effective allocation limit of service 3?
- A. 35 GB
- B. 100 GB
- C. 90 GB
- D. 25 GB
Answer: D
NEW QUESTION 118
Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question.
- A. Views
- B. Sequences
- C. Tables
- D. Procedures
Answer: A,D
NEW QUESTION 119
You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.
- A. ALTER USER <USERNAME> ENABLE CLIENT CONNECT
- B. ALTER USER <USERNAME> ACTIVATE USER NOW
- C. ALTER USER GRANT CREATE ANY ON OWN SCHEMA
- D. ALTER USER <USERNAME> GRANT ROLE PUBLIC
- E. ALTER USER <USERNAME> ADD REMOTE IDENTITY
Answer: A,C,D
NEW QUESTION 120
Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system. Which of the following options are listed? There are 3 correct answers to this question.
- A. Memory Management
- B. Performance Management
- C. Resource Management
- D. Security
- E. Monitoring and Administration
Answer: B,D,E
NEW QUESTION 121
Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.
- A. Uncommitted changes in the first delta storage are rolled back.
- B. The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage.
- C. The content of the complete main storage is persisted to disk.
- D. All write operations go to the second delta storage.
Answer: C,D
NEW QUESTION 122
You are installing several SAP HANA systems with a standard setup. How can you automate this activity?
- A. Copy the complete install folders to all hosts
- B. Export and import the standard configurations from SAP HANA cocpit
- C. Generate a configuration template using hdblcm
- D. Copy the ini files to all systems
Answer: C
NEW QUESTION 123
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question.
- A. Measurement of data throughput between the Linux kernel and CPU
- B. Measurement of data throughput between SAP HANA nodes and storage
- C. Measurement of the data throughput between CPU and DRAM
- D. Validation of the operating system configuration settings for the Linux kernel
- E. Validation of the LPAR configuration settings on IBM Power servers
Answer: B,D,E
NEW QUESTION 124
A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system privileges do you assign to the technical user account on the target system?
- A. USER ADMIN
- B. MONITOR ADMIN
- C. DATA ADMIN
- D. CATALOG READ
Answer: D
NEW QUESTION 125
When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.
- A. When you need to extend the scale-out memory
- B. When you need to optimize the standby node memory.
- C. When you need to actively free up memory.
- D. When you need to measure total memory
Answer: C,D
NEW QUESTION 126
Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? There are 3 correct answers to this question.
- A. Create dedicated tenant OS users for each tenant.
- B. users to the <sid> shm group.
- C. Lock the adm OS user \/ O Add dedicated tenant
- D. Add dedicated tenant OS users to the sapsys group.
- E. Remove the <sid> adm OS user from the sapsys group.
Answer: A,B,D
NEW QUESTION 127
How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?
- A. Set up cross-database access control
- B. Assign internal communication ports
- C. Set database isolation levels to high
- D. Edit the configuration change blacklist
Answer: D
NEW QUESTION 128
What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question.
- A. Hard
- B. Auto
- C. Smart
- D. Critical
Answer: B,D
NEW QUESTION 129
Which diagnostic file can you use to monitor the status of database recovery?
- A. sapstartsrv.log
- B. backup.log
- C. available.log
- D. backint.log
Answer: B
NEW QUESTION 130
You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and user management. Which deployment scenario do you use?
- A. Multiple Components on One System (MCOS)
- B. Multiple Components on One Database (MCOD)
- C. Multitenant database containers (MDC)
- D. Technical co-deployment (TCD)
Answer: C
NEW QUESTION 131
You need to analyze the high CPU load of running thread in more detail in the Thread Monitor. Which parameters do you need to change? Note: There are 2 correct answers.
- A. cpu_time_measurement_mode
- B. enable_tracking
- C. threshold_cpu_time
- D. load_monitor_granularity
Answer: A,D
NEW QUESTION 132
You investigate a hung SAP HANA database, and you CANNOT identify the blocking transactions. What causes could lead to this behavior? Note: There are 2 correct answers.
- A. A wrong role of a service in a failover situation
- B. A setting to restrict CPU usage
- C. An issue with the delta merge
- D. A long savepoint duration
Answer: B,D
NEW QUESTION 133
Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.
- A. EXT3
- B. GPFS
- C. Dxfs
- D. MPFS
Answer: A,B
NEW QUESTION 134
Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.
- A. SAP Intelligent Query
- B. SAP Business Intelligence
- C. SAP Adaptive Server Enterprise
- D. SAP Analytics Cloud
Answer: B
NEW QUESTION 135
In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.
- A. Customers are new to SAP applications and SAP HANA
- B. Consolidating multiple ERP source systems into one ERP system on SAP HANA
- C. Carving out ERP functionality from the source system to the ERP on SAP HANA system.
- D. Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA
Answer: B,C
NEW QUESTION 136
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question.
- A. Custom
- B. Production
- C. Development
- D. Sandbox
- E. Test
Answer: B,C,E
NEW QUESTION 137
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.
- A. Delta data shipping takes place every 5 minutes.
- B. Delta data shipping takes place in addition to continuous log replay.
- C. Delta data shipping takes place with continuous read-only access to the secondary system.
- D. Delta data shipping takes place in addition to continuous log shipping.
Answer: B,D
NEW QUESTION 138
How can you shorten the delta merge runtime of a table?
- A. Fully load the delta store into memory
- B. Merge per column
- C. Partition the table
- D. Perform memory-only delta merges
Answer: C,D
NEW QUESTION 139
......
SAP Exam Practice Test To Gain Brilliante Result: https://vcepractice.pass4guide.com/C_HANATEC_17-dumps-questions.html