1Z1-931 무료 덤프문제 온라인 액세스

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

• A.The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
• B.The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• C.The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• D.The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
• E.The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

• A.Import Table
• B.Create a Data Set
• C.Load data using Data Pump
• D.Replicate the table using Golden Gate

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

• A.Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• B.Autonomous Data Warehouse workloads are optimized for mixed workloads.
• C.Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
• D.Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

• A.OCPUs and storage must remain in sync.
• B.OCPUs and storage can be scaled independently.
• C.Increasing OCPUs will automatically increase storage.
• D.Storage in TB cannot be larger than the number of OCPUs.

Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?

• A.Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
• B.Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
• C.Data Sync can only load data from one source into one destination table.
• D.Data Sync can not transform your data while loading it into the destination table.