File Info
| Exam | Oracle Autonomous Database Cloud 2019 Specialist |
| Number | 1z0-931 |
| File Name | Oracle.1z0-931.PassGuide.2019-12-13.36q.tqb |
| Size | 140 KB |
| Posted | Dec 13, 2019 |
| Download | Oracle.1z0-931.PassGuide.2019-12-13.36q.tqb |
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
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 2
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- 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.
- The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- 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 3
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
- Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
- Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
- Data Sync can load your data in parallel in order to speed up the loading process.
- 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)
