Get New 2021 Valid Practice To your 1Z0-931-20 Exam (Updated 118 Questions)

Oracle Cloud 1Z0-931-20 Exam Practice Test Questions Dumps Bundle!

NEW QUESTION 52
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

• A. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
• B. 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.
• C. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
• D. 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.

Answer: D

 

NEW QUESTION 53
What two methods can you use to define Machine Learning Users? (Choose two.)

• A. Use DBMS_CLOUD_ADMIN package
• B. Client tools
• C. Oracle Cloud Infrastructure Console
• D. SQL/Developer

Answer: B,D

Explanation:
Initially, the Role field shows the role None for existing database users. After adding a user the role Developer is assigned to the user.
Use SQL Dev or Client tools
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-oml.html#GUID-D928B760-513A-4C6D-9EB7-DF992249A26D

 

NEW QUESTION 54
On what infrastructure does the Autonomous Database run on?

• A. Bare-metal on Oracle Cloud Infrastructure
• B. VM on Oracle Cloud Infrastructure
• C. Any Oracle Engineered system
• D. Exadata on Oracle Cloud Infrastructure

Answer: B

 

NEW QUESTION 55
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 Database then Autonomous Transaction Processing then Autonomous Exadata
• C. Under Core Infrastructure then Autonomous Exadata
• D. Under Core Infrastructure then Compute then Autonomous Exadata

Answer: D

 

NEW QUESTION 56
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

• A. Parallelism
• B. Sessions
• C. Storage
• D. Concurency
• E. Memory

Answer: C

 

NEW QUESTION 57
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?

• A. DWDEV
• B. SYS
• C. SCOTT
• D. ADMIN

Answer: D

Explanation:
Administrator account in Autonomous Database is ADMIN
ADMIN is the only user which is created when an Autonomous Database (ADB) instance is created and which has all other privileges to manage the Autonomous Database

 

NEW QUESTION 58
Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

• A. 17.4 onwards
• B. 18.1 onwards
• C. Any version
• D. 12c Release 2 onwards

Answer: D

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-preparing.html#GUID-EFAFA00E-54CC-47C7-8C71-E7868279EF3B

 

NEW QUESTION 59
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

• A. MODIFY_SNAPSHOT_SETTINGS
• B. CREATE_BASELINE_TEMPLATE
• C. UPDATE_OBJECT_INFO
• D. MODIFY_BASELINE_WINDOW_SIZE

Answer: A

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3 The retention time can be changed by modifying the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS. Be aware that increasing the retention time will result in more storage usage for performance data

 

NEW QUESTION 60
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 61
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

• A. The SQL statement completed its execution.
• B. The SQL statement did not complete either due to an error.
• C. The SQL statement is executing.
• D. The SQL statement is queued.

Answer: D

 

NEW QUESTION 62
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 63
Which statement is correct about the version of Java that is recommended for use with tools that use Java Database Connectivity (JDBC) connections?

• A. Java Development Kit Version 7
• B. JDBC drivers do NOT support multiple Java Developer Kit versions.
• C. JDBC .Jar files are specific to each platform.
• D. Java Development Kit Version 8 or higher
• E. It doesn't matter, but you must Install the JCE Unlimited Strength Policy Files.

Answer: C

 

NEW QUESTION 64
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

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

Answer: A,B,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 65
Which of these database features is NOT part of the Autonomous Database?

• A. Online Indexing
• B. Flashback Database
• C. Java in the Database
• D. Real Application Clusters (RAC)

Answer: C

Explanation:
List of Restricted and Removed Oracle Features
Lists the Oracle Database features that are not available in Autonomous Database. Additionally, database features designed for administration are not available.
List of Removed Oracle Features
Oracle Real Application Testing
Oracle Database Vault
Database Resident Connection Pooling (DRCP)
Oracle OLAP
Oracle R capabilities of Oracle Advanced Analytics
Oracle Industry Data Models
Oracle Tuning Pack
Oracle Database Lifecycle Management Pack
Oracle Data Masking and Subsetting Pack
Oracle Cloud Management Pack for Oracle Database
Oracle Multimedia
Java in DB
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/experienced-database-users.html#GUID-B6FB5EFC-4828-43F4-BA63-72DA74FFDB87
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database-users.html#GUID-5CF411BF-69E3-43C1-9379-25257A88A354

 

NEW QUESTION 66
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

• A. You have direct access to the database node.
• B. Oracle Database Result Cache is enabled by default for all SQL statements.
• C. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
• D. Parallelism is not enabled by default.

Answer: C,D

 

NEW QUESTION 67
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 68
When exporting a notebook, what type of file is created?

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

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 69
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

• A. Autonomous Transaction Processing only
• B. Autonomous Data Warehouse only
• C. ATP and ADW
• D. Hybrid Columnar compression

Answer: B

 

NEW QUESTION 70
What are three methods to load data into the Autonomous Database?

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

Answer: B,C,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 71
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

• A. Security List
• B. Route Table
• C. Subnet
• D. VCN
• E. Network Security Group

Answer: C,D,E

Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources already created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure.
Cannot be changed after provisioning. A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm

 

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

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

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 73
Which operating system can Data Visualization Desktop be run on?

• A. AIX
• B. Solaris
• C. Linux
• D. Windows

Answer: D

Explanation:

 

NEW QUESTION 74
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

• A. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
• B. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
• C. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
• D. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.

Answer: A,B,C

Explanation:
SQL Developer is a free integrated development environment (IDE) provided by Oracle that simplifies the development and management of Oracle databases. A Java based platform, this IDE can run on Linux, Mac OS X, and Windows platforms. SQL Developer facilitates database migrations by providing options to use Oracle tools like Data Pump export, database copy, and SQL'Loader
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/sql-developer-web.html#GUID-102845D9-6855-4944-8937-5C688939610F

 

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

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

Answer: C,D

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

Introduction to Oracle 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exam

Oracle 1Z0-931-20: PeopleSoft 9.2 Database cloud Essentials exam is designed for candidates who have knowledge and skills in database cloud implementation or candidates who are willing to have a strong understanding of database cloud can go ahead and appear for this exam. The Oracle 1Z0-931-20 exam focuses on updating the expertise that could help you to work in the changing approaches of work. Having Oracle database cloud certification in your resume can help you to hunt for high paying jobs. To cover the current new subjects of 1Z0-931-20 exam questions, you need credible 1Z0-931-20 dumps pdf to an external site. for preparing the database cloud Essentials questions. The truth is, passing the 1Z0-931-20 new questions is not effortless without obtaining ideal preparation and Oracle 1Z0-931-20 exam dumps. The 1Z0-931-20 test is a part of the Oracle database cloud certification exams series, so to earn Oracle database cloud certification you must pass the exam questions. 1Z0-931-20 practice exams questions that may assist you to prepare for the entire 1Z0-931-20 subjects. The 1Z0-931-20 dumps are prepared by the Oracle specialists so it will help you to prepare and pass the exam with brilliant results.

 

Fully Updated Dumps PDF - Latest 1Z0-931-20 Exam Questions and Answers: https://www.testsimulate.com/1Z0-931-20-study-materials.html