Dive into practice questions
Question 1
A database administrator needs to implement a caching database. Which of the following is the best database type for this task?
A. In-memory
B. Key-value
C. Vector
D. Document
Question 2
A database administrator must be able to restore a database in six hours or less. Which of the following best describes this goal?
A.Recovery time objective (RTO)
B. Recovery point objective (RPO)
C. Service Principal Name (SPN)
D. Service-level agreement (SLA)
Question 3
The products table has millions of rows, and users report that the products search page is very slow. Which of the following maintenance processes will fix this issue?
A. Partitioning
B. Index optimization
C. Patch management
D. A database refresh
Question 4
A database administrator needs to change records in the customer's table with values from 601-XXX to 901-XXX. Which of the following Structured Query Language (SQL) commands should the administrator use to complete this task?
A. MERGE
B. INSERT
C. UPDATE
D. ALTER
Question 5
Which of the following environments requires the most planning effort but provides maximum control over operations and configuration?
A. Infrastructure as a service (IaaS)
B. Database as a service (DBaaS)
C. Platform as a service (Paas)
D. Software as a service (SaaS)
Answer key
Question 1: B (Key-value)