최신 1Z0-931-20 무료덤프 - Oracle Autonomous Database Cloud 2020 Specialist

문제1

Which of these database features is NOT part of the Autonomous Database?

A. Online Indexing

B. Java in the Database

C. Flashback Database

D. Real Application Clusters (RAC)

정답: B

문제2

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 terminated and rolled back.

C. Active transactions are paused.

D. Active transactions continue running unaffected.

정답: C

문제3

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

B. MEDIUM

C. HIGH

D. TPURGENT

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제4

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?

A. Create a new developer account.

B. Create an IDCS user with the APEX role.

C. Access the APEX Administration Services and create the workspace for the developer.

D. Create a database user with the APEX role.

정답: C

문제5

A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?

A. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.

B. Only the migration to ADB is possible from an on-premise installation of Golden Gate.

C. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.

D. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.

E. The described scenario is correct, can be used for migration and fallback scenarios.

정답: B

문제6

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

B. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

C. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

D. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

정답: A

문제7

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

A. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType =
'OLTP'

C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType =
`DW'

D. Allow group ADB-Admins to manage autonomous-database in tenancy.

정답: B

문제8

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

A. Parallelism is not enabled by default.

B. You have direct access to the database node.

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

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

정답: A,D

문제9

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 only load data from one source into one destination table.

C. Data Sync can not transform your data while loading it into the destination table.

D. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제10

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

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

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

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

정답: A,B,D

설명: (DumpTOP 회원만 볼 수 있음)

최신 1Z0-931-20 무료덤프 - Oracle Autonomous Database Cloud 2020 Specialist

우리와 연락하기

유용한 링크

최신 업데이트