Oracle Oracle Certifications 1Z0-1072-21 Questions & Answers

• Question 201:

  Which two statements are true about an Oracle Cloud Infrastructure (OCI) virtual cloud network (VCN)? (Choose two.)

  A. To delete a VCN, its subnets must contain no resources.

  B. A VCN can have multiple CIDR blocks associated with it.

  C. In regions with multiple Availability Domains (AD), each AD should have their own VCN assigned to it.

  D. If you own a block of public IPs, you can assign it to one of your VCNs.

  E. A VCN covers a single, contiguous IPv4 CIDR block of your choice.

  Correct Answer: AE

  Reference: https://docs.cloud.oracle.com/en-us/iaas/Content/Network/Tasks/managingVCNs.htm

• Question 202:

  Which two statements are true about restoring a volume from a block volume backup in Oracle Cloud Infrastructure Block Volume service?

  A. You can restore a volume from any full volume backup but not from an Incremental backup.

  B. You can only restore a volume to the same availability domain in which the original block volume resides.

  C. You can restore a block volume backup to a larger volume size.

  D. You can restore a volume to any availability domain within the same region where the backup is stored.

  E. You can restore only one volume from a manual block volume backup.

  Correct Answer: CD

  Reference https://docs.cloud.oracle.com/enus/iaas/Content/Block/Tasks/restoringavolumefromabackup.htm

• Question 203:

  You are running a mission-critical database application in Oracle Cloud Infrastructure (OCI). You take

  regular backups of your DB system to OCI object storage. Recently, you notice a failed database backup

  status in the console.

  What step can you take to determine the cause of the backup failure?

  A. Ensure that your database host can connect to OCI object storage.

  B. Ensure the database archiving mode is set to NOARCHIVELOG.

  C. Make sure that the database is not active and running while the backup is in progress.

  D. Don't restart the dcsagent program even if it has a status of stop/waiting.

  Correct Answer: A

  Database backups can fail for various reasons. Typically, a backup fails because either the database host cannot access the object store, or there are problems on the host or with the database configuration. First need to determining the Problem In the Console, a failed database backup either displays a status of Failed or hangs in the Backup in Progress or Creating state. If the error message does not contain enough information to point you to a solution, you can use the database CLI and log files to gather more data. Then, refer to the applicable section in this topic for a solution. Database Service Agent Issues Your Oracle Cloud Infrastructure Database makes use of an agent framework to allow you to manage your database through the cloud platform. Occasionally you might need to restart the dcsagent program if it has the status of stop/waiting to resolve a backup failure. Object Store Connectivity Issues Backing up your database to Oracle Cloud Infrastructure Object Storage requires that the host can connect to the applicable Swift endpoint. You can test this connectivity by using a Swift user. Host Issues One or more of the following conditions on the database host can cause backups to fail:

  -Interactive Commands in the Oracle Profile

  -The File System Is Full

  -Incorrect Version of the Oracle Database Cloud Backup Module

  -Changes to the Site Profile File (glogin.sql)

  Database Issues

  An improper database state or configuration can lead to failed backups.

  -Database Not Running During Backup

  -Archiving Mode Set to NOARCHIVELOG (When you provision a new database, the archiving mode is set

  to ARCHIVELOG by default. This is the required archiving mode for backup operations)

  -Stuck Database Archiver Process and Backup Failures

  -Temporary Tablespace Errors

  -

  RMAN Configuration and Backup Failures

  -

  RMAN Retention Policy and Backup Failures

  -Loss of Objectstore Wallet File and Backup Failures

  TDE Wallet and Backup Failures

  -

  Incorrect TDE Wallet Location Specification

  -

  Incorrect State of the TDE Wallet

  -

  Incorrect Configuration Related to the TDE Wallet

  -Missing TDE Wallet File

  As this is not new provisioned database and already in the ARCHIVELOG , regular backups of DB system

  to OCI object storage in places, so the best answers are,

  -Ensure that your database host can connect to the OCI object storage

  -Restart the database service agent

• Question 204:

  Which statement is true about interconnecting Virtual Cloud Network (VCN)?

  A. VCNs support transitive peering.

  B. Peering VCNs should not have overlapping CIDR blocks.

  C. VCNs must be in the same tenancy to be peered.

  D. The only way to interconnect VCNs is through peering.

  Correct Answer: B

  Reference: https://docs.cloud.oracle.com/en-us/iaas/Content/Network/Tasks/remoteVCNpeering.htm (note)

• Question 205:

  You provisioned an Oracle Autonomous Data Warehouse (ADW) on Oracle Cloud Infrastructure (OCI) and

  imported data into ADW.

  You want to give your business analyst the ability to connect to the ADW database and run queries. Which

  two actions can help you meet this requirement? (Choose two.)

  A. Create a database user account for the business analyst.

  B. Grant the predefined database role DWROLE to the database user.

  C. Grant unlimited tablespace privilege to the database user.

  D. Grant the predefined database role DWADW to the database user.

  E. Grant the predefined database role DWUSER to the database user.

  Correct Answer: BC

  Reference:

  https://oracle.github.io/learning-library/oci-library/L100- LAB/Autonomous_Data_Warehouse/

  ADW_HOL.html

