Oracle 1Z0-1072-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1072-22 Online Questions & Answers

• Question 101:

  You have the following compartment structure in your tenancy. Root compartment->Training- >Training-subl ->Training-sub2 You create a policy in the root compartment to allow the default admin for the account (Administrators) to manage

  block volumes in compartment Training-sub2.

  What policy would you write to meet this requirement?

  A. Allow group Administrators to manage volume-family in root compartment
  B. Allow group Administrators to manage volume-family in compartment Training-sub1 :Training- sub2
  C. Allow group Administrators to manage volume-family in compartment Training: Training-sub 1 :Training-sub2
  D. Allow group Administrators to manage volume-family in compartment Training-sub2
  C. Allow group Administrators to manage volume-family in compartment Training: Training-sub 1 :Training-sub2

  ---

  a policy statement must specify the compartment for which access is being granted (or the tenancy). Where you create the policy determines who can update the policy. If you attach the policy to the compartment or its parent, you can simply specify the compartment name. If you attach the policy further up the hierarchy, you must specify the path. The format of the path is each compartment name (or OCID) in the path, separated by a colon: :: . . . For example, assume you have a three-level compartment hierarchy, shown here:

  

  You want to create a policy to allow NetworkAdmins to manage VCNs in CompartmentC. If you want to attach this policy to CompartmentC or to its parent, CompartmentB, write this policy statement:

  Allow group NewtworkAdmins to manage virtual-network-family in compartment CompartmentC However, if you want to attach this policy to CompartmentA (so that only administrators of CompartmentA can modify it), write this policy

  statement that specifies the path:

  Allow group NewtworkAdmins to manage virtual-network-family in compartment CompartmentB:CompartmentC

  To attach this policy to the tenancy, write this policy statement that specifies the path from CompartmentA to CompartmentC:

  Allow group NewtworkAdmins to manage virtual-network-family in compartment CompartmentA:CompartmentB:CompartmentC

• Question 102:

  At the end of a terraform apply operation, what is the default output?

  A. nothing by default
  B. statistics about what was added, changed, and destroyed
  C. the entire state file
  D. statistics about what was added, changed, and destroyed, and the values of outputs
  D. statistics about what was added, changed, and destroyed, and the values of outputs

• Question 103:

  Which two statements are true about an Oracle Cloud Infrastructure Virtual Cloud Network (VCN)? (Choose two.)

  A. A VCN can reside in multiple Oracle Cloud Infrastructure regions and Availability Domains.
  B. A VCN covers a single contiguous IPv4 CIDR block of your choice.
  C. An allowable VCN size range is: /16 to /30.
  D. A VCN creates the dynamic routing gateway by default.
  B. A VCN covers a single contiguous IPv4 CIDR block of your choice.
  C. An allowable VCN size range is: /16 to /30.

  ---

  VCN resides in a single Oracle Cloud Infrastructure region and covers a single, contiguous IPv4 CIDR block of your choice. The allowable VCN size range is /16 to /30

• Question 104:

  Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database?

  A. You can download tnsnames.ora from Oracle Cloud Infrastructure web console under ADW details page
  B. The tnsnames.ora file is included in credentials.zip file that you download from service console of ADW
  C. The ADW database will place the tnsnames.ora file in an object storage bucket
  D. You are automatically prompted to download the tnsnames.ora file upon creation of the ADW database
  B. The tnsnames.ora file is included in credentials.zip file that you download from service console of ADW

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- intorduction.html#GUID-CD4C10A6-1C1E-4969-8F67-1433B6CE626A To download client credentials from the Autonomous Transaction Processing Service Console:

  -From the Service Console click the Administration link.

  -Click Download Client Credentials (Wallet).

  -

  On the Download Client Credentials (Wallet) page, enter a wallet password in the Password field and confirm the password in the Confirm Password field. The password must be at least 8 characters long and must include at least 1 letter

  and either 1 numeric character or 1 special character. This password protects the downloaded Client Credentials wallet.

  -

  Click Download to save the client security credentials zip file. By default the filename is:

  Wallet_databasename.zip. You can save this file as any filename you want. You must protect this file to prevent unauthorized database access.

  The zip file includes the following:

  tnsnames.ora and sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client side configuration.

  cwallet.sso and ewallet.p12: Auto-open SSO wallet and PKCS12 file. PKCS12 file is protected by the wallet password provided in the UI.

  keystore.jks and truststore.jks: Java keystore and truststore files. They are protected by the wallet password provided while downloading the wallet.

  ojdbc.properties: Contains the wallet related connection property required for JDBC connection. This should be in the same path as tnsnames.ora.

• Question 105:

  You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 days. Which database backup strategy would you select?

  A. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.
  B. Use the automated backups.
  C. Take monthly manual backups to supplement the automated backups and preserve them for 12 months.
  D. Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.
  B. Use the automated backups.

  ---

  Oracle Cloud Infrastructure automatically backs up your Autonomous Databases and retains these backups for 60 days. Automatic backups are weekly full backups and daily incremental backups. You can also create manual backups to supplement your automatic backups. Manual backups are stored in an Object Storage bucket that you create, and are retained for 60 days The retention period for manual backups is the same as automatic backups which is 60 days. So we cannot preserve the backup for 12 months https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backup- manual.html#GUID-D95E5D6A-C470-4A68-9545-CC99D937E7D1

