Updated Apr-2023 Test Engine to Practice 1z0-931-22 Test Questions
1z0-931-22 Real Exam Questions Test Engine Dumps Training With 115 Questions
Oracle 1z0-931-22 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION 60
Which option should you use to create a graph with Graph Studio?
- A. Graph created by a special tool downloaded from oracle.com
- B. A graph license key
- C. Graph analytics algorithms
- D. Tables in an Autonomous Database instance
- E. NoSQL configuration
Answer: D
NEW QUESTION 61
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?
- A. Google Cloud Storage
- B. Amazon S3
- C. Oracle Cloud Infrastructure Object Storage Classic
- D. Azure Blob Storage
- E. Oracle Cloud Infrastructure Object Storage
Answer: C,E
NEW QUESTION 62
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. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
- E. The Autonomous Database must belong to a Network Security Group (NSG).
Answer: A
NEW QUESTION 63
Which native data type is used to store spatial information?
- A. SDO_LOCATION
- B. SDO_RELATE
- C. GEO_JSON
- D. SDO_GEOMETRY
Answer: D
NEW QUESTION 64
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
- A. Use Oracle Zero Downtime Migration (ZDM)
- B. Use GoldenGate
- C. Use Recovery Manager (RMAN)
- D. Use SFTP to copy CSV files into Autonomous Database
- E. Use Data Pump
Answer: A,B,E
Explanation:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
NEW QUESTION 65
Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Backup Retention
If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm
NEW QUESTION 66
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. using DBMS_CLOUD_ADMIN package
- B. through SQL/Developer s
- C. through the Oracle Cloud Infrastructure service console
- D. through SQLPIus
Answer: B,D
Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
"To create users in your database, connect to the database as the ADMIN user using any SQL client tool." https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB
NEW QUESTION 67
Which statement is NOT correct when setting up compartment quotas?
- A. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- B. There are three types of quota policy statements which are set, unset and zero.
- C. Compartment quotas are set by Oracle.
- D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION 68
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Resource Manager settings
- B. Compartment quotas
- C. SQL Developer Web Console
- D. Oracle Machine Learning notebook
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm
NEW QUESTION 69
Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)
- A. Datapump export / import
- B. Golden Gate on-premise installation
- C. Dataguard Physical Standby
- D. Golden Gate Cloud service
- E. PDB unplug / plug operation
- F. RMAN Cross-Platform backup and restore
Answer: A,B,D
Explanation:
Reference:
https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-optionsdata-pump-sql-loader-dbms_cloud-goldengate/
NEW QUESTION 70
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 available to a database depends on the total number of cores available in the Exadata infrastructure instance.
- 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 is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
- D. Auto scaling is enabled by default and can be enabled or disabled at any time.
Answer: B
NEW QUESTION 71
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Analytic View Base Table Query Transformation
- B. Analytic View Transparency View
- C. Autonomous Aggregate Cache
- D. Display private tables
- E. Business Object Security Feature
Answer: A,B,C
Explanation:
NEW QUESTION 72
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. All OML notebooks are cloned.
- B. Clone can be in a different region.
- C. Current settings for ACLs are cloned.
- D. All resource management rules are cloned.
- E. All underlying data for OML notebooks is cloned.
Answer: B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION 73
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
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN
NEW QUESTION 74
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. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
- C. ADW since operational reporting is a higher priority in this scenario.
- D. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
Answer: B
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 75
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Parquet
- B. Avro
- C. Data Pump Export File
- D. JSON
- E. Text
- F. Microsoft SQL Server (.mdf)
Answer: F
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 76
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. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
- C. You can configure Private Endpoints for an Always Free Autonomous Database
- 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,D
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 77
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. It supports NoSQL-style, document-centric application
- B. JSON data is stored natively in the database
- C. There is a 20 GB limit on JSON collection
- D. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
Answer: C
Explanation:
NEW QUESTION 78
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be a running database instance.
- B. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- C. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- D. After an Autonomous database is created using a clone, the network access option can be changed.
Answer: A
Explanation:
NEW QUESTION 79
Which statement is true when the Autonomous Database has auto scaling enabled?
- A. Database concurrency is scaled up when needed by the workload.
- B. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
- C. Increases the number of sessions available to the database.
- D. Scales the PGA and SGA size when needed for the workload.
Answer: B
NEW QUESTION 80
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Multitenant
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Transparent Data Encryption
- D. Active Data Guard
- E. Exadata
Answer: A,B
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 81
In which four ways can Oracle Database optimally access data in Object Storage?
- A. scan avoidance using columnar pruning for .csv files
- B. optimized data archive using hybrid partitioned tables
- C. scan avoidance using block skipping when reading parquet and ore files
- D. scan avoidance using columnar pruning for columnar stores like parquet and orc
- E. optimized data archive using partitioned external tables
- F. scan avoidance using partitioned external tables
Answer: B,D,E,F
NEW QUESTION 82
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- C. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- D. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION 83
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. db-workload
- B. is-dedicated
- C. license-model
- D. db-type
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 84
Which statement is not correct when the Autonomous Database is stopped?
- A. Tools are no longer able to connect to a stopped instance
- B. CPU billing is halted
- C. In-flight transactions queries are stopped
- D. User with DWROLE can still access the database
Answer: D
Explanation:
NEW QUESTION 85
......
1z0-931-22 Actual Questions Answers PDF 100% Cover Real Exam Questions: https://www.examsreviews.com/1z0-931-22-pass4sure-exam-review.html
1z0-931-22 Exam questions and answers: https://drive.google.com/open?id=1dOiGjNuhTuq5vv-_sEFTXnF9kDWzE7PP