[2022] 1Z0-1094-21 Exam Dumps, Test Engine Practice Test Questions

Pass 1Z0-1094-21 exam [Apr 06, 2022] Updated 92 Questions

NEW QUESTION 22
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 your target is Exadata Cloud Service
• B. if you are using virtual machines
• C. if you are using unplug/plug
• D. if you are using Recovery Manager (RMAN)

Answer: A

 

NEW QUESTION 23
Which four Oracle database version are supported for source databases when migrating with Oracle Zero Downtime Migration? (Choose all correct answers)

• A. Oracle Database 12c Release 1 ( 12.1.0.2)
• B. Oracle Database 10 g Release 2
• C. Oracle Database 19
• D. Oracle Database 11g Release 2 ( 11.2.0.4 )
• E. Oracle Database 11g Release 2 ( 11.2.0.3 )
• F. Oracle Database 12c Release 2 ( 12.2.0.1 )

Answer: A,C,D,E

 

NEW QUESTION 24
Your data warehouse load consists of extracting data from order header and order line items table. what kind of journalizing type should you use in Oracle Data Integration ( ODI ) to make sure referential integrity is maintained in the target?

• A. Consistent
• B. Simple
• C. Application Base
• D. Complex

Answer: A

 

NEW QUESTION 25
Which two migration methodologies can you use for migrating on-premises databases to Autonomous Database with Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

• A. Logical offline
• B. Logical online
• C. Physical Online
• D. Physical Offline

Answer: A,B

 

NEW QUESTION 26
Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers)

• A. DB -LINK
• B. SCHEMA
• C. constraint
• D. cluster

Answer: A,D

 

NEW QUESTION 27
Which statements are true for Zero Downtime Migration? (Choose two.)

• A. It is a complex process that requires you to raise an SR with Oracle Support.
• B. It is free.
• C. It does not leverage Oracle MAA best practices.
• D. It ensures zero data loss.

Answer: B,D

 

NEW QUESTION 28
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. sa_audit_admin
• C. Dbms_cloud
• D. Dbms_cloud_macadm

Answer: A

 

NEW QUESTION 29
Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers)

• A. Autonomous Database
• B. Infrastructure as a service
• C. Database Cloud service Bare Metal
• D. Exadata Cloud Service

Answer: A,D

 

NEW QUESTION 30
Which TWO statements are true about the Oracle Zero Downtime command line? (Choose all correct answers)

• A. The zdmeli migrate database command can be run with no options as long as all the information is correctly specified in Zero Downtime Migration's (ZDM) response file.
• B. Upon executing the zdmcli, migrate database command, the only way to track the status of the migration is by querying the ZDM service using the provided job ID.
• C. When the source database is a single instance database deployed on a non-Grid Infrastructure environment, the sourcesid option should be used to specify the database name.
• D. The -sourcedb option is the only valid option to indicate the source database name.

Answer: B,C

 

NEW QUESTION 31
Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers)

• A. RMAN RESTORE from target
• B. RMAN Transportable Tablespaces with Data Pump
• C. RMAN CONVERT
• D. RMAN DUPLICATE

Answer: A,B

 

NEW QUESTION 32
Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating onpremises databases to Autonomous Database? (Choose all correct answers)

• A. Logical online or offline migration using OCI Object Storage
• B. Physical online or offline migration using OCI Object Storage
• C. Physical online or offline migration using a database link
• D. Logical online or offline migration using a database link

Answer: A,D

 

NEW QUESTION 33
Which three tasks can be executed when you submit a data integration job to an Oracle Data Integrator (ODI) agent? (Choose all correct answers)

• A. setting up an FTP server as a staging location for extracted data
• B. the execution of a runtime scenario or a Load plan that was launched from the Oracle Data Integrator Studio, from a command line, via a schedule or a web service interface
• C. the execution of a design-time object, such as a mapping, a package or a procedure backing up data warehouse destination objects before loading the transformed data
• D. an operation on a model, sub model, or a data store, such as a customized reverse-engineering or a journalizing operation

Answer: B,C,D

 

NEW QUESTION 34
When was SQL Developer Web released?

• A. 0
• B. 1
• C. 2
• D. 3
• E. 4

Answer: D

 

NEW QUESTION 35
Which TWO provisions are required for Oracle Zero Downtime Migration (ZDM) to perform a database migration successfully with the physical workflow? (Choose all correct answers)

• A. Root user or SSH key-based access to source database server
• B. Root user or SSH key-based access to target database server
• C. ZDM_BASE group access enabled
• D. Jmx connections to be accepted from multiple hosts

