Oracle 1z0-931-23 Certification All-in-One Exam Guide Nov-2023
Get Real 1z0-931-23 Exam Dumps [Nov-2023] Practice Tests
NEW QUESTION # 37
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
- B. Change the Automatic Maintenance Schedule to 'None'd.
- C. Change the Automatic Maintenance Schedule to 'No Preference'.
- D. You cannot permanently disable scheduled Automatic Maintenance.
Answer: D
Explanation:
"If the Autonomous Exadata Infrastructure resource doesn't have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define."
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-scheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E
NEW QUESTION # 38
Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?
- A. Maximum Availability
- B. Maximum Performance
- C. Maximum Protection
- D. Maximum Continuity
Answer: A,B
NEW QUESTION # 39
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Autonomous Data Warehouse
- B. Autonomous Transaction Processing
- C. Both services ignore hints by default
- D. Neither service ignores hints by default
Answer: A
Explanation:
NEW QUESTION # 40
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?
- A. Auto scaling is enabled by default and can be enabled or disabled at any time.
- B. The base number of OCPU cores allocated to a database is not guaranteed.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION # 41
When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?
- A. They become invalid
- B. They are also rotated
- C. They continue to work
- D. They revert to pending
Answer: C
NEW QUESTION # 42
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Data
- B. Reports
- C. Tablespaces
- D. Schemas
Answer: A,D
Explanation:
When using Data Pump to migrate your Oracle database to Autonomous Database, you can import data and schemas from Data Pump files. You cannot import tablespaces or reports. See Export Your Existing Oracle Database to Import into Autonomous Database for more details.
NEW QUESTION # 43
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
- A. Database Vault
- B. Audit Vault
- C. Transparent Data Encryption
- D. Data Redaction
- E. Customer Managed Keys
Answer: A,C,E
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
NEW QUESTION # 44
Which statement is true when the Autonomous Database has auto scaling enabled?
- A. Increases the number of sessions available to the database.
- B. Scales the PGA and SGA size when needed for the workload.
- C. Database concurrency is scaled up when needed by the workload.
- D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
Answer: D
NEW QUESTION # 45
Which option should you use to create a graph with Graph Studio?
- A. Graph created by a special tool downloaded from oracle.com
- B. Graph analytics algorithms
- C. NoSQL configuration
- D. A graph license key
- E. Tables in an Autonomous Database instance
Answer: E
NEW QUESTION # 46
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, and object privileges.
- B. Create a database user with the default privileges.
- C. 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.
- D. Create an IDCS user. Create a database user with connect, resource, and object privileges.
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586 To enable a user to access SQL Developer Web, you need to create a database user with the appropriate privileges, enable the schema for SQL Developer Web, and provide the user with the modified URL that includes the schema name. See Enabling Users to Access SQL Developer Web for more details.
NEW QUESTION # 47
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- C. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- D. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION # 48
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 Core Infrastructure then Autonomous Exadata
- C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- D. Under Solutions and Platform then Platform Services then Autonomous Exadata
Answer: C
Explanation:
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
NEW QUESTION # 49
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
- B. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- C. Fleet Administrators create, monitor and manage Autonomous Databases.
- D. Fleet Administrators are responsible for patching and backups of all container databases.
Answer: A
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 # 50
Which two options are available to restore an Oracle Autonomous Database?
- A. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
- B. Select the backup from which restore needs to be done.
- C. Select the snapshot of the backup.
- D. Specify the point in time (timestamp) to restore.
- E. Specify the archived custom image.
Answer: B,D
NEW QUESTION # 51
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
- A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
- B. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
- C. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
- D. Autonomous Data Warehouse workloads are optimized for mixed workloads.
Answer: C
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 # 52
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. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- C. Compartment quotas are set by Oracle.
- D. There are three types of quota policy statements which are set, unset and zero.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION # 53
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
- A. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
- B. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
- C. The marketplace OCI image can be used with an Always Free Autonomous Database account.
- D. The Autonomous Database must belong to a Network Security Group (NSG).
- E. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
Answer: A
NEW QUESTION # 54
......
Last 1z0-931-23 practice test reviews: Practice Test Oracle dumps: https://www.examcollectionpass.com/Oracle/1z0-931-23-practice-exam-dumps.html
Try 1z0-931-23 Free Now! Real Exam Question Answers: https://drive.google.com/open?id=1fxfi2Qt0l9i0CTX407T1O1djhb-aMkIL