Oracle 1Z0-1067-25 Quiz 1 Topic 1 Questions 1-5

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.)

ACreate 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.

BCreate 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.

CCreate 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.

DCreate 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.

Show Answer

Question: 2

You have been asked to update the lifecycle policy for object storage using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI). Which command can successful-ly update the policy? (Choose the best answer.)

Aoci os object-lifecycle-policy put --ns <object_storage_namespace> --bn <bucket_name>

Boci os object-lifecycle-policy get --ns <object_storage_namespace> --bn <bucket_name>

Coci os object-lifecycle-policy delete --ns <object_storage_namespace> --bn <buck-et_name>

Doci os object-lifecycle-policy put --ns <object_storage_namespace> --bn <bucket_name> -- --items <json_formatted_lifecycle_policy>

Show Answer

Question: 3

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.)

AIf you do not disconnect from the session, your serial console connection will automatically be terminated after 24 hours.

BIt is not possible to connect to the serial console to an instance running Microsoft Windows, however VNC console connection can be used.

CIt is not possible to use VNC console connections to connect to Bare Metal Instances.

DFor security purpose, the console connection will not let you edit system configuration files.

EVNC 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.

Show Answer

Question: 4

When creating an alarm query in Oracle Cloud Infrastructure (OCI) Monitoring, which of the following statement is NOT valid?

AYou must specify Trigger rule (threshold or absence).

BYou must specify an interval

CYou must specify Statistic

DYou must specify a Metric

EYou must specify Resource Group

Show Answer

Question: 5

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

q5_1Z0-1067-25

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

AThe traffic will be forwarded randomly to any of the pools mentioned in the rules.

BThe traffic will be forwarded at the same time to both Pool 1 and Pool 2.

CThe traffic will be forwarded to Pool 1. If Pool 1 is not available, then it will be for-warded to Pool 2.

DThe traffic will be dropped.

Show Answer

Oracle 1Z0-1067-25 Quiz:1 Topic:1 Questions:1-5