Answer: B,C

 

NEW QUESTION 36
Which knowledge modules are supported by Oracle Data Integrator (ODI)?

• A. Spark
• B. ADW
• C. Hive
• D. All of the options
• E. IDB DB2

Answer: D

 

NEW QUESTION 37
Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)

• A. Cloud Connector
• B. Universal Content Management
• C. REST API
• D. BI Application Configuration Manager
• E. Enterprise Scheduler Service (ESS) SOAP API

Answer: A,B,E

 

NEW QUESTION 38
You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI). Which statement is true?

• A. You are required to do outer join between table A and table B in order to load target C.
• B. You are required to do inner join between table A and table B in order to load target C.
• C. You can join table A and table B, as required by the data model and load target C in a Single mapping
• D. A mapping can have only one source and one target. You need to create 2 mappings to load target C.

Answer: C

 

NEW QUESTION 39
When building out your private subnet, you realize you need a host within your network in order to get access to the rest of your Oracle Cloud Infrastructure instances. Which type of host should you set up to get around this constraint?

• A. Isolation host
• B. Baston host
• C. Encrypted host
• D. Private host

Answer: B

 

NEW QUESTION 40
Which TWO statements are true about online pluggable database (PDB) relocation? (Choose all correct answers)

• A. PDB relocation with no version change can be performed with near-zero downtime.
• B. Database version downgrade can be achieved with PDB relocation.
• C. A PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set.
• D. Online PDB relocation can achieve a zero downtime upgrade.

Answer: A,D

 

NEW QUESTION 41
Which parameter can be used to export a subset of data using Data Pump?

• A. TABLES_AS_VIEWS
• B. SUBSET_AS_TABLES
• C. VIEWS_AS_TABLES
• D. MATERIALIZED_VIEWS

Answer: C

 

NEW QUESTION 42
Which FOUR Oracle Data Pump impdp parameters should you use when migrating to Autonomous Database?
(Choose all correct answers)

• A. REMAP_SCHEMA=SYSTEM
• B. TRANSFORN=SEGMENT_ATTRIBUTES:N
• C. REMAP_TABLESPACE=DATA
• D. TRANSFORN=DWCS_CVT_IOTS:Y
• E. TRANSFORN PORTABLE=ALWAYS
• F. TRANSFORM=CONSTRAINT_USE_DEFAULT_INDEX:Y

Answer: B,C,D,F

 

NEW QUESTION 43
Which file types can be imported using SQL Developer Web?

• A. Excel
• B. AVRO
• C. CSV Delimited
• D. All of the options
• E. JSPN

Answer: D

 

NEW QUESTION 44
You are migrating a non TDE encrypted on-premises Database to an OCT Database Service Instance ising RMAN. You set up the DB Cloud Backup Module, but when executing the RMAN command to create your Cloud Backup you see the following error: AANA RMAN-03009: failure of backup command on ORA_SBT_TAPE 1 channel at: 08/18/2014 11: ORA-19914: unable to encrypt backup ORA~29361 mastor key not yet set What are the TWO causes of this error? (Choose all correct answers)

• A. The set DECRYPTION IDENTIFIED BY RMAN command was not executed.
• B. The Set ENCRYPTION IDENTIFIED BY only command was executed
• C. He OCT Object Storage eye on at rest key is missing
• D. SET ENCRYPTION ON
• E. The Set ENCRYPTION IDENTIFIED BY command was executed.

Answer: D,E

 

NEW QUESTION 45
......

Oracle 1Z0-1094-21 Exam Syllabus Topics:

Topic	Details
Topic 1	Analyze architecture components for transferring data from On-premises Database to Oracle Cloud DB Explain Migration Use Cases and Solutions
Topic 2	Oracle Migration and Integration Describe Oracle Data Management Services Use ZDM to migrate on-premises databases to ADB
Topic 3	Migrate an Oracle Database to OCI by using Oracle Database Cloud Backup Service Implement prerequisites for ZDM Service Node, Source Database, Target Database, Backup, Network Considerations
Topic 4	Explain ETL vs ELT architecture of data integration Describe Oracle Data Integration
Topic 5	Describe when to use Data Pump to migrate to Autonomous Database (ADB) Migrate Oracle Databases on 3rd party clouds (moving from 3rd party clouds)
Topic 6	Manage the Database Migration Workflow Migrating to Autonomous Database Analyze and choose a Migration Strategy

 

Oracle 1Z0-1094-21 Real 2022 Braindumps Mock Exam Dumps: https://www.braindumpsit.com/1Z0-1094-21_real-exam.html