1z0-1067-24 Exam Dumps - Oracle Cloud Infrastructure 2024 Cloud Operations Professional

Go to page:

Question # 17

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

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.

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.

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.

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.

Full Access

Question # 18

Scenario: 4Â (Write Identity and Access Management Policies to Secure a Tenancy)

Scenario Description:Â (Hands-On Performance Exam Certification)

YourÂ company has signed up for an OCI tenancy to migrate an e-commerceÂ application, a supply chain management (SCM) system, and a customerÂ relationship management (CRM) system.Â You have been tasked with settingÂ up the requisite identity and access management (IAM) policies for yourÂ team to begin developing on OCI.

You start by setting up the following compartment hierarchy:

Tenancy (root)

Â Â Common-Infra

Â Â Â Â Â Network

Â Â Â Â Â Security

Â Â Applications

Â Â Â Â Â E-Comm

Â Â Â Â Â SCM

Â Â Â Â Â CRM

You create the following groups:

Network-Admins

Security-Admins

E-Comm-Admins

SCM-Admins

CRM-Admins

Write the IAM policies for the following use cases:

Assumptions:

Assume that all policies will be attached to the root compartment.

Write one policy per given text box.

KeepÂ policies as simple as possible by using verbs instead of permissionsÂ (for example, â€œinspect orm-stacksâ€ instead of â€œORM_STACK_INSPECTâ€) andÂ aggregate resource types instead of individual ones (for example,Â â€œfile-familyâ€ instead of â€œfile-systemsâ€ and â€œmount-targetsâ€)

Task 1

WriteÂ a policy statement to enable Network-Admins to create and destroyÂ network-related resources, such as VCNs, subnets, gateways, and so on inÂ the Network compartment.

Task 2

WriteÂ policy statements to enable E-Comm-Admins to provision and destroyÂ compute instances in the E-Comm compartment by using networkingÂ resources in the Network compartment.[Write one policy per given textÂ box]

Task 3

Write aÂ policy statement to enable SCM-Admins to provision, destroy, and back upÂ block volumes in the SCM compartmentâ€”but only in Phoenix and London.

Full Access