Verified 1Z0-931-21 Dumps Q&As - 1Z0-931-21 Test Engine with Correct Answers
Pass Your 1Z0-931-21 Dumps as PDF Updated on 2022 With 114 Questions
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION 60
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 from a point-in-time backup that is less than 2 hours old.
- C. A clone database source can be a running database instance.
- D. After an Autonomous database is created using a clone, the network access option can be changed.
Answer: C
Explanation:
NEW QUESTION 61
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 Data Warehouse workloads are optimized for mixed workloads.
- C. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
- D. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
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 62
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
- A. prun columns in csv files
- B. Scan partition tables
- C. scan hybrid partition tables
- D. prun column in parquet files
Answer: B
NEW QUESTION 63
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. ATP and ADW
- B. Autonomous Data Warehouse only
- C. Autonomous Transaction Processing only
- D. Hybrid Columnar compression
Answer: A
Explanation:
NEW QUESTION 64
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Oracle Machine Learning notebook
- B. Resource Manager settings
- C. SQL Developer Web Console
- D. Compartment quotas
Answer: B
NEW QUESTION 65
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. is-dedicated
- C. db-type
- D. db-workload
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 66
Which stage of the indexing pipeline divides text into tokens?
- A. Otokenizer
- B. SECTIONER
- C. LEXER
- D. FILTER
Answer: C
NEW QUESTION 67
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. JSON
- B. Parquet
- C. Data Pump Export File
- D. Avro
- E. Microsoft SQL Server (.mdf)
- F. Text
Answer: E
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 68
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 a database user with the default privileges.
- C. Create a database user with connect, resource, and object privileges.
- D. Create an IDCS user. 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 69
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- 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. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
Answer: D
NEW QUESTION 70
Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?
- A. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.
- B. ACLs can only be used with private endpoints.
- C. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.
- D. When you restore a database, the existing ACLs are not overwritten by the restore.
Answer: D
NEW QUESTION 71
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. MEDIUM
- B. LOW
- C. TPURGENT
- D. TP
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 72
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. Rotate the instance wallet and share the new wallet with the remaining users.
- B. Delete the user.
- C. Shutdown and restart the instance.
- D. Trust the user who left to not access the database.
Answer: A
Explanation:
NEW QUESTION 73
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?
- A. Only ATP manages optimizer statistics.
- B. Only ADW supports autoscaling.
- C. Only ADW uses columnar compression by default.
- D. Only ATP supports automatic backups.
Answer: C
NEW QUESTION 74
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. JSON
- B. Parquet
- C. Data Pump Export File
- D. Microsoft SQL Server (.mdf)
- E. Text
- F. Avro
Answer: F
NEW QUESTION 75
Which three event types are supported for Autonomous Database?
- A. Change Compartment Begin
- B. Change Autoscaling Configuration Compartment
- C. Update IORM Begin
- D. Maintenance Begin
- E. Terminate End
Answer: A,D,E
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm
NEW QUESTION 76
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
- B. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- C. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- D. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
- E. It is enabled by default.
Answer: E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-index.html#GUID-D51A4F85-3AE5-4B7D-9B27-32CEDE8DBD79 - Auto Indexing is disabled by default in Autonomous Database
NEW QUESTION 77
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Transparent Data Encryption
- B. Multitenant
- C. Active Data Guard
- D. RAC, but only when scaling beyond 16 OCPUs
- E. Exadata
Answer: C,D
NEW QUESTION 78
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. OS command line from the database server.
- B. SQLDeveloper
- C. Admin page of the Cloud Service Console
- D. OCI CLI
Answer: D
NEW QUESTION 79
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 80
What are three methods to load data into the Autonomous Database?
- A. Oracle Data Pump
- B. SQL*Loader
- C. Oracle GoldenGate
- D. Transportable Tablespace
- E. RMAN Restore
Answer: A,B,C
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 81
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. You can't use Python with ADB.
- B. JAVA JDK
- C. SQL Developer
- D. The Oracle Client and the cx_Oracle interface for Python
Answer: B
NEW QUESTION 82
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: D
NEW QUESTION 83
......
Pass Oracle 1Z0-931-21 Exam Info and Free Practice Test: https://www.actual4exams.com/1Z0-931-21-valid-dump.html
Oracle 1Z0-931-21 Real Exam Questions and Answers FREE: https://drive.google.com/open?id=1a7tDEP8g0YV9mLLoFjkGj7vT2WwI28EO