Latest 1Z0-931-24 Pass Guaranteed Exam Dumps with Accurate & Updated Questions
1Z0-931-24 Exam Brain Dumps - Study Notes and Theory
NEW QUESTION # 30
Who, and in which order, provisions dedicated Exadata Infrastructure resources?
- A. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container D Then, the database administrator provisions the Autonomous DB
- B. The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB
- C. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB
- D. The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure
Answer: A
NEW QUESTION # 31
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- B. A clone database source can be a running database instance.
- C. After an Autonomous database is created using a clone, the network access option can be changed.
- D. A clone database source can be from a point-in-time backup that is less than 2 hours old.
Answer: B
Explanation:
NEW QUESTION # 32
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION # 33
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
- A. ORDS_PRIV.ENABLE_SCHEMA
- B. SQLDEV_ADMIN.GRANT_SCHEMA
- C. ORDS_ADMIN.GRANT_SCHEMA
- D. ORDS_ADMIN.ENABLE_SCHEMA
Answer: D
Explanation:
As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA
NEW QUESTION # 34
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
- A. Five. They are called tpurgent, tp, high, medium and low.
- B. None. There are no pre-defined service names in tnsnames.ora.
- C. Three. They are called high, medium and low.
- D. Two. They are called ATP and ADW.
Answer: A
Explanation:
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://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATP
NEW QUESTION # 35
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?
- A. MODIFY_SNAPSHOT_SETTINGS
- B. CREATE_BASELINE_TEMPLATE
- C. UPDATE_OBJECT_INFO
- D. MODIFY_BASELINE_WINDOW_SIZE
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3 The retention time can be changed by modifying the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS. Be aware that increasing the retention time will result in more storage usage for performance data
NEW QUESTION # 36
Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to "None"
- B. You cannot permanently disable scheduled automatic maintenance
- C. Change the Automatic Maintenance Schedule to "No Preference"
- D. Change the Automatic Maintenance Schedule to "Specify a Schedule," but do not select any ^ month, week, or day
Answer: B
NEW QUESTION # 37
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Sessions
- B. Parallelism
- C. Memory
- D. Concurency
- E. Storage
Answer: E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:
NEW QUESTION # 38
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?
- A. Data Pump
- B. Physical migration method like database cloning
- C. RMAN backup & restore
- D. Original Import/Export tools
Answer: A
Explanation:
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, database clones, and transportable tablespaces to move your existing database to ADB.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION
NEW QUESTION # 39
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Amazon S3
- B. Oracle Cloud Infrastructure Object Storage
- C. Google Cloud Storage
- D. Oracle Cloud Infrastructure Object Storage Classic
Answer: C
Explanation:
NEW QUESTION # 40
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 # 41
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 queued.
- B. The SQL statement completed its execution.
- C. The SQL statement is executing.
- D. The SQL statement did not complete either due to an error.
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
NEW QUESTION # 42
Which API is NOT available for developing with spatial on ADB?
- A. Java
- B. Python
- C. PL/SQL Gremlin
- D. REST
Answer: C
Explanation:
PL/SQL Gremlin is not an API for developing with spatial on ADB, but rather an API for developing with property graphs on ADB5.Spatial is a feature of ADB that allows developers and analysts to use spatial analysis in every application from basic spatial search and analysis to advanced geospatial applications and Geographic Information Systems (GIS)6.The APIs available for developing with spatial on ADB are REST, Python, Java, and PL/SQL7.
Oracle Autonomous Database - Oracle Autonomous Database, section "Graph Analytics", subsection "Property Graphs".
Oracle Autonomous Database - Oracle Autonomous Database, section "Spatial".
Oracle Autonomous Database - Oracle Autonomous Database, section "Spatial", subsection "Spatial APIs".
NEW QUESTION # 43
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.
What should they do to remove this bottleneck?
- A. Increase the number of OCPUs allocated to the database.
- B. Remove any non-JSON data from the database.
- C. Ask Support to migrate their setup to a node without noisy neighbors.
- D. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
Answer: A
NEW QUESTION # 44
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?
- A. The migration can be technically a success but the 3-rd party vendor needs to support the result.
- B. The migration can be a success, both technically and functional due to datapump enhancements.
- C. The tablespace names will result in a blocking error during datapump import because of ADB limitations.
- D. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-data-pump.html#GUID-9F6B551A-9DB7-44BE-A8ED-08E300C56DB1
NEW QUESTION # 45
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Exadata
- B. Transparent Data Encryption
- C. RAC, but only when scaling beyond 16 OCPUs
- D. Multitenant
- E. Active Data Guard
Answer: C,D
Explanation:
Refer to https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/ If you run Oracle Database Enterprise Edition and the required options listed below, then your BYOL requirements are as follows:
For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service.
For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Do customers need Exadata licenses to benefit from BYOL?"
NEW QUESTION # 46
......
Pass Oracle 1Z0-931-24 Test Practice Test Questions Exam Dumps: https://www.pass4leader.com/Oracle/1Z0-931-24-exam.html
The Best Oracle Cloud Study Guide for the 1Z0-931-24 Exam: https://drive.google.com/open?id=1tqkZztTVWR8o0-hcAUFRTYIZ6UGpGQbd