1Z1-1044 by Oracle Actual Free Exam Q&As

Question 1

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

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

Discussion 0

Correct Answer: B,E Vote an answer

Question 2

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 the Internet, because that way you avoid transferring dump files. B. 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. C. Generate a dump file, transfer it using SCP, and import it in the destination OCI DB system . D. Data Pump is not recommended in this case as the amount of data is too big.

Discussion 0

Correct Answer: B Vote an answer

Question 3

What determines the raw storage on a bare metal database system In OCI?

A. the number of Availability Domains B. 2- or 3-way mirroring option C. the number of fault domains D. the percentage of disk for RECO and Data diskgroup E. the shape that you choose

Discussion 0

Correct Answer: D Vote an answer

Question 4

You are administering an on-premises CDB database with large number of PDBs with approximate size of around 140TB. You want to migrate the PDBs to an OCI DB system. You have a fast connection with 300Mb/s upload bandwidth.
Which strategy should you use to finish the migration as fast as possible?

A. Perform RMAN backups, perform an SCP transfer to destination machines, and restore the backups B. Unplug POBs, use the Oracle Data Transfer service to send the data and plug them on destination. C. Use SQL Developer to copy relevant application tables to the cloud. D. Use Data Pump Schema Export/ Import to move the datA. E. Use Data Pump Transportable Tablespace.

Discussion 0

Correct Answer: B Vote an answer

Question 5

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

Discussion 0

Correct Answer: D Vote an answer

Question 6

Your organization wants you to migrate a 1 TB data warehouse to the Autonomous Data Warehouse.
Which two methods should you consider?

A. Using INSERT statements via SQL Developer B. Loading files from Object storage C. Database link D. Data Transfer Service

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

Which statement is true about using Autonomous Data Warehouse as a Data Mart?

A. Only an IT department can create a data mart. B. The Autonomous Data Warehouse cannot be used as a data mart. C. Someone in the Line of Business can load a data mart with data from spreadsheets. D. Data marts are only populated by loading programs called ETL (extract, transform, and load).

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which two statements are correct regarding configuring RAC and Data Guard for a Database Service (DBaaS) in OCI?

A. RAC instances should be configured to run in single Fault Domain. B. Data Guard can be implemented within or across Availability Domain. C. RAC instances are configured to run across multiple Fault Domains. D. RAC instances should be configured to run in multiple regions. E. RAC instances are configured to run across multiple Availability domains.

Discussion 0

Correct Answer: B,C Vote an answer

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

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