1Z0-1105-22 Online Practice Questions and Answers

What is a prerequisite of running APEX on an Autonomous Database?

A. A DBA must enable ORDS first.

B. APEX can simply be installed by downloading the executable from OTN.

C. APEX can only be used when selecting APEX as a workload when provisioning an Au- tonomous Database.

D. An Autonomous Database with the workload type Data Warehouse, Transaction Pro- cessing, JSON or APEX.

E. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.

Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?

A. Audit Vault and Database Firewall

B. Oracle Native Network Encryption and TDE (Transparent Data Encryption)

C. Oracle Key Vault

D. Database Vault and Data Masking Pack

Which statement can be detected by monitoring of access to sensitive data?

A. SELECT SYSDATE from DUAL;

B. CREATE index emp_id_idx on EMPLOYEES(emp_id);

C. UPDATE quarter_reference set Q1='012022'

D. SELECT * from EMPLOYEES;

What is the primary goal of Oracle Maximum Availability Architecture for customer systems?

A. Scale out, application availability and protection

B. Active Replication, Data Protection and continuous availability

C. Continuous Availability, network security and failover

D. Data Protection, access and reporting

When Customers are using the Exadata Cloud Service, what are they responsible fo managing?

A. Hypervisor and Internal Fabric

B. Internal Fabric and Customer VMs

C. Databases and Customer VM

D. Host VM and Storage

Which two statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers)

A. HeatWave data which is needed for analytic processing is stored in disk files.

B. HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs.

C. HeatWave uses periodic long-running ETL batch jobs to refresh the data.

D. HeatWave is a in-memory, query-processing engine designed for fast execution of ana- lytic queries.

Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?

A. Autonomous Data Warehouse

B. Compute

C. Exadata DB Systems

D. Monitoring

Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud? (Choose all correct answers)

A. Streaming Service

B. Compute VM

C. Exadata Cloud Service

D. Autonomous Database

Where should you store unstructured, high volume data sets of unknown value for best price/performance?

A. OCI Data Flow

B. OCI Object Storage

C. OCI Data Catalog

D. OCI GoldenGate

A customer wants to use Oracle Cloud Infrastructure (OCI) for storing application backups which can be stored for months, but retrieved immediately based on business needs. Which OCI storage service can be used to meet this requirement?

A. File Storage

B. Archive Storage

C. Object Storage (standard)

D. Block Volume