Oracle Cloud Platform Data Management 2019 Associate

QUESTION NO: 1
Which option represents valid functionalities/step in SQL Developer that is used for migrating on-premises databases to OCI DB Systems?

A. Create DDL Statements + MERGE statements to modify the imported data B. Create DDL Statements + SQL *Loader control and data files C. Create Data Pump Dumpfiles that can be imported normally using that tool at destination D. Create Data Pump Dumpflles + SQL *Loader control and data files

Correct Answer: D

QUESTION NO: 2
To meet a customer's requirement, you are planning to create a new database deployment on an Exadata Database System. You want to configure automatic backups for your newly created database using the dbaas api utility.
What are the two steps that are required to complete your tasks?

A. First connect to the compute node as oracle user. B. First connect to the compute node as opC user. C. First connect to the compute node as root user D. Create a JSON file.

Correct Answer: C,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
You are required to migrate data using a flat file to the Autonomous Database and you decide to use SQL Developer Data Import Wizard.
Which two locations for files are allowed?

A. Oracle Cloud Storage B. Files on user PC C. Remote database files D. Dropbox

Correct Answer: A,C

QUESTION NO: 4
Which users created on Database Servers can be used for both Orade database and host management of your Exadata Cloud at Customer Services?

A. root, oracle, and grid users B. root, opc, oracle, and grid users C. opc, oracle, and grid users D. root, opc, oracle, grid, and cloud users

Correct Answer: A

QUESTION NO: 5
Examine the command:
[root@sadb ~Jt dbcli update-database -bi 78a2a5f0-72bl-448f-bd86-cf4lb30b64ee -i 1lec8335-113a-46e3-b8lf- 23Sf4dlb6fde Which IDs are used in the command and In what order?

A. database ID, object storage ID B. configuration ID, database ID C. job ID, database ID D. database ID, job ID

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
You decide to migrate a 12c On-Premises PDB to a 12c OCI DB system using the plug/unplug method.
The source database Is not using TDE.
What is the best way of performing this migration?

A. Your only option is to enable tablespace-level TDE at t he destination database B. You don't need to do anything about TDE, as OCI DB System Databases are not using it by default. C. Your only option is to enable tablespace-level TDE at the source database before migration. D. You must enable tablespace-level TDE, either at the origin or the destination databases.

Correct Answer: D

QUESTION NO: 7
What four values are required when creating a database system In OCI?

A. VCN B. Availabillty domain C. Shape D. SSH private key E. Fault Domain F. SSH public key

Correct Answer: A,B,C,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
What activity can a database administrator perform when working with Autonomous Database Dedicated?

A. Create Autonomous Container Database B. Create Autonomous Databases C. Create Autonomous Exadata Infrastructure D. Terminate Autonomous Container Databases

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

Oracle Cloud Platform Data Management 2019 Associate - 1Z0-1044 Exam Questions