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 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.
• 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 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.
• D. 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.

You are using Oracle Cloud Infrastructure (OCI) services across several regions: us-phoenix-1, us-ashburn-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 intenancy where re-guest.location='us-phoenix-1'
• B. Allow group PHX-Admins to manage all-resources in tenancy where re-guest.target='us-phoenix-1'
• C. Allow group PHX-Admins to manage all-resources in tenancy where re-guest.region='us-phoenix-1'
• D. Allow group PHX-Admins to manage all-resources in tenancy where re-guest.permission=
  'us-phoenix-1'

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

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 Do-main. 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. zero compute quotas in tenancy set compute quota vm standard22--count to 20 in tenancy dev
• B. set compute quota vm-standard2-count to 10 in compartment dev where request.region = us-phoenix-01
• C. zero compute quotas in tenancy set compute quota vm standard22--count to 20 in compartment dev
• D. set compute quota vm-standard22--count to 20 in compartment dev

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 local-exec
• B. Terraform remote state
• C. Terraform modules
• D. Terraform remote-exec