[Jan-2022] 1Z0-931-20 Exam Dumps, 1Z0-931-20 Practice Test Questions
Attested 1Z0-931-20 Dumps PDF Resource [2022]
Who should take the Oracle 1Z0-931-20: PeopleSoft 9.2 Database cloud Essentials exam
The 1Z0-931-20 exam test is ideal for those technical professionals who want to accelerate their knowledge of database cloud management and implementation. There is no such prerequisite for the 1Z0-931-20 exam. Anyone who has some skillset in database cloud, or has an interest in learning database cloud can prepare for the 1Z0-931-20 exam.
How to book Oracle 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exams
The registration for the 1Z0-931-20 Exam, please follow the steps given below:
- Step 1: Visit the Pearsonvue-Website
- Step 2: Through Pearson VUEâs scheduling platform, you will be able to choose a test center, time, and date
- Step 3: Search for the 1Z0-931-20 exam and purchase the exam by making payment using a credit/debit card
NEW QUESTION 21
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "PUT" REST call
- B. A "GET" REST call
- C. An "INSERT" REST call
- D. A "POST" REST call
Answer: D
Explanation:
Use REST verb POST to create Autonomous Database with REST AP
https://docs.cloud.oracle.com/iaas/api/#/en/database/20160918/AutonomousDatabase/CreateAutonomousDatabase
NEW QUESTION 22
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
- A. MEDIUM
- B. HIGH
- C. TPPERFORMANT
- D. TPURGENT
- E. LOW
Answer: C
Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-
45BB-A7D6-E201DD4107B7
NEW QUESTION 23
What is the correct way to list all files in the default data pump directory?
- A. Log onto ADW server and issue is -al on the command line.
- B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- C. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
- D. By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;
Answer: C
NEW QUESTION 24
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
- A. Tools are no longer able to connect to a stopped instance.
- B. CPU billing is halted based on full-hour cycles of usage.
- C. In-flight transactions and queries are stopped.
- D. User with DWROLE can still access the database.
Answer: A,B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9
NEW QUESTION 25
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
- B. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- E. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
Answer: A,B,D
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION 26
Which three data dictionary views contain information about analytic view objects?
- A. ALL_ANALYTIC_VIEW_PATH
- B. ALL_ANALYTIC_VIEW_LVLGRPS
- C. ALL_ANALYTIC_VIEW_DIM_CLASS
- D. ALL_ANALYTIC_VIEW_KEYS
- E. ALL_ANALYTIC VIEW_ID _ATTRS
https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-FC745EA1-721D-48E3-96D1-B4DE1758AFF8
Answer: B,C,D
NEW QUESTION 27
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: C
NEW QUESTION 28
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
- A. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
- B. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- C. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- D. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- E. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
Answer: D,E
NEW QUESTION 29
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: C
NEW QUESTION 30
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
- A. 7 days
- B. 30 days
- C. 60 days
- D. 90 days
- E. One Year
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backup- manual.html#GUID-D95E5D6A-C470-4A68-9545-CC99D937E7D1
NEW QUESTION 31
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 32
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
- A. Data Redaction
- B. Customer Managed Keys
- C. Audit Vault
- D. Transparent Data Encryption
- E. Database Vault
Answer: B,D,E
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
NEW QUESTION 33
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. Unplug to an xml file so database files and xml file can be uploaded to object storage.
- C. Create a database link from source database to the ADB environment and clone the PDB.
- D. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
Answer: D
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 34
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Index Storage
- B. Memory Usage
- C. Undo Management
- D. Data Organization
- E. Backup Retention
Answer: A,D
NEW QUESTION 35
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
- A. MEDIUM
- B. HIGH
- C. TPPERFORMANT
- D. TPURGENT
- E. LOW
Answer: C
Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 36
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
- A. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
- B. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
- C. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
- D. In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
Answer: D
Explanation:
NEW QUESTION 37
You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application.
Which two are true when deciding the number of sessions for each application? (Choose two.)
- A. The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements
- B. The HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each
- C. The HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements
- D. The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group has 0 SQL statements
- E. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has
0 SQL statements
Answer: D,E
NEW QUESTION 38
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
- A. Parallelism
- B. Sessions
- C. Storage
you can independently scale the number of CPUs in Autonomous Database
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#GENERAL - D. Memory
- E. Concurrency
Answer: C
NEW QUESTION 39
......
Latest 1Z0-931-20 Actual Free Exam Questions Updated 118 Questions: https://www.topexamcollection.com/1Z0-931-20-vce-collection.html
