File Info
| Exam | Oracle Autonomous Database Cloud 2019 Specialist |
| Number | 1z0-931 |
| File Name | Oracle.1z0-931.PassCertification.2020-05-12.30q.vcex |
| Size | 21 KB |
| Posted | May 12, 2020 |
| Download | Oracle.1z0-931.PassCertification.2020-05-12.30q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
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.)
- Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
- Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
- Data Pump is faster to migrate database than using RMAN.
- 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?
- UPDATE_OBJECT_INFO
- MODIFY_SNAPSHOT_SETTINGS
- CREATE_BASELINE_TEMPLATE
- 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?
- Backing up the database.
- Mask your sensitive data.
- Patching the database.
- 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 of these database features is NOT part of the Autonomous Database?
- Online Indexing
- Flashback Database
- Real Application Clusters (RAC)
- Java in the Database
Correct answer: D
Question 5
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
- ADBDEV
- ADMIN
- DWROLE
- 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 6
What are three methods to load data into the Autonomous Database? (Choose three.)
- Oracle GoldenGate
- Transportable Tablespace
- RMAN Restore
- Oracle Data Pump
- 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
Question 7
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
- Active transactions continue running unaffected.
- Active transactions are paused.
- Scaling cannot happen while there are active transactions in the database.
- Active transactions are terminated and rolled back.
Correct answer: B
Explanation:
Question 8
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
- User with DWROLE can still access the database.
- Tools are no longer able to connect to a stopped instance.
- CPU billing is halted based on full-hour cycles of usage.
- In-flight transactions and queries are stopped.
Correct answer: BCD
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9 Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9
Question 9
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
- Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
Correct answer: AC
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1 Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
Question 10
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
- Two. They are called ATP and ADW.
- None. There are no pre-defined service names in tnsnames.ora.
- Three. They are called high, medium and low.
- Five. They are called tpurgent, tp, high, medium and low.
Correct answer: D
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE Reference: https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
