Oracle Database Cloud Service 1Z0-1094-22 Questions & Answers

• Question 71:

  You are using Data Pump to migrate your database to Autonomous Database (ADB). To which tablespace must you remap your source database tablespaces?

  A. USERS

  B. UNDO

  C. SYSTEM

  D. DATA

  Correct Answer: D

• Question 72:

  Which technologies can you use for Zero Downtime physical migration? (Choose two.) (Choose all correct answers)

  A. Data Guard

  B. OracleGoldenGate

  C. Data Pump

  D. RMAN

  Correct Answer: AD

• Question 73:

  When migrating an Oracle database, you must be aware of source and target requirements. Which TWO statements are true about using Oracle Zero DowntimeMigration (ZDM)? (Choose all correct answers)

  A. Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-.

  B. Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated toEnterprise Edition Databases.

  C. When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.

  D. Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.

  Correct Answer: AD

• Question 74:

  Which type of checks is NOT supported by Oracle Data Integrator (ODI)?

  A. conditions

  B. keys

  C. references

  D. mandatory attributes

  E. business rule

  Correct Answer: E

• Question 75:

  Which Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?

  A. Dbms_cloud_admin

  B. Dbms_cloud

  C. sa_audit_admin

  D. Dbms_cloud_macadm

  Correct Answer: A

• Question 76:

  When integrating data from multiple sourcesinto a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table. All the rows that do not pass this quality check will have to be isolated in error tables. For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control. You have also chosen the value raue for this parameter to enable this check. At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start. What is the reason?

  A. Primary key was not defined on the target table.

  B. The Check Knowledge Module was not set in the physical design.

  C. The integration type was not set in the logical design.

  D. There were no rows compliant with imposed constraint.

  Correct Answer: B

• Question 77:

  Which developer tool is web-based, function-rich, and resides in a low code development environment?

  A. APEX

  B. RMAN

  C. IMPEXPDP

  D. DATAPUMP

  Correct Answer: A

• Question 78:

  Which THREE methods can be used to migrate an on-premises Oracle Database to Oracle Autonomous Database? (Choose all correct answers)

  A. Data Pump Export/lmport

  B. EnterpriseManager

  C. Oracle Zero Downtime Migration

  D. Data Guard

  E. PDB Unplugging/Plugging

  Correct Answer: ABC

• Question 79:

  Which are TWObenefits of Extract-Load-Transform (ELT) over traditional Extract- Transform-Load (ETL) architectures? (Choose all correct answers)

  A. ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.

  B. ELT architecture can easily become a bottleneck by placing excessive loads on the target servers.

  C. ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.

  D. Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.

  Correct Answer: AC

• Question 80:

  What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?

  A. Remote cloning a pluggable database (PDB)

  B. RMAN Transportable Tablespace

  C. Data Pump Transportable Tablespaces

  D. DataLoad tab of the SQL worksheet in Database Actions

  Correct Answer: D