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

Question 1

Identify two correct statements for an OCI public load balancer.

A. requires two availability domains for HA

B. only serves one region

C. can serve multiple regions

D. offered as a single shape

E. requires only one availability domain for HA

Correct Answer: A,B

Question 2

You determine that using RMAN transport tablespaces is the best option to move some application data from an 11.2.0.4 on-premises database to a 12.2 OCI DB system.
What is the correct choice for the first step that needs to be performed on the source system?

A. Use the BACKUP FOR TRANSPORT commad to back up tablespaces to be transported along with the DATAPUMP clause to generate metadata required to plug tablespace into the destination database.

B. Use the BACKUP FOR TRANSPORT ... PLUGGABLE DATABASE command to transport the whole PDB.

C. Create a backup set of the tablespaces you want to transport.

D. Invoke Data Pump to generate the transport dump file.

Correct Answer: C

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

Question 3

Your organization needs to define access control for cloud users in their ATP Dedicated system.
How should you create it?

A. Use Inspection.

B. Define a Policy .

C. Define 1AM.

D. Define the VCN.

Correct Answer: B

Question 4

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 5

Which two are needed for Autonomous Data Warehouse to use Object Storage?

A. Database Credential

B. SYS Privilege

C. Database Link

D. Auth Token

Correct Answer: A,D

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

Question 6

Your existing Exadata system is Quarter Rack and database deployments require storage capacity that is outside the scope of the current system configuration. Identify the scaling option.

A. Move your databases to a different Exadata system configuration.

B. Create a new Exadata system and move your databases to the new system.

C. Add more storage servers to an existing Exadata system configuration.

D. Add more storage to existing storage servers of the Exadata system.

Correct Answer: A

Question 7

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 8

[oracle8sadb ~)$ $0RACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME Which operation does this command perform?

A. applies the patch to database components

B. verifies that the patch was applied successfully

C. applies the patch to server components

D. applies interim patches to DB systems

Correct Answer: B

Welcome to TestSimulate

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