• Home
  • Articles
  • ExamcollectionPass 1Z0-931-20 dumps & Oracle Cloud Sure Practice with 118 Questions [Q48-Q68]

ExamcollectionPass 1Z0-931-20 dumps & Oracle Cloud Sure Practice with 118 Questions [Q48-Q68]

Share

ExamcollectionPass  1Z0-931-20 dumps & Oracle Cloud Sure Practice with 118 Questions

New 1Z0-931-20 Exam Questions| Real 1Z0-931-20 Dumps


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 48
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

  • A. Under Solutions and Platform then Platform Services then Autonomous Exadata
  • B. Under Core Infrastructure then Autonomous Exadata
  • C. Under Core Infrastructure then Compute then Autonomous Exadata
  • D. Under Database then Autonomous Transaction Processing then Autonomous Exadata

Answer: C

 

NEW QUESTION 49
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

  • A. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
  • B. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
  • C. Data Pump is faster to migrate database than using RMAN.
  • D. Data Pump creates the tablespaces used by your Autonomous Database.

Answer: A,B

Explanation:
The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.
Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Database .
Data Pump Import lets you import data from Data Pump files residing on Oracle Cloud Infrastructure Object Storage, Microsoft Azure, AWS S3, 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
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/load-data-data-pump.html#GUID-297FE3E6-A823-4F98-AD50-959ED96E6969

 

NEW QUESTION 50
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 HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements
  • B. The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements
  • C. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has
    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 up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each

Answer: C,D

 

NEW QUESTION 51
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.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
  • C. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
  • D. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
  • E. 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.

Answer: A,C,E

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 52
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

  • A. Application User Creation
  • B. Database Upgrades
  • C. Backups
  • D. Data Loading
  • E. Firmware Patching

Answer: B,C,E

Explanation:
- By patching, Oracle patch the full stack-including the firmware, the OS, clusterware, and the database.
- Autonomous Database automatically backs up your database for you
The Oracle Autonomous Database is the integration of the Oracle Database running on the Exadata platform with our complete infrastructure automation and our fully automated data center operations. Automated data sections include provisioning, patching, upgrading, and online backups, monitoring, scaling, diagnosing, performance tuning, optimizing, testing, and change management of complex applications and workloads, and automatically handling failures and errors.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846

 

NEW QUESTION 53
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 = 'DW'
  • 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 = 'OLTP'
  • D. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Answer: C

 

NEW QUESTION 54
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

  • A. Quarterly Bundle Patch (QBP)
  • B. Prior Release Update Revision (PRUR)
  • C. Release Update (RU)
  • D. Prior Release Update (PRU)

Answer: C

 

NEW QUESTION 55
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

  • A. Dlocker
  • B. REST API
  • C. Terraform
  • D. Enterprise Manager

Answer: C

Explanation:
https://blogs.oracle.com/cloud-infrastructure/getting-started-with-the-resource-manager-on-oracle-cloud-infrastructure

 

NEW QUESTION 56
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

  • A. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
  • B. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
  • C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
  • D. You can configure Private Endpoints for an Always Free Autonomous Database

Answer: A,C

 

NEW QUESTION 57
As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

  • A. TPURGENT
  • B. TP
  • C. MEDIUM
  • D. HIGH

Answer: C

Explanation:
Medium is 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) and concurrency is 1.25 X CPU_COUNT QUERIES

 

NEW QUESTION 58
When exporting a notebook, what type of file is created?

  • A. XML
  • B. SQL
  • C. JSON
  • D. TXT
  • E. ASCII

Answer: C

Explanation:
Export a Notebook
You can export a notebook as a .json (JavaScript Object Notation) file, and later import it in to the same or a different environment.
To export a notebook:
- In the Notebooks page, click the notebook that you want to export. The notebook opens in the notebook editor.
- In the top panel of the notebook editor, click export. The notebook is saved to your local folder as a .json file.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks-data-analysis-and-data-visualization.html#GUID-009B9073-4B45-4505-8DAD-F1F04FD3E160

 

NEW QUESTION 59
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 SQLPIus
  • D. through the Oracle Cloud Infrastructure service console

Answer: B,C

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

 

NEW QUESTION 60
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 system set application_continuity=true
  • C. alter database set application_continuity=true
  • D. alter session set application_continuity=true

Answer: B

 

NEW QUESTION 61
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

  • A. Active transactions are paused.
  • B. Active transactions continue running unaffected.
  • C. Active transactions are terminated and rolled back.
  • D. Scaling cannot happen while there are active transactions in the database.

Answer: B

Explanation:
Oracle allows you to scale compute and storage independently, no need to do it together, these scaling activities fully online (no downtime required)

 

NEW QUESTION 62
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. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
  • C. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
  • D. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

Answer: D

 

NEW QUESTION 63
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 SQLPIus
  • D. through the Oracle Cloud Infrastructure service console

Answer: B,C

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

 

NEW QUESTION 64
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 Data Warehouse workloads are optimized for mixed workloads.
  • D. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

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

 

NEW QUESTION 65
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

 

NEW QUESTION 66
What are three methods to load data into the Autonomous Database? (Choose three.)

  • A. SQL*Loader
  • B. Oracle Data Pump
  • C. RMAN Restore
  • D. Transportable Tablespace
  • E. Oracle GoldenGate

Answer: A,B,E

Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3

 

NEW QUESTION 67
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

  • A. SSH keys are not required in Oracle Cloud Infrastructure.
  • B. On the Autonomous Database Console.
  • C. Navigate to Identity, select Users panel on the console and select "Add Public Key".
  • D. SSH keys cannot be added from console. They have to be added using REST APIs only.

Answer: C

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 68
......

1Z0-931-20 Braindumps – 1Z0-931-20 Questions to Get Better Grades: https://www.examcollectionpass.com/Oracle/1Z0-931-20-practice-exam-dumps.html

Related Articles

more
Oracle 1Z0-931-20 Certification Practice Exam