Oracle Oracle Certifications 1Z0-931-21 Questions & Answers

• Question 61:

  

  Which three are Oracle-recommended best practices for Autonomous Database alarms?

  A. Suppress alarms during investigations.

  B. Create multiple alarm metrics.

  C. Create a single alarm for each metric.

  D. Select the correct alarm interval for your metric.

  E. Routinelytune your alarms.

  F. Use a single interval for all alarms.

  Correct Answer: ADE

• Question 62:

  Which statement is correct about the Service consolein an Autonomous Database?

  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 betweencompartments

  D. You can use Service console to create manual backups of Autonomous database

  Correct Answer: B

• Question 63:

  You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.

  Which service will you need to connect to?

  A. TPURGENT

  B. TP

  C. MEDIUM

  D. LOW

  Correct Answer: A

  tpurgent: The highest priority application connection service for time critical transaction processing operations. This connectionservice supports manual parallelism.

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

• Question 64:

  Which two are correct actions to take in order to Download the Autonomous Database Credentials?

  A. Click on the Autonomous Data Warehouse in the menu,click a database name, then Choose DB Connection button, then Download the Wallet.

  B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.

  C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

  D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

  E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

  Correct Answer: AE

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect- download-wallet.html#GUIDB06202D2-0597-41AA-9481-3B174F75D4B1

• Question 65:

  Which is a difference between Autonomous Data Warehouse (ADW) andAutonomous Transaction Processing (ATP) databases?

  A. Only ATP manages optimizer statistics.

  B. Only ATP supports automatic backups.

  C. Only ADW uses columnar compression by default.

  D. Only ADW supports autoscaling.

  Correct Answer: C

• Question 66:

  Which statement is true when the Autonomous Database has auto scaling enabled?

  A. Database concurrency is scaled up when needed by the workload.

  B. Increases the number of sessions available to the database.

  C. Scales the PGA and SGA size when needed for the workload.

  D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

  Correct Answer: D

• Question 67:

  When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

  A. Under Core Infrastructure then Compute then Autonomous Exadata

  B. Under Solutionsand Platform then Platform Services then Autonomous Exadata

  C. Under Database then Autonomous Transaction Processing then Autonomous Exadata

  D. Under Core Infrastructure then Autonomous Exadata

  Correct Answer: C

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/ adbmanaginginfrastructure.htm#viewmaintenancehistory https://docs.oracle.com/en-us/iaas/Content/ Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.

  Even though the UI has changed recently, this documentation has the user go to Menu-> Database

• Question 68:

  When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

  A. Scan partition tables

  B. scan hybrid partition tables

  C. prun column in parquet files

  D. prun columns in csv files

  Correct Answer: A

• Question 69:

  Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

  A. Current settings for ACLs are cloned.

  B. Clone can be in a different region.

  C. All OML notebooks are cloned.

  D. All underlying data for OML notebooks is cloned.

  E. All resource management rules are cloned.

  Correct Answer: BD

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/autonomous-clone-notes.html#GUIDF943E7FF-8DEB-47F4-84C0- FFA5BAF9D5A9

• Question 70:

  Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

  A. Admin page of the Cloud Service Console

  B. OCI CLI

  C. OS command line from the database server.

  D. SQLDeveloper

  Correct Answer: C