[Nov 23, 2023] Lesson Brilliant PDF for the 1z0-931-23 Tests Free Updated Today
Get New 2023 Valid Practice Oracle Cloud 1z0-931-23 Q&A - Testing Engine
NEW QUESTION # 85
Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?
- A. Maximum Protection
- B. Maximum Continuity
- C. Maximum Performance
- D. Maximum Availability
Answer: C,D
NEW QUESTION # 86
What are three methods to load data into the Autonomous Database?
- A. RMAN Restore
- B. Oracle GoldenGate
- C. Oracle Data Pump
- D. SQL*Loader
- E. Transportable Tablespace
Answer: B,C,D
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3
NEW QUESTION # 87
Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?
- A. Data Load
- B. Data Insights
- C. JSON
- D. Catalog
Answer: D
NEW QUESTION # 88
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter user MTHEO quota unlimited on tablespace DATA;
- 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 tablespace DATA set quota = 10G;
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION # 89
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. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- B. ADW since operational reporting is a higher priority in this scenario.
- C. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- 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 # 90
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. Query Latency, User Calls, Execute Count
- B. CPU Utilization, Storage Utilization
- C. Transaction Count, Sessions, Running Statements
- D. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
Answer: D
NEW QUESTION # 91
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?
- A. Delete the user.
- B. Shutdown and restart the instance.
- C. Trust the user who left to not access the database.
- D. Rotate the instance wallet and share the new wallet with the remaining users.
Answer: D
NEW QUESTION # 92
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
- A. inside the Autonomous Database wallet
- B. inside the backups of the container database
- C. In a separate key vault external to the Exadata Infrastructure
- D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
Answer: C
NEW QUESTION # 93
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Data Pump Export File
- B. Parquet
- C. JSON
- D. Microsoft SQL Server (.mdf)
- E. Text
- F. Avro
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/format-options.html#GUID-08C44CDA-7C81-481A-BA0A-F7346473B703
.mdf format is for MS SQL server database file
NEW QUESTION # 94
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?
- A. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
- B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
- C. Oracle Data Safe only supports Autonomous Databases.
- D. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
Answer: C
Explanation:
https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases
− Autonomous Database on Shared Exadata Infrastructure
− Autonomous Database on Dedicated Exadata Infrastructure
− Exadata DB systems
− Database Cloud Service on Virtual Machine
− Database Cloud Service on Bare Metal
− Oracle Database on Compute
NEW QUESTION # 95
Which three options do NOT change when enabling auto scaling?
- A. Level of concurrency
- B. Number of OCPUS displayed in the console
- C. Amount of storage
- D. I/O resources
- E. Parallelism settings
Answer: A,C,E
NEW QUESTION # 96
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. Moving an Autonomous Database instance does not include its automatic backups.
- B. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
- C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
- D. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes
NEW QUESTION # 97
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. TP
- B. MEDIUM
- C. TPURGENT
- D. LOW
Answer: C
Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
NEW QUESTION # 98
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. All resource management rules are cloned.
- B. Clone can be in a different region.
- C. All underlying data for OML notebooks is cloned.
- D. All OML notebooks are cloned.
- E. Current settings for ACLs are cloned.
Answer: B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION # 99
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python?
- A. SQL Developer
- B. The Oracle Client and the cx_Oracle interface for Python
- C. JAVA JDK
- D. You can't use Python with ADB.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53
https://developer.oracle.com/databases/database-for-python-developers-1.html
NEW QUESTION # 100
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- D. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION # 101
Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure?
- A. You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure
- B. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure
- C. You can skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed
- D. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available
Answer: A
NEW QUESTION # 102
Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
- A. 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
- B. Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching
- C. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter
- D. Autonomous Exadata infrastructure maintenance takes place at least once each quarter
Answer: B
NEW QUESTION # 103
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. 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.
- B. Auto scaling is enabled by default and can be enabled or disabled at any time.
- 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. The base number of OCPU cores allocated to a database is not guaranteed.
Answer: D
NEW QUESTION # 104
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
- A. MEDIUM
- B. HIGH
- C. LOW
- D. TPPERFORMANT
- E. TPURGENT
Answer: D
Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION # 105
Which statement is FALSE about setting up compartment quotas?
- A. Quotas set on a parent compartment override quotas set on child compartments.
- B. Compartment quotas cannot be set on the root compartment.
- C. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
- D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
Answer: B
NEW QUESTION # 106
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Undo Management
- B. Memory Usage
- C. Data Organization
- D. Index Storage
- E. Backup Retention
Answer: B,D
NEW QUESTION # 107
Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?
- A. Reports
- B. Schemas
- C. Tablespaces
- D. Data
Answer: B,D
NEW QUESTION # 108
When enabling auto-scaling, which three options do not change?
- A. Level of concurrency
- B. Number of OCPUs displayed in the console.
- C. Amount of storage
- D. I/O resources
- E. parallelism settings
Answer: A,C,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141
NEW QUESTION # 109
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Amazon S3
- B. Oracle Cloud Infrastructure Object Storage
- C. Azure Blob Storage
- D. Oracle Cloud Infrastructure Object Storage Classic
- E. Google Cloud Storage
Answer: B,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 # 110
......
1z0-931-23 Dumps PDF - 100% Passing Guarantee: https://passleader.dumpexams.com/1z0-931-23-vce-torrent.html