1Z1-1044 Exam Training Practice Tests (Oracle Cloud Platform Data Management 2019 Associate)]

Question 1

Which three prerequisites/conditions must be met for recovering a database from Object Storage?

A. VCN must be configured with NAT Gateways or Local Peering Gateways. B. The DB system must have access to the applicable Swift endpoint for Object Storage. C. The database must be in archivelog mode. D. VCN must be configured with a service gateway or internet gateway. E. Dual-mode encryption must be enabled for the database backups taken.

Correct Answer: B,C,D

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

Question 2

You want to migrate an on-premises Data Mart to the Autonomous Data Warehouse.
Which two methods can you use?

A. Copying the database data files B. RMAN backup and restore C. Database clone D. SQL Developer Data Import Wizard E. SQL *Loader

Correct Answer: D,E

Question 3

You are going to perform a 5-GB database migration from on-premises to OCI DB system. It includes some tables with LONG columns.
What is the best Data Pump method for this case?

A. There is no need to generate a dump file. You can use the NETWORK LINK method over an SSH tunnel, because that way you avoid transferring dump files and the data is secured too. B. Generate a dump file, transfer it using SCP, and import it in the destination OCI DB system . C. Data Pump is not recommended in this case as the amount of data is too big. D. There is no need to generate a dump file. You can use the NETWORK LINK method over the Internet, because that way you avoid transferring dump files.

Correct Answer: A

Question 4

You have a 12.2.0.1 on-premises database running on a Solaris SPARC machine.and you want to transfer some applicat ion t ablespaces into a 12. 2 OCI DB syst em.
What is the right sequence of steps to follow?

A. Invoke Data Pump in schema mode to export the application data, run t he CONVERT TABLESPACE command, transfer files, and use Data Pump to import the schemas into the destination database. B. Invoke Data Pump Export to perform the transportable tablespace export, back up your tablespaces as encrypted backup sets, run t he CONVERT TABLESPACE command transfer files and use Data Pump Import to plug them into the destination database. C. I nvoke Data Pump Export to perform the transportable t ablespace export, run the CONVERT TABLESPACE command, transfer files, and use Data Pump I mport to plug them into the destination database. D. Invoke Data Pump Export to perform the transportable tablespace export, back up your tablespaces as compressed backup sets to improve t ransfer time, run the CONVERT TABLESPACE command, transfer f iles, and use Data Pump to plug them into the destination database. E. Back up your tablespaces as image copies, transfer f iles, and rest ore them into a new or existing PDB.

Correct Answer: A

Question 5

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. Add more storage servers to an existing Exadata system configuration. B. Create a new Exadata system and move your databases to the new system. C. Add more storage to existing storage servers of the Exadata system. D. Move your databases to a different Exadata system configuration.

Correct Answer: D

Question 6

You decide to migrate a 12. 1.0.2 on-premises database to 12.2.0.1 OCI DB System using the PDBunplug/plug method. Which sequence of steps should you execute?

A. Unplug the source PDB, close it, transfer the files, plug it into the destination environment, and run the dbupgrade utility. B. Close the source PDB, unplug it, transfer the files, and plug it into the destination environment. C. Close the source PDB, unplug it, transfer the files, plug it into the destination environment and run the dbupgrade utility D. Perform a conventional Data Pump Export /Import, because PDB unplug/plug is not supported in this scenario.

Correct Answer: C

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

Question 7

Which statement is true about the Oracle Software releases that are currently supported in an Exadata Cloud Service Instance?

A. Oracle Database 11g Release 2, Oracle Database 12c Rl, Oracle Database 12c R2, and Oracle Database 18c are supported. B. Oracle Database 11g R2, Oracle Database 12c Rl, and Oracle Database 12c R2 are supported. C. Oracle Database Oracle Database 12c R1, Oracle Database 12c R2, and Oracle Database 18c are supported. D. Oracle Database 11g Release 1, Oracle Database 11g R2, Oracle Database 12c R1, and Oracle Database 12c R2 are supported.

Correct Answer: C

Question 8

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 the VCN. C. Define a Policy . D. Define 1AM.

Correct Answer: C

Oracle Cloud Platform Data Management 2019 Associate - 1Z1-1044 Exam Practice Test