2022 Valid 1Z0-931-20 test answers & Oracle Exam PDF [Q64-Q87]

2022 Valid 1Z0-931-20 test answers & Oracle Exam PDF

Free Oracle 1Z0-931-20 Exam Questions and Answer from Training Expert TestSimulate

NEW QUESTION 64
Which statement is correct about managing and monitoring of Autonomous Database?

A. You can use Service console to enable or disable auto scaling of Autonomous DB.
B. You can use Service console to manage runaway SQL statements on Autonomous DB.
C. You can use Service console to create manual backups of Autonomous database.
D. You can use Service console to move Autonomous DB between compartments.

Answer: D

NEW QUESTION 65
Which can be Scaled independently of the number of CPUs in an Autonomous Database?

A. Storage
you can independently scale the number of CPUs in Autonomous Database
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#GENERAL
B. Parallelism
C. Memory
D. Concurrency
E. Sessions

Answer: A

NEW QUESTION 66
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?

A. Data Sync can not transform your data while loading it into the destination table.
B. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
D. Data Sync can only load data from one source into one destination table.

Answer: C

Explanation:
You can load data from files (CSV and XLSX), various relational sources (tables, views, SQL statements), OTBI, JDBC data sources, and Oracle Service Cloud

NEW QUESTION 67
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?

A. The tablespace names will result in a blocking error during datapump import because of ADB limitations.
B. The migration can be a success, both technically and functional due to datapump enhancements.
C. The migration can be technically a success but the 3-rd party vendor needs to support the result.
D. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.

Answer: B

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-data-pump.html#GUID-9F6B551A-9DB7-44BE-A8ED-08E300C56DB1

NEW QUESTION 68
Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)

A. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.
B. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
C. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
D. Data is encrypted at rest using transparent data encryption.

Answer: B,C,D

Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html

NEW QUESTION 69
Which two system privileges does a user need to create analytic views? (Choose two.)

A. CREATE ATTRIBUTE DIMENSION
B. CREATE ANALYTIC HIERARCHY
C. CREATE ANALYTIC VIEW
D. CREATE ANALYTIC MEASURE
E. CREATE ANALYTIC LEVEL

Answer: A,C

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

NEW QUESTION 70
Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)

A. Create Notebooks
B. Create projects
C. Create Oracle Machine Learning User
D. Run SQL Scripts
E. Create workspaces

Answer: C,E

Explanation:

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-oracle-machine-learning.html#GUID-13452045-6AF6-402B-83CC-C9AFBCEC30CA

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

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

Answer: D

NEW QUESTION 72
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

A. Five. They are called tpurgent, tp, high, medium and low.
B. Two. They are called ATP and ADW.
C. Three. They are called high, medium and low.
D. None. There are no pre-defined service names in tnsnames.ora.

Answer: A

Explanation:
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://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATP

NEW QUESTION 73
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

A. Tablespaces
B. Data
C. Schemas
D. Reports

Answer: B,C

NEW QUESTION 74
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

A. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
B. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
C. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
D. A single fault domain can be associated with multiple regions and availability domains.

Answer: A,C

Explanation:
A region is a localized geographic area, and an availability domain is one or more data centers located within a region.
Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htm

NEW QUESTION 75
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

A. Create an IDCS user. Create a database user with connect, resource, and object privileges.
B. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
C. Create a database user with the default privileges.
D. Create a database user with connect, resource, and object privileges.

Answer: B

NEW QUESTION 76
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

A. TPPERFORMANT
B. MEDIUM
C. TPURGENT
D. HIGH
E. LOW

Answer: A

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 77
What are three methods to load data into the Autonomous Database?

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

Answer: A,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 78
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?

A. Only the migration to ADB is possible from an on-premise installation of Golden Gate.
B. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
C. The described scenario is correct, can be used for migration and fallback scenarios.
D. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.
E. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.

Answer: E

Explanation:
You can replicate data to Oracle Autonomous Data Warehouse Cloud and Autonomous Transaction Processing using Oracle GoldenGate On Premises and Oracle GoldenGate Cloud Service.
- You can configure the Autonomous Database instance as a target database for Oracle GoldenGate On Premises.
- You can't set up Oracle Autonomous Database Cloud database as a source database for Oracle GoldenGate On Premises.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION-BOOKMARK

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

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

Answer: A,C,E

NEW QUESTION 80
What is the default retention period for both Automatic and Manual Autonomous Database Backups?

A. 60 days
B. 30 days
C. One Year
D. 7 days
E. 90 days

Answer: A

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

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

Answer: A,C

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

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

Answer: B

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 83
What is the correct way to list all files in the default data pump directory?

A. By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;
B. Log onto ADW server and issue is -al on the command line.
C. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
D. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Answer: C

NEW QUESTION 84
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. Release Update (RU)
B. Quarterly Bundle Patch (QBP)
C. Prior Release Update (PRU)
D. Prior Release Update Revision (PRUR)

Answer: A

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

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

Answer: B

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks- data-analysis-and-data-visualization.html#GUID-1EE10D98-DEC3-4591-9D17-72DC5EDDD77D

NEW QUESTION 86
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?

A. TPPERFORMANT
B. MEDIUM
C. TPURGENT
D. HIGH
E. LOW

Answer: A

NEW QUESTION 87
......

What is the duration, language, and format of Oracle 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exam

Passing score: 60%
Length of Examination: 120 minutes
Language: English (U.S)
Number of Questions: 70
Format: Multiple choices

Top Oracle 1Z0-931-20 Courses Online: https://www.testsimulate.com/1Z0-931-20-study-materials.html

Welcome to TestSimulate

2022 Valid 1Z0-931-20 test answers & Oracle Exam PDF [Q64-Q87]

What is the duration, language, and format of Oracle 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exam

Related Blogs