Oracle 1Z0-931 問題集

質問 1：
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
A. Load data using Data Pump
B. Import Table
C. Create a Data Set
D. Replicate the table using Golden Gate
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to 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.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.
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.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
A. Sessions
B. Memory
C. Storage
D. Concurrency
E. Parallelism
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?
A. ADMIN
B. SCOTT
C. SYS
D. DWDEV
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
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 Data Warehouse workloads are optimized for mixed workloads.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
A. Scaling cannot happen while there are active transactions in the database.
B. Active transactions are paused.
C. Active transactions continue running unaffected.
D. Active transactions are terminated and rolled back.
正解：C
解説: (Topexam メンバーにのみ表示されます)