• Question 106:

  You have created a new compartment called Production to host some production apps. You have also created users in your tenancy and added them to a Group called "production group". Your users are still unable to access the Production compartment. How can you resolve this situation?

  A. Every compartment you create comes with a predefined set of policies, so no further action is needed
  B. Your users get automatic access to all compartments, so no further action is needed
  C. Write an IAM Policy for each specific user granting them access to the production compartment
  D. Write an IAM Policy for "production_group" granting it access to the production compartment
  D. Write an IAM Policy for "production_group" granting it access to the production compartment

  ---

  When creating a compartment, you must provide a name for it (maximum 100 characters, including letters, numbers, periods, hyphens, and underscores) that is unique within its parent compartment. You must also provide a description, which

  is a non-unique, changeable description for the compartment, from 1 through 400 characters.

  After creating a compartment, you need to write at least one policy for it, otherwise no one can access it (except administrators or users who have permissions set at the tenancy level). When creating a compartment inside another

  compartment, the compartment inherits access permissions from compartments higher up its hierarchy.

  When you create an access policy, you need to specify which compartment to attach it to. This controls who can later modify or delete the policy. Depending on how you've designed your compartment hierarchy, you might attach it to the

  tenancy, a parent, or to the specific compartment itself.

• Question 107:

  Your company is developing a new database application in Oracle Cloud Infrastructure. You need to test application functionality including a hardware failure scenario. Since the application is still in the development phase, you want to minimize infrastructure costs. Which database service deployment option meets this requirement?

  A. two node real application cluster (RAC) system
  B. Autonomous Data Warehouse (ADW) system as it provides auto fail over functionality
  C. two node bare metal system with data guard enabled
  D. single node bare metal system
  A. two node real application cluster (RAC) system

• Question 108:

  You have an Oracle Cloud Infrastructure (OCI) load balancer distributing traffic via an evenly- weighted round robin policy to your back-end web servers. You notice that one of your web servers is receiving more traffic than other web servers. How can you resolve this to make sure traffic is evenly distributed across all back-end webservers?

  A. Disable cookie-based session persistence on your backend set.
  B. Change kee
  C. Disable SSL configuration associated with your backend set.
  D. Create separate listeners for each backend web server.
  D. Create separate listeners for each backend web server.

  ---

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

• Question 109:

  What is true about data guard set up with fast-start failover (FSFO) in Oracle Cloud Infrastructure (OCI)?

  A. The best practice for high availability and durability is to run the primary, standby, and observer in separate availability domains (ADs).
  B. When you configure data guard using OCI console, the default mode is set to maxprotection.
  C. You cannot create the standby DB system in a different AD from the primary DB system.
  D. You cannot use database command line interface (CLI) to set up data guard with FSFO.
  A. The best practice for high availability and durability is to run the primary, standby, and observer in separate availability domains (ADs).

  ---

  References: The best practice for high availability and durability is to run the primary, standby, and observer in separate availability domains. The observer determines whether or not to failover to a specific target standby database https://docs.cloud.oracle.com/enus/iaas/Content/Database/Tasks/usingDG.htm#ConfiguringObserverOptional

• Question 110:

  You are deploying a highly available web application In Oracle Cloud Infrastructure and have decided to use a public load balancer. The back-end web servers will be distributed across all three availability domains (ADs). How many subnets should you create to deliver a secure, highly available application?

  A. two subnets in total; one regional private subnet to host your back-end web servers and one regional public subnet to host your public load load balancer.
  B. two subnets in total; one regional public subnet to host your back-end web servers and one regional private subnet to host your public load load balancer.
  C. three subnets in total; one regional public subnet to host your back-end web servers and two AD specific private subnets to host your private load load balancer.
  D. one subnet in total; one regional private subnet to host your back-end web servers and your public load balancer.
  A. two subnets in total; one regional private subnet to host your back-end web servers and one regional public subnet to host your public load load balancer.

  ---

  To accept traffic from the internet, you create a public load balancer. The service assigns it a public IP address that serves as the entry point for incoming traffic. You can associate the public IP address with a friendly DNS name through any DNS vendor. A public load balancer is regional in scope. If your region includes multiple availability domains, a public load balancer requires either a regional subnet (recommended) or two availability domain- specific (AD-specific) subnets, each in a separate availability domain. With a regional subnet, the Load Balancing service creates a primary load balancer and a standby load balancer, each in a different availability domain, to ensure accessibility even during an availability domain outage. If you create a load balancer in two AD-specific subnets, one subnet hosts the primary load balancer and the other hosts a standby load balancer. If the primary load balancer fails, the public IP address switches to the secondary load balancer. The service treats the two load balancers as equivalent and you cannot specify which one is "primary". Whether you use regional or AD-specific subnets, each load balancer requires one private IP address from its host subnet. The Load Balancing service supplies a floating public IP address to the primary load balancer. The floating public IP address does not come from your backend subnets. You cannot specify a private subnet for your public load balancer. The backend servers (Compute instances) associated with a backend set can exist anywhere, as long as the associated network security groups (NSGs), security lists, and route tables allow the intended traffic flow. Oracle recommends that you create your load balancer in a regional subnet. Oracle recommends that you distribute your backend servers across all availability domains within the region.