10 exam-style questions with answers and explanations, straight from our 1,030-question bank. Tap an answer to check yourself. When you're ready, take the scored version in the free practice test.
These 10 free C_DBADM questions are organized by exam domain, so you can see how each part of the SAP Certified Associate - Database Administrator - SAP HANA blueprint is tested. Reveal the answer and explanation under each question.
Automatic quota assignment for a service plan has just been enabled in a managed SAP BTP directory. A newly created subaccount receives its quota, but an existing QA subaccount still has none. The directory has enough unallocated quota, and QA needs the service today. How should the global account administrator resolve this gap?
Correct answer: A - Assign the required service-plan quota explicitly to the existing QA subaccount.
A support engineer with the SAP HANA Cloud Viewer role collection can inspect instance metrics. A SQL connection as SUPPORT_R also succeeds, but SELECT * FROM OPS.RUN_STATUS fails with an insufficient-privilege error. The engineer has been assigned to read this table. Which addition is needed?
Correct answer: C - A database grant permitting SUPPORT_R to select from OPS.RUN_STATUS.
A revised monitoring policy is approved for two SAP HANA Cloud instances. In Cloud Central, a DBA creates an alert rule set, selects both instances, and chooses Save. The set's application timestamp is blank; the instances still use their previous settings. How can the approved settings be made effective?
Correct answer: B - Apply the saved rule set to the two selected database instances.
At the end of a reporting batch, an SAP HANA 2.0 on-premises system retains 170 GiB of resident process memory. Cockpit shows 180 GiB allocated, 64 GiB used, and a 200-GiB allocation limit. Used memory has stabilized, services are healthy, and response-time targets are met. An operator suspects a leak from the resident-memory reading. Which response is justified by these observations?
Correct answer: B - Keep the system online and examine used-memory trends by service and table.
SQL statistics for one observation period show: Statement R: 12,000 executions; mean execution time 0.010 seconds Statement S: 80 executions; mean execution time 0.750 seconds A tested change can halve either statement's mean time for equal engineering effort, with execution counts unchanged. The DBA wants the larger reduction in cumulative database execution time. Where should the tuning effort go?
Correct answer: A - Optimize R; halving its runtime saves 60 seconds, compared with 30 seconds for S.
A large historical column table in SAP HANA Cloud is manually unloaded after each monthly report. Memory use falls, then rises again when the next report accesses the table. The historical data must remain in HANA, while memory capacity for active transactions must be preserved. Monthly reporting can tolerate disk reads. Choose the storage change that addresses this recurring demand.
Correct answer: B - Use Native Storage Extension for the historical column-table data.
A recovery plan for an SAP HANA Platform tenant will use Wednesday's incremental as its final data backup, then replay the required logs. The only data backups, in order, are: Sunday: complete Monday: incremental Tuesday: differential Wednesday: incremental All required logs are available. Which data-backup sequence supplies Wednesday's dependencies without including a superseded delta?
Correct answer: C - Sunday complete → Tuesday differential → Wednesday incremental, followed by log replay.
A production SAP HANA Platform tenant is close to exhausting its log volume. Automatic log backups are failing, and backup.log reports permission denied at a backup destination that has ample free space. The DBA can restore the destination's known working permissions immediately. Service must continue with point-in-time recoverability preserved. What should the DBA do first?
Correct answer: C - Restore write access at the backup destination and verify that automatic log backups resume.
An analyst's query of an SAP HANA Cloud calculation view succeeds but returns only North-region rows. SELECT on the view is effective, and analytic-privilege checks are enabled. Neither the query nor the view definition filters by region. The analyst now needs South-region rows through the same view, without direct table access. Which authorization must be extended?
Correct answer: D - An analytic privilege permitting the South rows through the calculation view.
An SAP HANA Cloud team lead must grant the existing role R_REPORT to colleagues without broader role-administration authority. Which assignment by an authorized grantor permits this?
Correct answer: D - Grant R_REPORT to the lead WITH ADMIN OPTION.
The full bank has 1,020 more C_DBADM questions with explanations.
Continue in the free practice test →
View plans