[Sep 26, 2022] Prep4sureGuide 1z0-931-22 dumps & Oracle Autonomous Database sure practice dumps
Oracle 1z0-931-22 Actual Questions and Braindumps
NEW QUESTION 16
Which option should you use to create a graph with Graph Studio?
- A. Tables in an Autonomous Database instance
- B. NoSQL configuration
- C. Graph created by a special tool downloaded from oracle.com
- D. Graph analytics algorithms
- E. A graph license key
Answer: A
NEW QUESTION 17
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. Unplug into a pdb archive which can be uploaded to object storage.
- B. Create a database link from source database to the ADB environment and clone the PDB.
- C. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- D. Unplug to an xml file so database files and xml file can be uploaded to object storage.
Answer: C
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 18
Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)
- A. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
- B. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
- C. Oracle Data Safe only supports Autonomous Databases
- D. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
Answer: C
Explanation:
NEW QUESTION 19
What happened with the standby database when disabling Autonomous Data Guard?
- A. The standby database is terminated
- B. The standby database is started readwrite
- C. The standby database is transformed in a refreshable clone
- D. The standby database is started read only
Answer: A
NEW QUESTION 20
Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?
- A. RMAN
- B. OCI Metrics
- C. Enterprise Manager Cloud Control
- D. Performance Hub
- E. Logs
Answer: B,C,D
NEW QUESTION 21
Which stage of the indexing pipeline divides text into tokens?
- A. LEXER
- B. SECTIONER
- C. Otokenizer
- D. FILTER
Answer: A
NEW QUESTION 22
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
- A. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
- B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
- C. The Autonomous Database must belong to a Network Security Group (NSG).
- D. The marketplace OCI image can be used with an Always Free Autonomous Database account.
- E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
Answer: E
NEW QUESTION 23
You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?
- A. APEX
- B. Business Models
- C. Data Load
- D. SQL Developer Web
Answer: C
Explanation:
NEW QUESTION 24
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
- A. Allow group ADB-Admins to manage autonomous-database in tenancy.
- B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
- C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
- D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION 25
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Concurency
- B. Parallelism
- C. Storage
- D. Memory
- E. Sessions
Answer: C
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 26
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. Shutdown and restart the instance.
- B. Trust the user who left to not access the database.
- C. Rotate the instance wallet and share the new wallet with the remaining users.
- D. Delete the user.
Answer: C
Explanation:
NEW QUESTION 27
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- B. On the Autonomous Database Console.
- C. SSH keys cannot be added from console. They have to be added using REST APIs only.
- D. SSH keys are not required in Oracle Cloud Infrastructure.
Answer: A
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 28
Which statement is not correct when the Autonomous Database is stopped?
- A. CPU billing is halted
- B. In-flight transactions queries are stopped
- C. Tools are no longer able to connect to a stopped instance
- D. User with DWROLE can still access the database
Answer: D
Explanation:
NEW QUESTION 29
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 enable or disable auto scaling of Autonomous DB
- C. You can use Service console to move Autonomous DB between compartments
- D. You can use Service console to manage runaway SQL statements on Autonomous DB
Answer: D
Explanation:
NEW QUESTION 30
Which three of the following data sources are available when using the Data Load page on Database Actions?
- A. Files in AWS S3 Storage
- B. Backup files in block storage
- C. Local Files
- D. REST endpoints
- E. Files in Oracle Cloud Storage
Answer: A,C,E
NEW QUESTION 31
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. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- 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: A
Explanation:
NEW QUESTION 32
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. Ask Support to migrate their setup to a node without noisy neighbors.
- C. Remove any non-JSON data from the database.
- D. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
Answer: B
NEW QUESTION 33
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. 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.
- C. The base number of OCPU cores allocated to a database is not guaranteed.
- D. Auto scaling is enabled by default and can be enabled or disabled at any time.
Answer: C
NEW QUESTION 34
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Data Organization
- B. Backup Retention
- C. Memory Usage
- D. Undo Management
- E. Index Storage
Answer: C,E
NEW QUESTION 35
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 36
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 37
......
Oracle 1z0-931-22 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
Latest 1z0-931-22 Pass Guaranteed Exam Dumps with Accurate & Updated Questions: https://examcollection.prep4sureguide.com/1z0-931-22-prep4sure-exam-guide.html