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

Page:    1 / 4   
Total 60 questions

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? (Choose the best answer.)

  • A. Prior Release Update Revision (PRUR)
  • B. Prior Release Update (PRU)
  • C. Release Update (RU)
  • D. Quarterly Bundle Patch (QBP)


Answer : C

When enabling auto-scaling, which three options do not change? (Choose three.)

  • A. Number of OCPUs displayed in the console.
  • B. Amount of storage
  • C. parallelism settings
  • D. I/O resources
  • E. Level of concurrency


Answer : ACE

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? (Choose the best answer.)

  • A. Microsoft SQL Server (.mdf)
  • B. Avro
  • C. Parquet
  • D. JSON
  • E. Text
  • F. Data Pump Export File


Answer : E

Autonomous Databaseג€™s auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature? (Choose the best answer.)

  • A. The base number of OCPU cores allocated to a database is not guaranteed.
  • B. Auto scaling is enabled by default and can be enabled or disabled at any time.
  • C. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that arenג€™t being used by other auto scaling databases to meet high-load demands.
  • D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.


Answer : A

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? (Choose the best answer.)

  • A. It cannot be done.
  • B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
  • C. Connecting to the Cloud Infrastructure Command console via SSH wallet.
  • D. Using Database Configuration Assistant (DBCA) on the database server.


Answer : B

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? (Choose the best answer.)

  • A. Oracle Machine Learning notebook
  • B. Compartment quotas
  • C. SQL Developer Web Console
  • D. Resource Manager settings


Answer : B

Reference:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm

Which three security features are available in Oracle Autonomous Database Shared Infrastructure? (Choose three.)

  • A. Data Redaction
  • B. Database Vault
  • C. Audit Vault
  • D. Customer Managed Keys
  • E. Transparent Data Encryption


Answer : BDE

Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3

A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python? (Choose the best answer.)

  • A. The Oracle Client and the cx_Oracle interface for Python
  • B. You canג€™t use Python with ADB
  • C. SQL Developer
  • D. JAVA JDK


Answer : A

Reference:
https://developer.oracle.com/databases/database-for-python-developers-1.html

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this? (Choose the best answer.)

  • A. Change the Automatic Maintenance Schedule to ג€˜Specify a Scheduleג€™ but do not select any month, week or day.
  • B. You cannot permanently disable scheduled Automatic Maintenance.
  • C. Change the Automatic Maintenance Schedule to ג€˜No Preferenceג€™.
  • D. Change the Automatic Maintenance Schedule to ג€˜Noneג€™.


Answer : C

Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-schedule-acd.html#GUID-CA028A37-5510-473E-B4D0-

A5D454B8DA6E -

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)? (Choose the best answer.)

  • A. Unplug into a pdb archive which can be uploaded to object storage.
  • B. Create a database link from source database to the ADB environment and clone the PDB.
  • C. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
  • D. Unplug to an xml file so database files and xml file can be uploaded to object storage.


Answer : C

Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure? (Choose the best answer.)

  • A. OS command line from the database server.
  • B. OCI CLI
  • C. Admin page of the Cloud Service Console
  • D. SQLDeveloper


Answer : A

Which statement is correct about managing and monitoring of Autonomous Database? (Choose the best answer.)

  • A. You can use Service console to enable or disable auto scaling of Autonomous DB.
  • B. You can use Service console to manage runaway SQL statements on Autonomous DB.
  • C. You can use Service console to move Autonomous DB between compartments.
  • D. You can use Service console to create manual backups of Autonomous database.


Answer : D

Reference:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbbackingup.htm

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? (Choose the best answer.)

  • A. 2700
  • B. 1500
  • C. 900
  • D. 1800


Answer : A

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? (Choose two.)

  • A. Schemas
  • B. Tablespaces
  • C. Reports
  • D. Data


Answer : AD

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? (Choose the best answer.)

  • A. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
  • B. Moving an Autonomous Database instance does not include its automatic backups.
  • C. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non- dependent) resources remain in their current compartments.
  • D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.


Answer : C

Page:    1 / 4   
Total 60 questions