1Z0-1072-26 Practice Test 17 — 15 Questions

Question 1

Which Autonomous Database deployment model runs on dedicated Exadata infrastructure residing in a customer's OCI tenancy, providing maximum isolation?

Accepted Answer

Autonomous Database on Dedicated Exadata Infrastructure. Autonomous Database on Dedicated Exadata Infrastructure (Autonomous Dedicated) provides a completely dedicated database environment within a dedicated Exadata rack.

Answer

Exadata Cloud at Customer (ExaCC)

Answer

Autonomous Database on Shared Infrastructure

Answer

Oracle Base Database System

Question 2

When connecting securely to an Autonomous Database instance, what file must be downloaded from the OCI Console and provided to your database client applications?

Accepted Answer

Client Credentials Wallet (wallet.zip). Autonomous Database requires mutual TLS (mTLS) authentication by default, which is established using credentials packaged in a Wallet zip file.

Answer

An SSH private key (.pem)

Answer

Oracle Wallet Manager Master Encryption Key

Answer

tnsnames.ora configuration text file only

Question 3

You are configuring a Data Guard association for an Oracle Base Database System. You want to minimize performance impact on the primary database while ensuring zero data loss in the event of a failure. Which Data Guard protection mode should you configure?

Accepted Answer

Maximum Availability. Maximum Availability protection mode guarantees zero data loss (synchronous redo transport) while ensuring that if the standby is unavailable, the primary continues processing transactions asynchronously.

Answer

Maximum Performance

Answer

Maximum Protection

Answer

Maximum Throughput

Question 4

An administrator wishes to enable Autonomous Data Guard for an Autonomous Database on Dedicated Exadata Infrastructure. What is the primary benefit of enabling this feature?

Accepted Answer

It automatically provisions a standby database and handles failover and switchover operations to ensure high availability.. Autonomous Data Guard provides high availability by automatically maintaining a standby database in a different availability domain or region with zero data loss protection.

Answer

It allows read-write operations simultaneously on both primary and standby databases across regions.

Answer

It automatically shards tables across two different cloud regions to speed up write operations.

Answer

It reduces cloud storage billing by compressing redundant backup blocks on the standby instance.

Question 5

Which THREE statements are true regarding Exadata Cloud Service architecture and capabilities? (Choose three.)

Accepted Answer

It combines Oracle Database software with Exadata database servers and storage servers in OCI.. Exadata Cloud Service combines Exadata hardware with Oracle Cloud automation, supporting VM clusters, Oracle RAC, and built-in storage servers.

Answer

It does not support Oracle Real Application Clusters (RAC).

Answer

It only supports single-instance databases with no option for high availability.

Question 6

An administrator needs to allow a group of developers to create and manage load balancers within a specific compartment named 'AppCompartment'. Which policy syntax is correct?

Accepted Answer

Allow group Developers to manage load-balancers in compartment AppCompartment. Load balancers belong to the 'load-balancers' resource type in OCI IAM policies.

Answer

Allow user Developers to create load-balancers in compartment AppCompartment

Answer

Allow group Developers to manage lb-family in tenancy

Answer

Allow group Developers to use network-load-balancers in compartment AppCompartment

Question 7

What is the function of the OCI IAM 'read' verb compared to 'inspect'?

Accepted Answer

Read includes all inspect permissions plus the ability to get resource metadata and configuration details.. The 'read' verb includes all permissions of 'inspect' plus the ability to get full configuration metadata and details of resources.

Answer

Read allows users to modify resources, whereas inspect only allows viewing.

Answer

Read allows downloading data from Object Storage, whereas inspect allows uploading.

Answer

Read is more restrictive than inspect.

Question 8

You are provisioning an Exadata Database Service on Dedicated Infrastructure and need to choose a shape that supports high performance workloads. Which option represents a valid Exadata shape family available in OCI?

Accepted Answer

