1Z0-931-20試験無料問題集（118題）「Oracle Autonomous Database Cloud 2020 Specialist 認定」

出題：1

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. ATP and ADW

B. Autonomous Data Warehouse only

C. Autonomous Transaction Processing only

D. Hybrid Columnar compression

正解：B 解答を投票する

出題：2

What two methods can you use to define Machine Learning Users? (Choose two.)

A. SQL/Developer

B. Oracle Cloud Infrastructure Console

C. Client tools

D. Use DBMS_CLOUD_ADMIN package

正解：A,B 解答を投票する

出題：3

What is the default port number for accessing a newly created Autonomous Database?

A. 1521

B. 1523

C. 1526

D. 1522

E. 1524

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Your company is developing a new database application in Oracle Cloud Infrastructure. You need to test application functionality including a hardware failure scenario. Since the application is still in the development phase, you want to minimize infrastructure costs.
Which database service deployment option meets this requirement?

A. single node bare metal system

B. two node bare metal system with data guard enabled

C. Autonomous Data Warehouse (ADW) system as it provides auto fail over functionality

D. two node real application cluster (RAC) system

正解：D 解答を投票する

出題：5

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.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

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

D. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

E. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

正解：A,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

A. Application User Creation

B. Database Upgrades

C. Data Loading

D. Backups

E. Firmware Patching

正解：B,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

A. MEDIUM

B. TP

C. HIGH

D. TPURGENT

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

What is the default retention period for both Automatic and Manual Autonomous Database Backups?

A. 60 days

B. 90 days

C. 30 days

D. 7 days

E. One Year

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Which statement is correct about managing and monitoring of Autonomous Database?

A. You can use Service console to move Autonomous DB between compartments.

B. You can use Service console to enable or disable auto scaling of Autonomous DB.

C. You can use Service console to manage runaway SQL statements on Autonomous DB.

D. You can use Service console to create manual backups of Autonomous database.

正解：A 解答を投票する

出題：10

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

A. Oracle Database Result Cache is enabled by default for all SQL statements.

B. You have direct access to the database node.

C. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

D. Parallelism is not enabled by default.

正解：C,D 解答を投票する

1Z0-931-20試験無料問題集「Oracle Autonomous Database Cloud 2020 Specialist 認定」