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

문제1

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?

A. TP

B. LOW

C. MEDIUM

D. TPURGENT

정답: D

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

문제2

Which two system privileges does a user need to create analytic views? (Choose two.)

A. CREATE ATTRIBUTE DIMENSION

B. CREATE ANALYTIC HIERARCHY

C. CREATE ANALYTIC LEVEL

D. CREATE ANALYTIC VIEW

E. CREATE ANALYTIC MEASURE

정답: A,D

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

문제3

Which task is NOT automatically performed by the Oracle Autonomous Database?

A. Mask your sensitive data.

B. Patching the database.

C. Backing up the database.

D. Automatically optimize the workload.

정답: A

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

문제4

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

A. Release Update (RU)

B. Quarterly Bundle Patch (QBP)

C. Prior Release Update Revision (PRUR)

D. Prior Release Update (PRU)

정답: A

문제5

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

A. OCPUs and storage can be scaled independently.

B. Storage in TB cannot be larger than the number of OCPUs.

C. OCPUs and storage must remain in sync.

D. Increasing OCPUs will automatically increase storage.

정답: D

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

문제6

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 회원만 볼 수 있음)

문제7

Which can be Scaled independently of the number of CPUs in an Autonomous Database?

A. Concurrency

B. Sessions

C. Storage

D. Parallelism

E. Memory

정답: C

문제8

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

A. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

B. It is enabled by default.

C. The indexing feature is implemented as an automatic task that runs at a fixed interval.

D. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

E. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

정답: C

문제9

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support?

A. 900

B. 2700

C. 1500

D. 1800

정답: B

문제10

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

A. Execute alter database for user MTHEO tablespace DATA quota = 10G;

B. Execute alter user MTHEO quota unlimited on tablespace DATA;

C. Execute alter tablespace DATA set quota = 10G;

D. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

정답: C

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

우리와 연락하기

유용한 링크

최신 업데이트