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

• Question 31:

  

  Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

  A. Data Pump Export File

  B. Avro

  C. Parquet

  D. Text

  E. JSON

  F. Microsoft SQL Server (.mdf)

  Correct Answer: F

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/format- options.html#GUID08C44CDA-7C81-481A-BA0A-F7346473B703

  mdf format is for MS SQL server database file

• Question 32:

  Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

  A. Use SFTP to copy CSV files into Autonomous Database

  B. Use Oracle Zero Downtime Migration (ZDM)

  C. Use Recovery Manager (RMAN)

  D. Use GoldenGate

  E. Use Data Pump

  Correct Answer: BDE

  https://www.oracle.com/sa/database/technologies/cloud-migration.html

  

• Question 33:

  For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

  A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = `DW'

  B. Allow group ADB-Admins to manage autonomous-database in tenancy.

  C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

  D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

  Correct Answer: C

  https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm

• Question 34:

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

  A. Oracle Machine Learning notebook

  B. Compartment quotas

  C. Resource Manager settings

  D. SQL Developer Web Console

  Correct Answer: B

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

  

• Question 35:

  What happened with the standby database when disabling Autonomous Data Guard?

  A. The standby database is started readwrite

  B. The standby database is transformed in a refreshable clone

  C. The standby database is terminated

  D. Thestandby database is started read only

  Correct Answer: C

• Question 36:

  Youhave 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?

  A. 900

  B. 1800

  C. 2700

  D. 1500

  Correct Answer: C

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/manage-priorities.html#GUID6E4DCD27-CDAA-432D-A90B- 485C19EF72B0 It's 300x the number of OCPUs for TPURGEN

  

• Question 37:

  Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

  A. RMAN

  B. Logs

  C. OCI Metrics

  D. Performance Hub

  E. Enterprise Manager Cloud Control

  Correct Answer: CDE

• Question 38:

  Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

  A. RMAN Cross-Platform backup and restore

  B. Golden Gate on-premise installation

  C. PDB unplug / plug operation

  D. Datapump export / import

  E. Dataguard Physical Standby

  F. Golden Gate Cloud service

  Correct Answer: BDF

  https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud- optionsdatapump-sql-loader-dbms_cloud-goldengate/

• Question 39:

  Whichstatement is FALSE about Oracle Data Safe?

  A. It supports only Autonomous Databases.

  B. It helps you assess the security of your cloud database configurations by analyzing database configurations.

  C. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.

  D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.

  E. It helps you evaluate risks to data, assess user security, monitor useractivity, and address data security compliance requirements.

  Correct Answer: E

• Question 40:

  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 onthe 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.

  Correct Answer: D

  Autonomous Transaction Processing provides all of theperformance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.

  As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.