Oracle 1Z0-1067-21 Online Practice Questions and Exam Preparation

Oracle 1Z0-1067-21 Online Questions & Answers

• Question 31:

  You have been monitoring your company's applications running in Oracle Cloud Infrastructure (OCI) and notice that the application is using OCI Traffic Management service. This service uses a traffic steering policy to distribute the DNS traffic based on subnet addresses in a rule set.

  Which steering policy is in use in this particular case? (Choose the best answer.)

  A. Load Balancing policy
  B. Geolocation steering
  C. ASN steering policy
  D. IP Prefix steering
  C. ASN steering policy

  ---

  Reference: https://k21academy.com/1z0-997/traffic-management-in-oci/

• Question 32:

  You have a Linux compute instance located in a public subnet in a VCN which hosts a web application. The security list attached to subnet containing the compute instance has the following stateful ingress rule.

  

  The Route table attached to the Public subnet is shown below. You can establish an SSH connection into the compute instance from the internet. However, you are not able to connect to the web server using your web browser.

  

  Which step will resolve the issue? (Choose the best answer.)

  A. In the route table, add a rule for your default traffic to be routed to NAT gateway.
  B. In the security list, add an ingress rule for port 80 (http).
  C. In the security list, remove the ssh rule.
  D. In the route table, add a rule for your default traffic to be routed to service gateway.
  D. In the route table, add a rule for your default traffic to be routed to service gateway.

• Question 33:

  You are working with Terraform on your laptop and have been tasked with spinning up multiple compute instances in Oracle Cloud Infrastructure (OCI) for a project. In addition, you are also required to collect IP addresses of provisioned instances and write them to a file and save it in your laptop.

  Which specific Terraform functionality can help accomplish this task? (Choose the best answer.)

  A. Terraform modules
  B. Terraform remote state
  C. Terraform local-exec
  D. Terraform remote-exec
  A. Terraform modules

• Question 34:

  You have created a geolocation steering policy in the Oracle Cloud Infrastructure (OCI) Traffic Management service, with this configuration:

  

  What happens to requests that originate in Africa? (Choose the best answer.)

  A. The traffic will be forwarded at the same time to both Pool 1 and Pool 2.
  B. The traffic will be dropped.
  C. The traffic will be forwarded randomly to any of the pools mentioned in the rules.
  D. The traffic will be forwarded to Pool 1. If Pool 1 is not available, then it will be forwarded to Pool 2.
  D. The traffic will be forwarded to Pool 1. If Pool 1 is not available, then it will be forwarded to Pool 2.

• Question 35:

  Recently, your e-commerce web application has been receiving significantly more traffic than usual. Users are reporting they often encounter a 503 Service Error when trying to access your site. Sometimes the site is very slow.

  You check your instance pool configuration to confirm that the maximum number of instances is configured to allow 20 compute instances. Currently, 14 compute instances have been provisioned by the instance pool. You also confirm that

  current CPU utilization across all hosts exceeds the scale-out threshold you set in your auto-scaling policy. However, the instance pool is not provisioning any new instances.

  What can you check to determine why the application is NOT functioning properly? (Choose the best answer.)

  A. Verify that the new offer feature code did not introduce any performance bugs.
  B. Verify that the database is accessible.
  C. Verify that the compute resource quota has not been exceeded.
  D. Verify that the Quality Assurance team is not currently performing load-testing against production.
  C. Verify that the compute resource quota has not been exceeded.

