1Z0-1067-25 by Oracle Actual Free Exam Q&As

Question 1

You have created an Autonomous Data Warehouse (ADW) service in your company 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 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. C. 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. 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 Data Pump Import for each CSV file to copy the contents into the corresponding ADW database table.

Discussion 0

Correct Answer: B Vote an answer

Question 2

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. A VPN connection to OCI is required to ensure secure data transfer to an object storage bucket. D. OCI Vault Management is used by default to provide data security. E. All traffic to and from Object Storage service is encrypted using TLS.

Discussion 0

Correct Answer: A,E Vote an answer

Question 3

You have created several block volumes in the us-phoenix-1 region in a specific compart-ment. The compartment can be identified by the following Oracle Cloud Infrastructure (OCI) unique identifier, or ocid1.compartment.oc1.phx..exampleuniquelD Your manager has asked you to leverage the OCI monitoring service and write a metric query showing all read IOPS at a one-minute interval, filtered to this compartment and aggregated for the maximum. Which metric query will you create?

A. IopsRead[lm]{compartmentId = 'odd1.compartment.ocl.phx..exampleuniquelD'}.grouping().mean() B. Iop-sRead[lm{compartmentId='ocidl.compartment.ocl.phx..exampleuniquelD'}.grouplng().max() C. IopsRead[lm]{compartmentId='ocldl.compartment.ocl.phx..exampleuniquelD'}.max() D. Iop-sWrite[lm]{compartmentId=Hocidl.compartment.ocl.phx..exampleuniquelD'}.mean()

Discussion 0

Correct Answer: B Vote an answer

Question 4

You have a group of developers who launch multiple VM.Standard3.Flex compute in-stances every day into the compartment Dev. As a result, your Oracle Cloud Infrastructure (OCI) tenancy quickly hits the service limit for this shape, and other groups can no longer create new instances using the VM.Standard3.Flex shape. Therefore, your company issues a new mandate that the Dev compartment must include a quota that allows the use of only 20 VM.Standard3.Flex OCPUs per availability domain, without affecting any other compartment in the tenancy. Which quota statement would you use to implement this new requirement?

A. set compute-core quota standard3-core-count to 20 in compartment dev B. set compute-core quota standard3-core-count to 20 in compartment dev where re-quest.region = us-phoenix-1 C. zero compute-core quotas in tenancy set compute-core quota standard3-core-count to 20 in compartment dev D. zero compute-core quotas in tenancy set compute-core quota standard3-core-count to 20 in tenancy dev

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which statement about the Oracle Cloud Infrastructure (OCI) instance console connection is TRUE?

A. It does not let you reset the SSH key B. It does not let you use the boot menu during the reboot process C. It does not let you execute the sized-limit script. D. It does not let you edit the configuration files needed to recover the instance

Discussion 0

Correct Answer: B Vote an answer

Question 6

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 security list, remove the ssh rule. B. In the route table, add a rule for your default traffic to be routed to NAT gateway. C. In the security list, add an ingress rule for port 80 (http). D. In the route table, add a rule for your default traffic to be routed to service gateway.

Discussion 0

Correct Answer: C Vote an answer

Question 7

Your deployment platform within Oracle Cloud Infrastructure (OCI) leverages a compute instance with multiple block volumes attached. There are multiple teams that use the same compute instance and have access to these block volumes. You want to ensure that no one accidentally deletes any of these block volumes. You have started to construct the following IAM policy but need to determine which permissions should be used. allow group DeploymentUsers to manage volume-family where ANY { request.permission != <???>, request.permission != <???>, request.permission != <???> } Which permissions can you use in place of <???> in this policy? (Choose the best answer.)

A. VOLUME_DELETE, VOLUME_ATTACHMENT_DELETE, VOL-UME_BACKUP_DELETE B. ERASE_VOLUME, ERASE_VOLUME_ATTACHMENT, ERASE_VOLUME_BACKUP C. DELETE_VOLUME, DELETE_VOLUME_ATTACHMENT, DE-LETE_VOLUME_BACKUP D. VOLUME_ERASE, VOLUME_ATTACHMENT_ERASE, VOL-UME_BACKUP_ERASE

Discussion 0

Correct Answer: A Vote an answer

Question 8

You have been asked to set up connectivity between a client on-premises network and Oracle Cloud Infrastructure (OCI). The requirements are:
* Low latency: The applications are financial and require low latency connectivity into OCI. * Consistency: The application is not tolerant of performance variation.
* Performance: The communications link needs to support up to 1.25 Gbps.
* Encryption: The communications link needs to encrypt any data in transit between the on-premises network and OCI Virtual Cloud Network (VCN). The client wants to implement the above with as low a cost as possible, while meeting all of the requirements. What should you suggest? (Choose the best answer.)

A. Provision FastConnect with a single private virtual circuit. B. Provision a site-to-site IPsec VPN between your on-premises network and your virtual cloud network (VCN) using VPN Connect. C. Provision FastConnect with a single public virtual circuit, and run an IPsec VPN tunnel over the top of this virtual circuit. D. Provision FastConnect with a single private virtual circuit, and run an IPsec VPN tunnel over the top of this virtual circuit. E. Provision FastConnect with a single public virtual circuit.

Discussion 0

Correct Answer: C Vote an answer

Question 9

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 forwarded to Pool 1. If Pool 1 is not available, then it will be for-warded to Pool 2. C. The traffic will be forwarded randomly to any of the pools mentioned in the rules. D. The traffic will be dropped.

Discussion 0

Correct Answer: C Vote an answer

Question 10

You have recently been asked to take over management of your company infrastructure provisioning efforts, utilizing Terraform v0.12 to provision and manage infrastructure resources in Oracle Cloud Infrastructure (OCI).
For the past few days the development environments have been failing to provision. Terraform re-turns the following error:

You locate the related code block in the Terraform config and find the following:
Which correction should you make to solve this issue? (Choose the best answer.)

A. Replace the curly braces { } in lines 11 and 16 with square braces [ ] B. Place a command at the end of line 16 C. Modify line 15 to be the following: tcp_options { min = 22 max =22 } D. Modify line 15 to be the following: tcp_options = {min = 22, max =22)

Discussion 0

Correct Answer: C Vote an answer

Oracle Cloud Infrastructure 2025 Cloud Ops Professional - 1Z0-1067-25 Exam Practice Test