Ensure Success With Updated Verified 1z0-931-22 Exam Dumps [2022]
Exam Materials for You to Prepare & Pass 1z0-931-22 Exam.
NEW QUESTION 61
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: B
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 62
Which two statements are true about Data Insights?
- A. Data Insights is an additional priced option.
- B. You can retrieve previously executed Data Insights searches.
- C. You can search for Data Insights against a base table or business model.
- D. Data Insights is available with on-premises deployments of Oracle Database.
Answer: B,C
NEW QUESTION 63
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. JSON data is stored natively in the database
- B. There is a 20 GB limit on JSON collection
- C. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
- D. It supports NoSQL-style, document-centric application
Answer: B
Explanation:
NEW QUESTION 64
Which two of the following statements are correct?
- A. All of the capabilities of ODI Classic are available with ODI Web Edition,
- B. ODI Web Edition is available only on Oracle Linux.
- C. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
- D. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
Answer: B,C
NEW QUESTION 65
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- B. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
- C. Create a notification alert using DBMS_SNMP package
- D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
Answer: A
Explanation:
NEW QUESTION 66
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. 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.
- 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 67
Which statement is correct about the Service console in an Autonomous Database?
- A. You can use Service console to create manual backups of Autonomous database
- B. You can use Service console to manage runaway SQL statements on Autonomous DB
- C. You can use Service console to enable or disable auto scaling of Autonomous DB
- D. You can use Service console to move Autonomous DB between compartments
Answer: B
Explanation:
NEW QUESTION 68
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- B. It cannot be done.
- C. Connecting to the Cloud Infrastructure Command console via SSH wallet.
- D. Using Database Configuration Assistant (DBCA) on the database server.
Answer: A
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 69
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. On the Autonomous Database Console.
- B. SSH keys cannot be added from console. They have to be added using REST APIs only.
- C. SSH keys are not required in Oracle Cloud Infrastructure.
- D. Navigate to Identity, select Users panel on the console and select "Add Public Key".
Answer: D
Explanation:
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.
NEW QUESTION 70
Which statement is not correct when the Autonomous Database is stopped?
- A. CPU billing is halted
- B. User with DWROLE can still access the database
- C. In-flight transactions queries are stopped
- D. Tools are no longer able to connect to a stopped instance
Answer: B
Explanation:
NEW QUESTION 71
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. It is enabled by default.
- B. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- C. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
- D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- E. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
Answer: A
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 72
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure
- A. SQL *Plus
- B. SQL Developer
- C. service console
- D. the DBMS_CLOUD_ADMIN package
Answer: A,B
NEW QUESTION 73
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 the Oracle Cloud Infrastructure service console
- C. through SQLPIus
- D. through SQL/Developer s
Answer: C,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 74
Which stage of the indexing pipeline divides text into tokens?
- A. FILTER
- B. Otokenizer
- C. SECTIONER
- D. LEXER
Answer: D
NEW QUESTION 75
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- B. alter database set application_continuity=true
- C. alter session set application_continuity=true
- D. alter system set application_continuity=true
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( 'databaseid_tpurgent.adb.oraclecloud.com', 'LEVEL1', 600);
NEW QUESTION 76
Which three are use cases for Graph Studio? (Choose three.)
- A. Pattern matching
- B. Facial recognition
- C. Clustering
- D. Churn analysis
- E. 3-D modelling
Answer: A,C,E
Explanation:
NEW QUESTION 77
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Backup Retention
- B. Undo Management
- C. Index Storage
- D. Data Organization
- E. Memory Usage
Answer: C,E
NEW QUESTION 78
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
- A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- B. Create a database link from source database to the ADB environment and clone the PDB.
- C. Unplug into a pdb archive which can be uploaded to object storage.
- D. Unplug to an xml file so database files and xml file can be uploaded to object storage.
Answer: A
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
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, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION 79
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Parallelism
- B. Storage
- C. Sessions
- D. Memory
- E. Concurency
Answer: B
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 80
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 can be used with an Always Free Autonomous Database account.
- C. The Autonomous Database must belong to a Network Security Group (NSG).
- D. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
- E. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
Answer: A
NEW QUESTION 81
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Use a single interval for all alarms.
- B. Create multiple alarm metrics.
- C. Routinely tune your alarms.
- D. Create a single alarm for each metric.
- E. Select the correct alarm interval for your metric.
- F. Suppress alarms during investigations.
Answer: C,E,F
NEW QUESTION 82
......
Updated 1z0-931-22 Certification Exam Sample Questions: https://dumpstorrent.exam4pdf.com/1z0-931-22-dumps-torrent.html
