[2022] Pass Oracle 1Z0-931-20 Test Practice Test Questions Exam Dumps
Verified 1Z0-931-20 dumps Q&As - 1Z0-931-20 dumps with Correct Answers
NEW QUESTION 60
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 61
Which is correct about security features that are available in Oracle Autonomous Database?
- A. Data Redaction and TDE are both supported.
- B. TDE but not Data Redaction.
- C. Neither Data Redaction nor TDE are supported.
- D. Data Redaction but not TDE.
Answer: A
Explanation:
All data is encrypted at rest using transparent data encryption, and data redaction is part of ADB.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html
NEW QUESTION 62
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 load a combination of data source, such as .csv, .xlsx and Oracle relational files.
- C. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
- D. Data Sync can only load data from one source into one destination table.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/data-sync.html
NEW QUESTION 63
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. ADMIN
- B. SCOTT
- C. SYS
- D. DWDEV
Answer: A
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 64
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)
- A. Data Pump
- B. CSV files copied to Autonomous Database block storage
- C. Recovery Manager (RMAN)
- D. Golden Gate
Answer: A,D
Explanation:
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, database clones, and transportable tablespaces to move your existing database to ADB.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION
NEW QUESTION 65
You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 days. Which database backup strategy would you select?
- A. Use the automated backups.
- B. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.
- C. Take monthly manual backups to supplement the automated backups and preserve them for 12 months.
- D. Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.
Answer: B
NEW QUESTION 66
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. 12c Release 2 onwards
- D. Any version
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-preparing.html#GUID-EFAFA00E-54CC-47C7-8C71-E7868279EF3B
NEW QUESTION 67
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
- A. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
- B. Oracle Database Result Cache is enabled by default for all SQL statements.
- C. You have direct access to the database node.
- D. Parallelism is not enabled by default.
Answer: A,D
NEW QUESTION 68
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
- A. CWALLET.SSO
- B. SQLNET.ORA
- C. TNSNAMES.ORA
- D. OJDBC.PROPERTIES
Answer: A
Explanation:
Create the Autonomous Data Warehouse Connection in Oracle Analytics Cloud.
- Sign in to Oracle Analytics Cloud.
- On the Home page, click Connect to Oracle Autonomous Data Warehouse.
- In Create Connection, enter a Connection Name, for example, MyADW_connection.
- In Description, enter a brief description.
- Click Select next to Client Credentials. In File Upload, select the wallet zip file from your download location. The Client Credentials field is populated with cwallet.sso, and the Service Name field contains a value.
- Enter your Oracle Autonomous Data Warehouse Username and Password.
- From the Service list, select the service for your data, and then click Save.
https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/oac_ee_dv/create_adwc_connection/html/index.html
NEW QUESTION 69
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
- A. ADWC
- B. DWROLE
- C. ADMIN
- D. ADBDEV
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873
NEW QUESTION 70
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 71
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Neither service ignores hints by default.
- B. Autonomous Transaction Processing.
- C. Both services ignore hints by default.
- D. Autonomous Data Warehouse.
Answer: D
Explanation:
Optimizer Hints Ignored by default in ADW, where honored by default in ATP When migrating data to Autonomous Database, table statistics are gathered automatically during direct path load operations. If direct path load operations are not used, such as with SQL Developer loads, the user can gather statistics manually as needed. When migrating an existing database that uses optimizer in parallel hints, ADB will ignore those by default. Because ADB runs in a highly tuned exadata environment, most database operations should run faster or at least as well as database tune with lots of hints to perform faster. Should hints be required for some reason, they can be explicitly re-enabled.
Autonomous Data Warehouse ignores optimizer hints and PARALLEL hints in SQL statements by default
NEW QUESTION 72
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. OS command line from the database server.
- B. OCI CLI
- C. SQLDeveloper
- D. Admin page of the Cloud Service Console
Answer: B
NEW QUESTION 73
What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)
- A. Creating schemas.
- B. Wizard to download connection wallet for connection from desktop tools.
- C. Creating and scaling of Autonomous Database service.
- D. Autonomous Databases monitoring for usage and query performance.
Answer: B,D
Explanation:
NEW QUESTION 74
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?
- A. TP
- B. TPURGENT
- C. LOW
- D. MEDIUM
Answer: B
Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-
44F1-8FF8-F5AC650F15BE
NEW QUESTION 75
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
- B. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- C. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- D. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- E. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
Answer: B,C
NEW QUESTION 76
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
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-4147-9606-0413D9CC1589
NEW QUESTION 77
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 of the wizard, a subset of accepted records is displayed based on your definition.
- D. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
Answer: C
Explanation:
NEW QUESTION 78
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
- A. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
- B. 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.
- 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: B,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 79
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
- A. TPURGENT
- B. TPPERFORMANT
- C. HIGH
- D. LOW
- E. MEDIUM
Answer: B
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 80
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?
- A. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
- B. Oracle Data Safe only supports Autonomous Databases.
- C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- D. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
Answer: B
NEW QUESTION 81
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 82
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 83
......
How to study the Oracle 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exam
Preparation for any certification could be challenging if the candidate has not done the proper planning and has not used relevant study material source. On the internet, the candidate would find lots of eBooks or material to study, but the problem is which one they should refer to and how to identify which one is genuine. To overcome this challenging phase, Actual4Dumps came with their study plan covering course contents specific to Oracle. 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exam, Actual4Dumps expert team recommends preparing some notes on these topics along with it. Do not forget to practice 1Z0-931-20 dumps pdf which has been written by our expert team. If you are taking 1Z0-931-20 exam questions for the first time, 1Z0-931-20 dumps should be your top priority. 1Z0-931-20 exam dumps can help you to understand the database cloud Essentials syllabus and you will have the ability to pass the Oracle database cloud certification exam with the best marks. You will also possess the 100% passing guarantee on the attested 1Z0-931-20 pdf dumps. This factor will boost your preparation. The high quality 24/7 consumer support on the 1Z0-931-20 dumps questions is also there to help you in preparing 1Z0-931-20 questions in case you discover any issue. In the long run, get the dumps 1Z0-931-20 practice material with verified questions and answers to pass your database cloud Essentials 1Z0-931-20 certification exam.
1Z0-931-20 certification guide Q&A from Training Expert Actual4Dumps: https://www.actual4dumps.com/1Z0-931-20-study-material.html