1Z0-1067-21 Online Practice Questions and Answers

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.

Which two statements about the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) are TRUE? (Choose two.)

A. You can run CLI commands from inside OCI Regions only.

B. You can filter CLI output using the JMESPath query option for JSON.

C. The CLI provides an automatic way to connect with instances provisioned on OCI.

D. The CLI allows you to use the Python language to interact with OCI APIs.

E. The CLI provides the same core functionality as the Console, plus additional commands.

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.

Which two statements are TRUE about Object Storage data security and encryption in Oracle Cloud Infrastructure (OCI)? (Choose two.)

A. Client-side encryption is managed by the customer.

B. Data needs to be decrypted on the client side before retrieving it.

C. OCI Vault Management is used by default to provide data security.

D. All traffic to and from Object Storage service is encrypted using TLS.

E. A VPN connection to OCI is required to ensure secure data transfer to an object storage bucket.

You are using Oracle Cloud Infrastructure (OCI) services across several regions: us-phoenix-1, usashburn-1, uk-london-1 and ap-tokyo-1. You have creates a separate administrator group for each region: PHX-Admins, ASH-Admins, LHR-Admins and NRT-Admins, respectively.

You want to restrict admin access to a specific region. E.g., PHX-Admins should be able to manage all resources in the us-phoenix-1 region only and not any other OCI regions.

What IAM policy syntax is required to restrict PHX-Admins to manage OCI resources in the us-phoenix-1 region only? (Choose the best answer.)

A. Allow group PHX-Admins to manage all-resources in tenancy where request.region= ‘phx’

B. Allow group PHX-Admins to manage all-resources in tenancy where request.permission= ‘phx’

C. Allow group PHX-Admins to manage all-resources in tenancy where request.target= ‘phx’

D. Allow group PHX-Admins to manage all-resources in tenancy where request.location= ‘phx’

Multiple teams are sharing a tenancy in Oracle Cloud Infrastructure (OCI). You are asked to figure out an appropriate method to manage OCI costs.

Which is NOT a valid technique to accurately attribute costs to resources used by each team? (Choose the best answer.)

A. Create a Cost-Tracking tag. Apply this tag to all resources with team information. Use the OCI cost analysis tools to filter costs by tags.

B. Create separate compartment for each team. Use the OCI cost analysis tools to filter costs by compartment.

C. Create an Identity and Access Management (IAM) group for each team. Create an OCI budget for each group to track spending.

D. Define and use tags for resources used by each team. Analyze usage data from the OCI Usage Report which has detailed information about resources and tags.

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 = usphoenix–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

You are asked to implement the disaster recovery (DR) and business continuity requirements for Oracle Cloud Infrastructure (OCI) Block Volumes. Two OCI regions being used: a primary/source region and a DR/destination region. The requirements are:

There should be a copy of data in the destination region to use if a region-wide disaster occurs in the source region Minimize costs

Which design will help you meet these requirements? (Choose the best answer.)

A. Clone block volumes. Use Object Storage lifecycle management to automatically move clone objects to Archive Storage. Copy Archive Storage buckets from source region to destination at regular intervals.

B. Clone block volumes. Copy block volume clones from source region to destination region at regular intervals.

C. Back up block volumes. Copy block volume backups from source region to destination region at regular intervals.

D. Back up block volumes. Use Object Storage lifecycle management to automatically move backup objects to Archive Storage. Copy Archive Storage buckets from source region to destination at regular intervals.

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.

Your team implemented a SaaS application that requires a whole system deployment for each new customer. The infrastructure provisioning is already automated via Terraform, and now you have been asked to develop an Ansible playbook to centralize configuration file management and deployment.

What is the most effective way to ensure your playbooks are utilizing up-to-date and accurate inventory? (Choose the best answer.)

A. Export an inventory list from the Oracle Cloud Infrastructure Web console.

B. Export an inventory list using Terraform apply command.

C. Implement a Command Line Interface script to list all the resources and run it within Ansible to generate a dynamic inventory list.

D. Download the dynamic inventory script provided by Oracle Cloud Infrastructure and include it in the playbook invocation command.