Oracle Cloud Platform Data Management 2019 Associate (1Z0-1044) Free Practice Test

Question 1

You are preparing to migrate a 12c non-CDB On-Premises DB using the "RMAN Transportable Tablespace with Data Pump method.
Which three of these step are mandatory?

A. You need to make sure source and destination character sets are compatible.

B. You have to create a DB System with same version as source DB or higher.

C. You must have your SSH keys ready before creating the OCI DB system.
CJ You have to create a DB System with same version as source DB.

D. You must shut down the source database to take a cold backup before migration.

Correct Answer: A,B,C

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

Question 2

You want to create database systems in OCI that support on-demand CPU scaling and access from on-premises applications using public Internet.
Which two steps should you perform?

A. Use VM compute shapes in OCI.

B. Create VCN with Service Gateway.

C. Use Bare Metal compute shapes in OCI.

D. Configure IPSec VPN Tunnel.

E. Configure FastConnect service.

Correct Answer: B,C

Question 3

What are the valid connectivity options for uploading files Into OCI DB Systems, in order of preference?

A. Service Gateway, IPSec VPN, FastConnect

B. FastConnect, IPSec VPN, Internet Gateway

C. FastConnect, IPSec VPN, Service Gateway

D. Internet Gateway, FastConnect, IPSec VPN

Correct Answer: B

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

Question 4

Identify three core themes for Oracle Cloud Infrastructure (OCI).

A. Mix and Match

B. Lift and Shift

C. Infrastructure heavy workloads

D. Cloud Native Workloads

E. Refactor and Redesign

Correct Answer: B,C,D

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

Question 5

Which two statements are true about Interface for Exadata I/0 Resource Management (IORM)?

A. IORM allows workloads and databases to share I/0 resources automatically according to user requests.

B. IORM allows workloads and databases to share I/0 resources automatically according to user-defined policies.

C. IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service.

D. IORM can be enabled across multiple databases using the Cloud interface of Exadata Cloud Service.

Correct Answer: B,D

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

Question 6

You have already created Exadata DB System with Oracle Grid Infrastructure 12c Release 1. You want to upgrade Orade Grid Infrastructure to Oracle 12c Release 2 of the Exadata Cloud Service.
Which two statements are true about ensuring a successful upgrade?

A. You cannot later use the self-service web interfaces to upgrade a version 12. 2 Database Deployment.

B. You must manually upgrade to Oracle Grid Infrastructure 12c R2

C. Your must manually upgrade to Oracle Grid lnfrastructure 12c R2 and use self-service web interface acces to create version 12.2 Database Deployment.

D. You can use the self-service web interfaces to upgrade a version 12.2 Database Deployment.

Correct Answer: C

Question 7

You decide to use the unplug/plug method to migrate a 12c non-CDB on-premises database to an 18c OCI DB Service. What is the correct sequence of steps?

A. Invoke DBMS_PDB. DESCRIBE in the source , transfer XML files and datafiles, create a destination PDB, execute noncdbto_pdb.sql in the destination, open the destination PDB and invoke dbupgrade.

B. Invoke DBMS_PDB.DESCRIBE in the source, create a destination PDB, execute noncdb_to_pdb.sql on the destination, and open the destination PDB.

C. Perform a clean shutdown of source database, transfer the files, create a destination PDB and execute noncdb_to_pdb. sql in the destination CDB

D. Invoke DBMS_PDB.DESCRIBE in the destination , transfer XML and data files, create a destination PDB, execute noncdb_to_pdb. sql in the source, open the destinatipn PDB and invoke dbupgrade.

Correct Answer: A

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

Question 8

Which three are prerequisites for connecting to a database In the DB system using SQL Developer?

A. User OCID

B. editing the security list In VCN, which is used by the DB system, to open port 1521

C. creating a temporary SSH tunnel from the local system to DB system

D. Public Key

E. Private key

F. editing the route tables in VCN, which is used by the DB system, to open port 1521

Correct Answer: B,C,E

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

Welcome to TestSimulate

Oracle Cloud Platform Data Management 2019 Associate (1Z0-1044) Free Practice Test