• Question 206:

  Which two statements below are correct with respect to adding secondary Virtual Network Interface Cards (VNICs) to an existing compute instance in Oracle Cloud Infrastructure? (Choose two.)

  A. The secondary VNIC is required to be in the same Virtual Cloud Network (VCN), but can be in different subnet, as the primary VNIC.

  B. The primary and secondary VNIC association can be in different virtual cloud networks (VCNs).

  C. You cannot assign an Ephemeral Public IP to a secondary VNIC.

  D. The primary and secondary VNIC association must be in the same availability domain.

  E. You can remove the primary VNIC after the secondary VNIC's attachment is complete.

  Correct Answer: BD

  "You can add secondary VNICs to an instance after it's launched. Each secondary VNIC can be in a subnet in the same VCN as the primary VNIC, or in a different subnet that is either in the same VCN or a different one. However, all the VNICs must be in the same availability domain as the instance." https:// docs.cloud.oracle.com/en-us/iaas/Content/Network/Tasks/managingVNICs.htm

• Question 207:

  Your company decided to move a few applications to Oracle Cloud Infrastructure (OCI) in the US West

  (us-phoenix-1) region.

  You need to design a cloud-based disaster recovery (DR) solution with a requirement to deploy the DR

  resources in the US East (us-ashburn-1) region to minimize network latency.

  What is the recommended deployment?

  A. Deploy production and DR applications in two separate virtual cloud networks (VCNs), each in different regions, and then use VCN local peering gateways for connectivity.

  B. Deploy production and DR applications in two separate VCNs, each in different regions. Connect them using a VCN remote peering connection.

  C. Deploy production and DR applications in the same VCN. Create production subnets in one AD, and DR subnets in another AD (assume a multi-AD region).

  D. Deploy production and DR applications in two separate VCNs in different availability domains (ADs) within the primary region, and then use a VCN remote peering connection for connectivity.

  Correct Answer: A

  Remote VCN peering is the process of connecting two VCNs in different regions The peering allows the VCNs' resources to communicate using private IP addresses without routing the traffic over the internet or through your on-premises network.

• Question 208:

  You are designing a networking infrastructure in multiple Oracle Cloud Infrastructure regions and require connectivity between workloads in each region. You have created a dynamic routing gateway (DRG) and a remote peering connection. However, your workloads are unable to communicate with each other. What are two reasons for this? (Choose two.)

  A. The security lists associated with subnets in each virtual cloud network (VCN) do not have the appropriate ingress rules

  B. Identity and Access Management (IAM) policies have not been defined to allow connectivity across the two VCNs in different regions

  C. A local peering gateway needs to be created in each VCN with a default route rule added in the route table forwarding the traffic to the local peering gateway

  D. An Internet gateway needs to be created in each VCN with a default route rule added in the route table forwarding the traffic to the Internet Gateway

  E. The route table associated with subnets in each VCN do not have a route rule defined to forward the traffic to their respective DRGs

  Correct Answer: AE

  Setting Up a Remote Peering Create the RPCs: Each VCN administrator creates an RPC for their own VCN's DRG. Share information: The administrators share the basic required information. Set up the required IAM policies for the connection: The administrators set up IAM policies to enable the connection to be established. Establish the connection: The requestor connects the two RPCs (see Important Remote Peering Concepts for the definition of the requestor and acceptor). Update route tables: Each administrator updates their VCN's route tables to enable traffic between the peered VCNs as desired. Update security rules: Each administrator updates their VCN's security rules to enable traffic between the peered VCNs as desired.

• Question 209:

  With regard to Oracle Cloud Infrastructure Load Balancing service, which two actions will occur when a backend server that is registered with a backend set is marked to drain connections?

  A. All existing connections to this backend sever will be immediately closed.

  B. Requests to this backend server are redirected to a user-defined error page.

  C. All new connections to this backend server are disallowed.

  D. Connections to this backend server will remain open until all in-flight requests are completed.

  E. All connections to this backend server are forcibly closed after a timeout period.

  Correct Answer: CD

  Reference: https://docs.cloud.oracle.com/en-us/iaas/Content/Balance/Reference/sessionpersistence.htm

• Question 210:

  You deployed an Oracle Cloud Infrastructure (OCI) compute instance (VM.Standard2.16) to run a SQL database. After a few weeks, you need to increase disk performance by using NVMe disks but keeping the same number of CPUs. As a first step, you terminate the instance and preserve the boot volume. What is the next step?

  A. Create a new instance using a VM.DenseIO2.16 shape using the preserved boot volume and move the SQL Database data to block volume

  B. Create a new instance using a VM.DenseIO2.8 shape using the preserved boot volume and move the SQL Database data to NVMe disks

  C. Create a new instance using a VM.Standard1.16 shape using the preserved boot volume and move the SQL Database data to NVMe disks

  D. Create a new instance using a VM.DenseIO2.16 shape using the preserved boot volume move the SQL Database data to NVMe disks

  Correct Answer: D

  to Increase disk performance by using NVMe disks you can use Dense IO Shape also as the number of CPUs will not change so we should VM.DenseIO2.16