Best Preparations of 1z0-931-22 Exam 2023 Oracle Autonomous Database Unlimited 115 Questions
Focus on 1z0-931-22 All-in-One Exam Guide For Quick Preparation.
NEW QUESTION # 16
Which two statements are true about accessing Autonomous Database Tools?
- A. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.
- B. Oracle APEX can be accessed only from the Developer menu in the Service Console.
- C. SQL Developer Web is available exclusively on the Autonomous Database.
- D. Access to Database Actions is available for all users of Autonomous Database.
- E. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
Answer: A,B
NEW QUESTION # 17
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. It cannot be done.
- B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- C. Using Database Configuration Assistant (DBCA) on the database server.
- D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
Answer: B
Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md
NEW QUESTION # 18
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure
- A. SQL Developer
- B. service console
- C. SQL *Plus
- D. the DBMS_CLOUD_ADMIN package
Answer: A,C
NEW QUESTION # 19
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)?
- A. Unplug into a pdb archive which can be uploaded to object storage.
- B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
- D. Create a database link from source database to the ADB environment and clone the PDB.
Answer: B
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION # 20
Which statement is FALSE about Oracle Data Safe?
- A. It helps you assess the security of your cloud database configurations by analyzing database configurations.
- B. It evaluates user types, how users are authenticated, and the password policies assigned to each user.
- C. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.
- D. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- E. It supports only Autonomous Databases.
Answer: C
NEW QUESTION # 21
Which statement is correct about the Service console in an Autonomous Database?
- A. You can use Service console to create manual backups of Autonomous database
- B. You can use Service console to move Autonomous DB between compartments
- C. You can use Service console to manage runaway SQL statements on Autonomous DB
- D. You can use Service console to enable or disable auto scaling of Autonomous DB
Answer: C
Explanation:
NEW QUESTION # 22
Which option should you use to create a graph with Graph Studio?
- A. NoSQL configuration
- B. Graph created by a special tool downloaded from oracle.com
- C. A graph license key
- D. Tables in an Autonomous Database instance
- E. Graph analytics algorithms
Answer: D
NEW QUESTION # 23
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
- A. is-dedicated
- B. license-model
- C. db-workload
- D. db-type
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION # 24
When enabling auto-scaling, which three options do not change?
- A. Amount of storage
- B. Number of OCPUs displayed in the console.
- C. Level of concurrency
- D. parallelism settings
- E. I/O resources
Answer: A,C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141
NEW QUESTION # 25
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Autonomous Transaction Processing
- B. Autonomous Data Warehouse
- C. Both services ignore hints by default
- D. Neither service ignores hints by default
Answer: B
Explanation:
NEW QUESTION # 26
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_MEDIUM
- B. DBNAME_LOW
- C. DBNAME_HIGH
- D. DBNAME_CONCURRENT
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION # 27
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?
- A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
- B. A Private Endpoint is required to connect to the Shared-Autonomous Database.
- C. The OCI compute instance can be used with an Always-Free Autonomous Database account.
- D. The OCI compute instance does not support connecting to a Shared Autonomous Database.
- E. The Autonomous Database must belong to a Network Security Group (NSG).
Answer: C
NEW QUESTION # 28
What happened with the standby database when disabling Autonomous Data Guard?
- A. The standby database is started read only
- B. The standby database is terminated
- C. The standby database is transformed in a refreshable clone
- D. The standby database is started readwrite
Answer: B
NEW QUESTION # 29
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: E
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION # 30
Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?
- A. OCI Metrics
- B. RMAN
- C. Logs
- D. Enterprise Manager Cloud Control
- E. Performance Hub
Answer: A,D,E
NEW QUESTION # 31
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. All OML notebooks are cloned.
- B. All underlying data for OML notebooks is cloned.
- C. All resource management rules are cloned.
- D. Current settings for ACLs are cloned.
- E. Clone can be in a different region.
Answer: B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION # 32
Which statement is NOT correct when setting up compartment quotas?
- A. There are three types of quota policy statements which are set, unset and zero.
- B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- D. Compartment quotas are set by Oracle.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION # 33
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?
- A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
- B. Create an IDCS user. Create a database user with connect, resource, and object privileges.
- C. Create a database user with the default privileges.
- D. Create a database user with connect, resource, and object privileges.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586
NEW QUESTION # 34
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN
NEW QUESTION # 35
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Routinely tune your alarms.
- B. Create a single alarm for each metric.
- C. Create multiple alarm metrics.
- D. Suppress alarms during investigations.
- E. Use a single interval for all alarms.
- F. Select the correct alarm interval for your metric.
Answer: A,D,F
NEW QUESTION # 36
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- B. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- C. 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.
- D. 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.
- E. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
Answer: C,D,E
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This 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.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This 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 Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION # 37
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- B. Fleet Administrators are responsible for patching and backups of all container databases.
- C. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
- D. Fleet Administrators create, monitor and manage Autonomous Databases.
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html
NEW QUESTION # 38
Which statement is correct about managing and monitoring of 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 create manual backups of Autonomous database.
- D. You can use Service console to move Autonomous DB between compartments.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706
NEW QUESTION # 39
......
Guaranteed Success with 1z0-931-22 Dumps: https://www.examsreviews.com/1z0-931-22-pass4sure-exam-review.html
Pass Oracle 1z0-931-22 Exam – Experts Are Here To Help You: https://drive.google.com/open?id=1dOiGjNuhTuq5vv-_sEFTXnF9kDWzE7PP