Best 1z0-931-22 Exam Dumps for the Preparation of Latest Exam Questions
1z0-931-22 Actual Questions 100% Same Braindumps with Actual Exam!
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 |
|
NEW QUESTION 15
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. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
- E. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
Answer: A
NEW QUESTION 16
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?
- A. 7 days
- B. 60 days
- C. 15 days
- D. 120 days
Answer: D
NEW QUESTION 17
Which three are use cases for Graph Studio? (Choose three.)
- A. Clustering
- B. Churn analysis
- C. 3-D modelling
- D. Pattern matching
- E. Facial recognition
Answer: A,C,D
Explanation:
NEW QUESTION 18
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Analytic View Transparency View
- B. Display private tables
- C. Business Object Security Feature
- D. Autonomous Aggregate Cache
- E. Analytic View Base Table Query Transformation
Answer: A,D,E
Explanation:
NEW QUESTION 19
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. through the Oracle Cloud Infrastructure service console
- B. through SQLPIus
- C. using DBMS_CLOUD_ADMIN package
- D. through SQL/Developer s
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 20
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
- A. Select the snapshot of the backup.
- B. Select the backup from which restore needs to be done.
- C. Select the archived redo logs.
- D. Specify the point in time (timestamp) to restore.
- E. Backup and recovery must be done using Recovery Manager(RMAN).
Answer: B,D
Explanation:
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C
NEW QUESTION 21
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure
- A. service console
- B. SQL *Plus
- C. the DBMS_CLOUD_ADMIN package
- D. SQL Developer
Answer: B,D
NEW QUESTION 22
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
- A. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.
- B. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
- C. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
- D. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
Answer: B
NEW QUESTION 23
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: B
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 24
Which four file formats are supported when loading data from Cloud Storage?
- A. AVRO
- B. JSON
- C. Parquet
- D. DDL
- E. Dcsv
- F. DOC
Answer: A,B,C,E
NEW QUESTION 25
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 26
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Amazon S3
- B. Oracle Cloud Infrastructure Object Storage
- C. Google Cloud Storage
- D. Oracle Cloud Infrastructure Object Storage Classic
- E. Azure Blob Storage
Answer: B,D
Explanation:
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data-pump.html#GUID-
025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D
Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK-GUID-37922C56-0412-45CD-B10C-2088A000113F
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
NEW QUESTION 27
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 Classic
- C. Oracle Cloud Infrastructure Object Storage
- D. Google Cloud Storage
Answer: D
Explanation:
NEW QUESTION 28
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- B. Execute alter tablespace DATA set quota = 10G;
- C. Execute alter user MTHEO quota unlimited on tablespace DATA;
- D. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION 29
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Storage
- B. Sessions
- C. Parallelism
- D. Concurency
- E. Memory
Answer: A
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 30
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
- B. You cannot permanently disable scheduled Automatic Maintenance.
- C. Change the Automatic Maintenance Schedule to 'None'd.
- D. Change the Automatic Maintenance Schedule to 'No Preference'.
Answer: B
Explanation:
"If the Autonomous Exadata Infrastructure resource doesn't have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define."
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-scheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E
NEW QUESTION 31
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
- B. Create a notification alert using DBMS_SNMP package
- C. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- D. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
Answer: C
Explanation:
NEW QUESTION 32
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
- A. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
- B. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
- C. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
- D. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm
NEW QUESTION 33
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 SFTP to copy CSV files into Autonomous Database
- C. Use Recovery Manager (RMAN)
- D. Use GoldenGate
- E. Use Data Pump
Answer: A,D,E
Explanation:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
NEW QUESTION 34
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 create, monitor and manage Autonomous Databases.
- C. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
- D. Fleet Administrators are responsible for patching and backups of all container 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 35
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 Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
- C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
- D. Autonomous Data Warehouse workloads are optimized for mixed workloads.
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 36
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. An "INSERT" REST call
- B. A "POST" REST call
- C. A "PUT" REST call
- D. A "GET" REST call
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html
NEW QUESTION 37
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
- B. Users can customize the OS stack and add additional packages
- C. Users have OS access to the database machine.
- D. Users can customize the maintenance schedule.
- E. Users have SYS privileges in the database.
Answer: A,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION 38
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
- A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
- B. Allow group ADB-Admins to manage autonomous-database in tenancy.
- C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
- D. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION 39
......
1z0-931-22 Study Material, Preparation Guide and PDF Download: https://www.test4sure.com/1z0-931-22-pass4sure-vce.html
Free 1z0-931-22 Certification Sample Questions with Online Practice Test: https://drive.google.com/open?id=1zfiqVFWjk_NIfPllq2xLczz4j5RwaCCH