Exadata.X9M.8. Exadata Database Service utilizes specific hardware shapes such as X9M and X10M, categorized by quarter, half, or full racks.

Answer

BM.GPU.DenseIO2.8

Answer

Exadata.X9M.Quarter3

Answer

VM.Standard2.4

Question 9

An architect needs to perform a point-in-time recovery (PITR) on an Oracle Base Database Service DB system using the OCI Console. What is a prerequisite constraint when selecting a recovery timestamp?

Accepted Answer

The timestamp must be within the retention window of the automated backups and archive log backups.. The target recovery time for PITR must fall within the retention period of the automated backups or within the available archive logs retained on disk or Object Storage.

Answer

Point-in-time recovery is only supported via SQL*Plus and cannot be initiated from the OCI Console.

Answer

The target timestamp must be aligned precisely with the exact minute of the last incremental backup.

Answer

The database must first be converted to an Autonomous Database before PITR can be executed.

Question 10

An administrator needs to grant a group of database administrators the ability to manage Autonomous Databases in a specific compartment named DevComp. Which policy syntax is the most secure and adheres to the principle of least privilege?

Accepted Answer

Allow group DBA-Group to manage autonomous-database in compartment DevComp. To grant access to specific resources within a specific compartment, the policy must scope the verbs to that compartment rather than the tenancy.

Answer

Allow group DBA-Group to manage all-resources in tenancy

Answer

Allow user DBA-Group to manage autonomous-database in tenancy

Answer

Allow group DBA-Group to use databases in compartment DevComp

Question 11

An administrator wants to allow the 'SecurityOps' group to read audit logs across the tenancy. Which policy statement is correct?

Accepted Answer

Allow group SecurityOps to read audit-events in tenancy. Audit logs are accessed via the 'audit-events' resource type in OCI IAM policies.

Answer

Allow group SecurityOps to manage log-files in tenancy

Answer

Allow group SecurityOps to use audit in tenancy

Answer

Allow group SecurityOps to inspect audit-trails in compartment root

Question 12

Which TWO methods can be used to connect to an Autonomous Database securely from an on-premises application server?

Accepted Answer

Using a downloaded client credentials wallet (mTLS connection). Autonomous Database supports mutual TLS (mTLS) via downloaded wallets and TLS connections using private endpoints or database names.

Answer

Direct SSH tunneling through the database control plane

Answer

Unencrypted Telnet connection over port 1521

Answer

Anonymous FTP file transfer into the database home

Question 13

Which THREE components are required when setting up OCI Functions to build, push, and deploy a serverless function? (Choose three.)

Accepted Answer

The Fn Project CLI tool installed on your machine or cloud shell. To deploy OCI Functions, you need an Application container, an Oracle Container Registry (OCIR) repository to store function images, and the Fn CLI tool to build and deploy.

Answer

An active File Storage Service mount target attached directly to the function registry

Answer

A dedicated Bare Metal compute instance running Kubernetes master nodes

Question 14

Which TWO of the following tasks can be performed using the Oracle Cloud Agent on compute instances? (Choose two.)

Accepted Answer

Executing remote script commands via Run Command service. Oracle Cloud Agent enables plugins for collecting monitoring metrics, executing run commands remotely, and managing OS compliance and patching.

Answer

Modifying DNS records in external third-party domain registrars

Answer

Configuring VCN security list packet filtering rules

Answer

Managing physical data center hardware maintenance and rack replacements

Question 15

You are deploying an Exadata Cloud Service instance and need to configure separate Virtual Machine clusters on the same Exadata rack. Which architectural feature enables this separation?

Accepted Answer

Exadata VM Clusters. Exadata Cloud Service allows multiple independent Grid Infrastructure homes and database homes by deploying multiple VM clusters on a single Exadata infrastructure rack.

Answer

OCI Compartment boundaries

Answer

Oracle Multitenant container databases with PDB isolation

Answer

Dynamic Routing Gateways (DRG)