最新的Database Cloud Service認證 1z0-1094-22考試題庫

問題1

Which are TWO benefits 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 does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.

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

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

正確答案: A,B

問題2

When integrating data from multiple sources into 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 integration type was not set in the logical design.

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

D. There were no rows compliant with imposed constraint.

正確答案: C

問題3

Which port number do all the OCI GoldenGate Microservices environments use for port forwarding through NGINX?

A. 1521

B. 443

C. 22

D. 1680

正確答案: B

問題4

Which of these provide Active Replication? (Choose two.)

A. Active Data Guard

B. GoldenGate

C. Flashback

D. Sharding

正確答案: A,B

問題5

Your source tables are in an on-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an on-premises Oracle Database connection ? (Choose 3 all correct answers)

A. list of all schemas

B. network name or IP address of the machine hosting the Oracle Database

C. database link

D. listing port of the oracle listener

E. name of the Oracle Instance (SID) or service

正確答案: B,D,E

問題6

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?

A. Both Physical and Logical Migration is supported.

B. Physical Migration only

C. ZDM does not support Inflight Upgrade.

D. Logical Migration only

正確答案: D

問題7

You are looking at migrating a large data centre to the Oracle Cloud while trying to consolidate many Oracle Databases at the same time. Which Oracle Data Management Service helps you achieve this?

A. oracle Data Safe

B. oracle Autonomous Database

C. oracle Exadata Cloud Service

D. oracle MySQL Cloud Service

正確答案: C

問題8

You run a database instance on Oracle Database 11.2 and you want to migrate to Oracle Cloud. In which case is it required to upgrade your source database before migrating to the cloud?

A. if you are using unplug/plug

B. if you are using virtual machines

C. if your target is Exadata Cloud Service

D. if you are using Recovery Manager (RMAN)

正確答案: C

問題9

Which FOUR key parameters should you include in your export command when migrating an Oracle Database to the Oracle Cloud? (Choose all correct answers)

A. metrics=yes (for Diagnostics)

B. versron=10 (for compatibility)
exclude=statistics (for performance

C. parameter=1 (for performance)
logtime=all (for Diagnostics)

D. FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export)

正確答案: A,B,C,D

問題10

Which tools can be used to perform Oracle Zero Downtime logical migration? (Choose two.)

A. Data Guard

B. RMAN

C. Data Pump

D. Oracle GoldenGate

正確答案: C,D

最新的Oracle Cloud Database Migration and Integration 2022 Professional - 1z0-1094-22免費考試真題

最新更新

站內鏈接

聯系我們