Updated Jan-2022 100% Cover Real 1Z0-931-21 Exam Questions - 100% Pass Guarantee
Use Real Oracle Dumps - 100% Free 1Z0-931-21 Exam Dumps
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION 16
In Graph Studio which you can use to create a graph?
- A. Tables in an Autonomous Database instance
- B. Graph analytics algorithms
- C. A graph license key
- D. Graph created by a special tool downloaded from Oracle.com
- E. NoSQL configuration
Answer: A
Explanation:
NEW QUESTION 17
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
- A. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
- B. You can configure Private Endpoints for an Always Free Autonomous Database
- C. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
- D. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
Answer: A,C
NEW QUESTION 18
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
- A. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.
- B. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
- C. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
- D. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
Answer: A
Explanation:
Exadata infrastructure maintenance takes place at least once each quarter and is mandatory.
If a scheduled container database maintenance run cannot take place (because of changes made to infrastructure maintenance scheduling or other reasons) , Oracle will automatically reschedule the container database maintenance for the following quarter.
You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
Exadata infrastructure maintenance patches the Exadata infrastructure (including patching of the Exadata grid infrastructure code and operating systems updates), and DO NOT include database patching.
NEW QUESTION 19
What happened with the standby database when disabling Autonomous Data Guard?
- A. The standby database is started read only
- B. The standby database is started readwrite
- C. The standby database is terminated
- D. The standby database is transformed in a refreshable clone
Answer: C
NEW QUESTION 20
Which statement is correct about the Service console in an Autonomous Database?
- A. You can use Service console to manage runaway SQL statements on Autonomous DB
- B. You can use Service console to enable or disable auto scaling of 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: A
Explanation:
NEW QUESTION 21
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
- A. Select the backup from which restore needs to be done.
- B. Select the snapshot of the backup.
- C. Select the archived redo logs.
- D. Specify the point in time (timestamp) to restore.
- E. Backup and recovery must be done using Recovery Manager(RMAN).
Answer: A,D
Explanation:
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C
NEW QUESTION 22
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: D
Explanation:
Autonomous Transaction Processing provides all of the performance 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.
NEW QUESTION 23
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter tablespace DATA set quota = 10G;
- B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter user MTHEO quota unlimited on tablespace DATA;
Answer: A
NEW QUESTION 24
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?
- A. the Client Credentials wallet which is used to connect to the Autonomous Database
- B. the Listener endpoint where the Autonomous Database should register on
- C. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
- D. the 'High Availability Container Database' in which the Autonomous instance should run
- E. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
Answer: A
NEW QUESTION 25
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
- A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
- B. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
- C. You can configure Private Endpoints for an Always Free Autonomous Database
- D. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
Answer: A,B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/network-private-endpoint-change.html#GUID-9F76DD5E-85A3-4F5E-A88D-3D4D131FC2CA Enabling a private endpoint for an Autonomous Database ensures that the only access path to the database is via a VCN inside your Oracle Cloud Infrastructure tenancy. This network configuration completely blocks access to the database from public endpoints
NEW QUESTION 26
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Data Organization
- B. Undo Management
- C. Backup Retention
- D. Index Storage
- E. Memory Usage
Answer: D,E
NEW QUESTION 27
When enabling auto-scaling, which three options do not change?
- A. Level of concurrency
- B. I/O resources
- C. Number of OCPUs displayed in the console.
- D. Amount of storage
- E. parallelism settings
Answer: A,E
NEW QUESTION 28
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. Using Database Configuration Assistant (DBCA) on the database server.
- B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- C. It cannot be done.
- 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 29
Which statement is NOT correct when setting up compartment quotas?
- A. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- B. There are three types of quota policy statements which are set, unset and zero.
- C. Compartment quotas are set by Oracle.
- D. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
Answer: D
NEW QUESTION 30
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Azure Blob Storage
- B. Amazon S3
- C. Oracle Cloud Infrastructure Object Storage Classic
- D. Oracle Cloud Infrastructure Object Storage
- E. Google Cloud Storage
Answer: C,D
Explanation:
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data-pump.html#GUID-
025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D
Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK-GUID-37922C56-0412-45CD-B10C-2088A000113F
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
NEW QUESTION 31
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?
- A. The SQL statement is executing.
- B. The SQL statement completed its execution.
- C. The SQL statement did not complete either due to an error.
- D. The SQL statement is queued.
Answer: D
NEW QUESTION 32
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet Administrators are responsible for patching and backups of all container databases.
- B. Fleet Administrators create, monitor and manage Autonomous Databases.
- C. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- D. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
Answer: D
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 33
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- C. Execute alter user MTHEO quota unlimited on tablespace DATA;
- D. Execute alter tablespace DATA set quota = 10G;
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION 34
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?
- A. The SQL statement is executing.
- B. The SQL statement completed its execution.
- C. The SQL statement did not complete either due to an error.
- D. The SQL statement is queued.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
NEW QUESTION 35
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Compartment quotas
- B. Oracle Machine Learning notebook
- C. SQL Developer Web Console
- D. Resource Manager settings
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm
NEW QUESTION 36
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. license-model
- B. db-workload
- C. is-dedicated
- D. db-type
Answer: C
NEW QUESTION 37
Which three are use cases for Graph Studio? (Choose three.)
- A. 3-D modelling
- B. Clustering
- C. Pattern matching
- D. Churn analysis
- E. Facial recognition
Answer: A,B,C
Explanation:
NEW QUESTION 38
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
- A. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
- B. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
- C. Autonomous Data Warehouse workloads are optimized for mixed workloads.
- D. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
Answer: A
Explanation:
- Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud infrastructure.
The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload.
* If it is ADW, then we store data in columnar format because that's the best format for analytics processing.
* If it is ATP, then we store the data in row format because that's the best format for fast single row lookups.
- Oracle Autonomous Database is offered in two workload-optimized flavors
* Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads
* Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-4147-9606-0413D9CC1589
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-4147-9606-0413D9CC1589
NEW QUESTION 39
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. All underlying data for OML notebooks is cloned.
- B. All OML notebooks are cloned.
- C. Current settings for ACLs are cloned.
- D. Clone can be in a different region.
- E. All resource management rules are cloned.
Answer: A,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION 40
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users can customize the OS stack and add additional packages
- B. Users can customize the maintenance schedule.
- C. Users have OS access to the database machine.
- D. Users have SYS privileges in the database.
- E. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
Answer: B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION 41
......
1Z0-931-21 Dumps PDF - 1Z0-931-21 Real Exam Questions Answers: https://www.test4cram.com/1Z0-931-21_real-exam-dumps.html