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

Oracle 1Z0-1072-22 Online Questions & Answers

• Question 111:

  You have hired a new employee to run reports from the Autonomous Data Warehouse (ADW) and are not confident in their SQL writing ability. Into which consumer group will you assign this individual to minimize the impact of their code?

  A. Lowest
  B. Medium
  C. Highest
  D. High
  E. Low
  E. Low

  ---

  in ADW, The tnsnames.ora file provided with the credentials zip file contains three database service names identifiable as high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Data Warehouse. high: The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements. Any SQL statement in this service can use all the CPU and IO resources in your database. The number of concurrent SQL statements that can be run in this service is 3, this number is independent of the number of OCPUs in your database. medium: The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements. Any SQL statement in this service can use multiple CPU and IO resources in your database. The number of concurrent SQL statements that can be run in this service depends on the number of OCPUs in your database. low: The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements. Any SQL statement in this service can use a single CPU and multiple IO resources in your database. The number of concurrent SQL statements that can be run in this service can be up to 300 times the number of OCPUs. The predefined service names provide different levels of performance and concurrency for Autonomous DB Choose whichever database service offers the best balance of performance and concurrency. Use the low database service name. to minimize the impact of their SQLs to by low consumer group

• Question 112:

  Which does NOT set a variable in Terraform?

  A. Passing the variable with a var statement to Terraform
  B. Setting the variable as key value pairs in a file in a subdirectory named tfvar
  C. A default value in the variable declaration within a TF plan file
  D. Setting the environment variable using a TF_VAR_ predicate in front of the variable name
  B. Setting the variable as key value pairs in a file in a subdirectory named tfvar

• Question 113:

  What is the maximum IP address size range that you can have in a Virtual Cloud Network?

  A. /16
  B. /26
  C. /24
  D. /8
  A. /16

  ---

  When you create your VCN, you assign a contiguous IPv4 CIDR block of your choice. VCN sizes ranging from /16 (65,533 IP addresses) to /30 (1 IP address) are allowed. Example: 10.0.0.0/16, 192.168.0.0/24.

• Question 114:

  Which resource is required when connecting to your on-premise network from your Virtual Cloud Network (VCN) via IPSec VPN or FastConnect?

  A. Internet Gateway (IGW)
  B. Dynamic Routing Gateway (DRG)
  C. local peering gateway
  D. NAT
  B. Dynamic Routing Gateway (DRG)

  ---

  References: https://cloud.oracle.com/networking/vcn/faq

• Question 115:

  Which statement is true about cloning a volume?

  A. You need to detach a volume before cloning from it.
  B. A cloned volume is the same as a snapshot that has a dependency on the source volume.
  C. You can change the block volume size when cloning a volume.
  D. You can create a clone for a volume across regions.
  C. You can change the block volume size when cloning a volume.

  ---

  References:

  https://docs.cloud.oracle.com/iaas/Content/Block/Tasks/cloningavolume.htm?tocpath=Services%7C Block%20Volume%7C_____14

• Question 116:

  As the Cloud Architect for your company, you have been tasked with designing a high performance (HPC) cluster in Oracle Cloud Infrastructure (OCI). The following requirements have been defined:

  The cluster must be a minimum of three nodes, but may increase to six nodes when demand requires.

  The cluster must be resilient to any potential infrastructure failures. To minimize latency, all nodes must be deployed within the same availability domain (AD). Adding or replacing nodes within the cluster should take no more than 30 minutes.

  Which two steps should be performed to satisfy these requirements in OCI? (Choose two.)

  A. Deploy the cluster in a single AD with a shared file system that leverages the file storage service (FSS). Deploy a standby cluster in another AD and configure it to use the same shared file system.
  B. Deploy the cluster in a single AD. Place each of the nodes in one of the three different fault domains in that AD.
  C. Create a backup of your HPC node compute instance boot volume. Launch new compute instances directly from the backup reduce provisioning time.
  D. Create a custom image of your HPC node compute instance. Launch new compute instances using this image to reduce provisioning time.
  E. Deploy the cluster in a single AD. Place each of the nodes in a different virtual cloud network (VCN) subnet.
  B. Deploy the cluster in a single AD. Place each of the nodes in one of the three different fault domains in that AD.
  D. Create a custom image of your HPC node compute instance. Launch new compute instances using this image to reduce provisioning time.

  ---

  A fault domain is a grouping of hardware and infrastructure within an availability domain. Each availability domain contains three fault domains. Fault domains provide anti-affinity: they let you distribute your instances so that the instances are not on the same physical hardware within a single availability domain. A hardware failure or Compute hardware maintenance event that affects one fault domain does not affect instances in other fault domains. In addition, the physical hardware in a fault domain has independent and redundant power supplies, which prevents a failure in the power supply hardware within one fault domain from affecting other fault domains. To control the placement of your compute instances, bare metal DB system instances, or virtual machine DB system instances, you can optionally specify the fault domain for a new instance or instance pool at launch time. If you don't specify the fault domain, the system selects one for you. Oracle Cloud Infrastructure makes a best-effort anti-affinity placement across different fault domains, while optimizing for available capacity in the availability domain. To change the fault domain for an instance, terminate it and launch a new instance in the preferred fault domain. Use fault domains to do the following things: Protect against unexpected hardware failures or power supply failures. Protect against planned outages because of Compute hardware maintenance.

• Question 117:

  Which three are default Virtual Cloud Network (VCN) components? (Choose three.)

  A. Security List
  B. Dynamic Routing Gateway
  C. DHCP options
  D. Internet Gateway
  E. Route Table
  A. Security List
  C. DHCP options
  E. Route Table

  ---

  References:

  (1)

  => Populated by Default

  (0)

  => Not Populated by Default

  Resources

  ==========

  Subnets (0)

  Route Tables (1)

  Internet Gateways (0)

  Dynamic Routing Gateways (0)

  Network Security Groups (0)

  Security Lists (1)

  DHCP Options (1)

  Local Peering Gateways (0)

  NAT Gateways (0)

  Service Gateways (0)

• Question 118:

  Which two are Regional resources in Oracle Cloud Infrastructure? (Choose two.)

  A. Ephemeral public IPs
  B. Compartments
  C. Compute images
  D. Dynamic groups
  E. Block volume backups
  B. Compartments
  D. Dynamic groups

  ---

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

• Question 119:

  Which two are NOT an image source when launching a new compute instance? (Choose two.)

  A. boot volume
  B. custom image
  C. Object Storage
  D. bare metal instance
  C. Object Storage
  D. bare metal instance

• Question 120:

  You are asked to create a user that will access programmatic endpoints in Oracle Cloud Infrastructure. The user must not be allowed to authenticate by username and password. Which two authentication options can you use? (Choose two.)

  A. PEM Certificate file
  B. Auth tokens
  C. API signing key
  D. Windows password
  E. SSH key pair
  B. Auth tokens
  C. API signing key