Download Oracle.1z0-931.VCEplus.2019-12-17.60q.vcex

Download Exam

File Info

Exam Oracle Autonomous Database Cloud 2019 Specialist
Number 1z0-931
File Name Oracle.1z0-931.VCEplus.2019-12-17.60q.vcex
Size 40 KB
Posted Dec 17, 2019
Download Oracle.1z0-931.VCEplus.2019-12-17.60q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)


  1. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
  2. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
  3. Data Pump is faster to migrate database than using RMAN.
  4. Data Pump creates the tablespaces used by your Autonomous Database.
Correct answer: AC
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-data-pump.html#GUID-30DB1EEA-DB45-49EA-9E97-DF49A9968E24
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-data-pump.html#GUID-30DB1EEA-DB45-49EA-9E97-DF49A9968E24



Question 2

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?


  1. UPDATE_OBJECT_INFO
  2. MODIFY_SNAPSHOT_SETTINGS
  3. CREATE_BASELINE_TEMPLATE
  4. MODIFY_BASELINE_WINDOW_SIZE
Correct answer: B
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3



Question 3

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


  1. Backing up the database.
  2. Mask your sensitive data.
  3. Patching the database.
  4. Automatically optimize the workload.
Correct answer: B
Explanation:
Reference: https://www.oracle.com/database/what-is-autonomous-database.html
Reference: https://www.oracle.com/database/what-is-autonomous-database.html



Question 4

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


  1. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
  2. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
  3. 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 abadfile table on Autonomous Data Warehouse.
  4. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database. 
  5. 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.
Correct answer: BDE
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-930632E1-B7BF-4ECA-8F78-5E5A205C0865
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-930632E1-B7BF-4ECA-8F78-5E5A205C0865



Question 5

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


  1. Online Indexing
  2. Flashback Database
  3. Real Application Clusters (RAC)
  4. Java in the Database
Correct answer: D



Question 6

Which two statements are true with regards to Oracle Data Sync? (Choose two.)


  1. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
  2. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
  3. Data Sync can load your data in parallel in order to speed up the loading process.
  4. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
Correct answer: AC
Explanation:
Reference: https://www.oracle.com/technetwork/middleware/bicloud/downloads/bicsdatasync2-3-readme-3715844.pdf (4)
Reference: https://www.oracle.com/technetwork/middleware/bicloud/downloads/bicsdatasync2-3-readme-3715844.pdf (4)



Question 7

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?


  1. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
  2. The Oracle Client Credential file is downloaded as a ZIP file.
  3. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
  4. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
Correct answer: A



Question 8

What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?


  1. ADBDEV 
  2. ADMIN
  3. DWROLE
  4. ADWC
Correct answer: C
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873



Question 9

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


  1. CREATE ANALYTIC MEASURE
  2. CREATE ANALYTIC LEVEL
  3. CREATE ANALYTIC HIERARCHY
  4. CREATE ANALYTIC VIEW
  5. CREATE ATTRIBUTE DIMENSION
Correct answer: DE
Explanation:
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D



Question 10

What are three methods to load data into the Autonomous Database? (Choose three.)


  1. Oracle GoldenGate
  2. Transportable Tablespace
  3. RMAN Restore
  4. Oracle Data Pump
  5. SQL*Loader
Correct answer: ADE
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-1351807C-E3F7-4C6D-AF83-2AEEADE2F83E
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-1351807C-E3F7-4C6D-AF83-2AEEADE2F83E









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files