Question 1

A database administrator wants to clone an SQL database that has Transparent Data Encryption (TDE) enabled. Which two steps must be taken on the target server for this clone to be successful? (Choose two.)

Options :

A : Backup the .cer and .pvk files from the source database server VM.

B : Backup the keystore bundle file from the source database server VM.

C : Run the pre-clone command script.

D : Run the post-clone command script.

Answer: B,D

Question 2

An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state. Which two restore options could be used? (Choose two.)

Options :

A : Most Recent Time Available

B : Snapshot

C : Tail Logs Backup

D : Point in Time

Answer: B,D

Question 3

Before registering a database server VM to NDB, what should an administrator use to verify all required software and configuration dependencies?

Options :

A : LCM

B : Upgrade Software

C : Prerequisites script

D : NCC

Answer: C

Question 4

Which NDB feature collects logs and snapshots from databases?

Options :

A : Database Restore

B : Time Machine

C : SLA

D : One-click Patching

Answer: B

Question 5

What step should be taken to make the profile available to all users:

Options :

A : Create an Access Control role with the Create Profile right and assign to all users.

B : Create an Access Control group with the desired users and grant it the Database Admin role.

C : Update the profile and set the status to Published.

D : Update the profile and set available state to All.

Answer: D