• Question 36:

  You have created an Autonomous Data Warehouse (ADW) service in your company's Oracle Cloud Infrastructure (OCI) tenancy and you now have to load historical data into it. You have already extracted this historical data from multiple data marts and data warehouses. This data is stored in multiple CSV text files and these files are ranging in size from 25 MB to 20 GB.

  Which is the most efficient and error tolerant method for loading data into ADW? (Choose the best answer.)

  A. Create Auth token, use it to create an object storage credential by executing DBMS_CLOUD.CREATE_CREDENTIAL, using the web console upload the CSV files to an OCI object storage bucket, create the tables in the ADW database and then execute DBMS_CLOUD.COPY_DATA for each CSV file to copy the contents into the corresponding ADW database table.
  B. Create the tables in the ADW database and then execute SQL*Loader for each CSV file to load the contents into the corresponding ADW database table.
  C. Create Auth token, use it to create an object storage credential by executing DBMS_CLOUD.CREATE_CREDENTIAL, using OCI CLI upload the CSV files to an OCI object storage bucket, create the tables in the ADW database and then execute Data Pump Import for each CSV file to copy the contents into the corresponding ADW database table.
  D. Create Auth token, use it to create an object storage credential by executing DBMS_CLOUD.CREATE_CREDENTIAL, using OCI CLI upload the CSV files to an OCI object storage bucket, create the tables in the ADW database and then execute DBMS_CLOUD.COPY_DATA for each CSV file to copy the contents into the corresponding ADW database table.
  D. Create Auth token, use it to create an object storage credential by executing DBMS_CLOUD.CREATE_CREDENTIAL, using OCI CLI upload the CSV files to an OCI object storage bucket, create the tables in the ADW database and then execute DBMS_CLOUD.COPY_DATA for each CSV file to copy the contents into the corresponding ADW database table.

• Question 37:

  One of the compute instances that you have deployed on Oracle Cloud Infrastructure (OCI) is malfunctioning. You have created a console connection to remotely troubleshoot it. Which two statements about console connections are TRUE? (Choose two.)

  A. It is not possible to use VNC console connections to connect to Bare Metal Instances.
  B. VNC console connection uses SSH port forwarding to create a secure connection from your local system to the VNC server attached to your instance's console.
  C. It is not possible to connect to the serial console to an instance running Microsoft Windows, however VNC console connection can be used.
  D. For security purpose, the console connection will not let you edit system configuration files.
  E. If you do not disconnect from the session, your serial console connection will automatically be terminated after 24 hours.
  B. VNC console connection uses SSH port forwarding to create a secure connection from your local system to the VNC server attached to your instance's console.
  E. If you do not disconnect from the session, your serial console connection will automatically be terminated after 24 hours.

• Question 38:

  You have a group pf developers who launch multiple VM.Standard2.2 compute instances every day into the compartment Dev. As a result, your OCI tenancy quickly hit the service limit for this shape. Other groups can no longer create new instances using VM.Standard2.2 shape.

  Because of this, your company has issued a new mandate that the Dev compartment must include a quota to allow for use of only 20 VM.Standard2.2 shapes per Availability Domain. Your solution should not affect any other compartment in the tenancy.

  Which quota statement should be used to implement this new requirement? (Choose the best answer.)

  A. set compute quota vm-standard2–2count to 10 in compartment dev where request.region = us-phoenix–1
  B. set compute quota vm-standard2–2–count to 20 in compartment dev
  C. zero compute quotas in tenancy set compute quota vm–standard2–2–count to 20 in compartment dev
  D. zero compute quotas in tenancy set compute quota vm–standard2–2–count to 20 in tenancy dev
  A. set compute quota vm-standard2–2count to 10 in compartment dev where request.region = us-phoenix–1

• Question 39:

  Here is a partial code from a Terraform template written for Oracle Cloud Infrastructure (OCI):

  

  What operation(s) does it perform? (Choose the best answer.)

  A. Provides object read and write access for an OCI Object Storage bucket.
  B. Creates a pre-authenticated request for objects in an OCI Object Storage bucket.
  C. Creates a URL to provide access to an OCI Object Storage bucket for managing objects.
  D. Creates a lifecycle policy for an OCI Object Storage bucket for moving data to Archival storage at a specified time.
  A. Provides object read and write access for an OCI Object Storage bucket.

• Question 40:

  Which technique does NOT help you get the optimal performance out of the Oracle Cloud Infrastructure (OCI) File Storage service? (Choose the best answer.)

  A. Limit access to the same Availability Domain (AD) as the File Storage service where possible.
  B. Serialize operations to the file system to access consecutive blocks as much as possible.
  C. Right size compute instances from where file system is accessed based on their network capacity.
  D. Increase concurrency by using multiple threads, multiple clients, and multiple mount targets.
  D. Increase concurrency by using multiple threads, multiple clients, and multiple mount targets.

  ---

  Reference: https://www.oracle.com/a/ocom/docs/cloud/file-storage-performance-guide.pdf (6)