Oracle Autonomous Database Cloud 2019 Specialist v1.0 (1z0-931)

Page:    1 / 4   
Total 64 questions

What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)

  • A. Autonomous Databases monitoring for usage and query performance.
  • B. Creating schemas.
  • C. Creating and scaling of Autonomous Database service.
  • D. Wizard to download connection wallet for connection from desktop tools.


Answer : AC

Reference:
https://sqlmaria.com/2019/10/22/how-do-i-scale-an-autonomous-database/

What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?

  • A. SCOTT
  • B. ADMIN
  • C. SYS
  • D. DWDEV


Answer : B

Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-

EC14B465B873 -

What REST verb is used to create an Autonomous Database service using REST APIs?

  • A. A "POST" REST call
  • B. A "PUT" REST call
  • C. An "INSERT" REST call
  • D. A "GET" REST call


Answer : A

Reference:
https://medium.com/@fathi.ria/rest-apis-easily-manage-an-autonomous-database-in-oracle-cloud-b105d29b5c05

Which operating system can Data Visualization Desktop be run on?

  • A. AIX
  • B. Linux
  • C. Windows
  • D. Solaris


Answer : C

Reference:
https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html

Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

  • A. VALIDATE_LEVELS
  • B. VALIDATE_HIERARCHY
  • C. VALIDATE_DIMENSION
  • D. VALIDATE_ANALYTIC_VIEW
  • E. VALIDATE_MEASURES


Answer : BD

Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-
5B8952CEF41D

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

  • A. Backups
  • B. Firmware Patching
  • C. Data Loading
  • D. Database Upgrades
  • E. Application User Creation


Answer : BCD

Reference:
http://www.oracle.com/us/products/database/autonomous-database-self-securing-5116048.pdf
(6)

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA
Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

  • A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
  • B. ADW since operational reporting is a higher priority in this scenario.
  • C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
  • D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.


Answer : A

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. HIGH
  • B. TP
  • C. MEDIUM
  • D. TPURGENT


Answer : D

Reference:
https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

  • A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
  • B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
  • C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
  • D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
  • E. The target table will be created in Autonomous Database if it does not already exist.


Answer : AC

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

  • A. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
  • B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
  • C. Adding, removing, or modifying tablespaces is allowed.
  • D. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.


Answer : B

Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database-users.html#GUID-58EE6599-6DB4-4F8E-
816D-0422377857E5

What are two security features enabled by default by the Autonomous Database? (Choose two.)

  • A. Transparent Data Encryption
  • B. Encrypted Database Links
  • C. SQL Net Encryption
  • D. One SYSDBA account
  • E. Read Only access to OS Audit logs


Answer : AB

Reference:
https://juliandontcheff.wordpress.com/category/cloud/

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

  • A. Original Import/Export tools
  • B. Physical migration method like database cloning
  • C. Data Pump
  • D. RMAN backup & restore


Answer : C

Explanation:
Oracle Data Pump provides very fast bulk data movement between Oracle Databases and Autonomous Data.
Reference:
https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-options-data-pump-sql-loader-dbms_cloud-goldengate/

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

  • A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
  • B. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
  • C. A single fault domain can be associated with multiple regions and availability domains.
  • D. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.


Answer : AB

Explanation:
A region is a localized geographic area, and an availability domain is one or more data centers located within a region.
Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
Reference:
https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htm

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

  • A. through the Oracle Cloud Infrastructure service console
  • B. through SQL/Developer s
  • C. using DBMS_CLOUD_ADMIN package
  • D. through SQLPIus


Answer : AB

Reference:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html

Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?

  • A. TPURGENT
  • B. MEDIUM
  • C. HIGH
  • D. TPPERFORMANT
  • E. LOW


Answer : D

Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

Page:    1 / 4   
Total 64 questions