Guide (New 2022) Actual Oracle 1Z0-931-20 Exam Questions [Q28-Q52]

Guide (New 2022) Actual Oracle 1Z0-931-20 Exam Questions

1Z0-931-20 Exam Dumps Pass with Updated 2022 Certified Exam Questions

NEW QUESTION 28
Which two Oracle Cloud Infrastructure database services allow you to dynamically scale both CPU and storage? (Choose two.)

• A. virtual machine DB system
• B. Autonomous Data Warehouse (ADW)
• C. Autonomous Transaction Processing (ATP)
• D. bare metal DB system

Answer: A,D

 

NEW QUESTION 29
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. MEDIUM
• C. TP
• D. HIGH

Answer: A

Explanation:
https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md

 

NEW QUESTION 30
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

• A. All underlying data for OML notebooks is cloned.
• B. All OML notebooks are cloned.
• C. Clone can be in a different region.
• D. All resource management rules are cloned.
• E. Current settings for ACLs are cloned.

Answer: B,D

 

NEW QUESTION 31
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 32
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 33
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 where target.workloadType = 'OLTP'
• C. Allow group ADB-Admins to manage autonomous-database in tenancy.
• D. Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Answer: B

 

NEW QUESTION 34
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

• A. It is enabled by default.
• B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
• C. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
• D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
• E. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

Answer: D

 

NEW QUESTION 35
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

• A. The Oracle Client Credential file is downloaded as a ZIP file.
• B. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
• C. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
• D. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.

Answer: D

Explanation:
When you download the client credentials from the Download Wallet dialog, you must enter a wallet password in the password field and confirm the password in the confirm password field. The password must be at least eight characters long and must include at least one letter and one numeric character or one special character. This password protects the download client credentials wallet. This wallet is not the same as the transparent data encryption wallet for the database. Therefore, a different password is used to protect the client credentials wallet.

 

NEW QUESTION 36
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

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

Answer: B,C,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 37
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

• A. In-flight transactions and queries are stopped.
• B. CPU billing is halted based on full-hour cycles of usage.
• C. User with DWROLE can still access the database.
• D. Tools are no longer able to connect to a stopped instance.

Answer: A,B,D

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9

 

NEW QUESTION 38
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

• A. Select the backup from which restore needs to be done.
• B. Select the snapshot of the backup.
• C. Select the archived redo logs.
• D. Specify the point in time (timestamp) to restore.
• E. Backup and recovery must be done using Recovery Manager(RMAN).

Answer: A,D

Explanation:
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup- recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C

 

NEW QUESTION 39
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)

• A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
• B. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
• C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
• D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
• E. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.

Answer: A,B

 

NEW QUESTION 40
Which two statements are true with regards to Oracle Data Sync? (Choose two.)

• A. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
• B. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
• C. Data Sync can load your data in parallel in order to speed up the loading process.
• D. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.

Answer: C,D

Explanation:
https://www.oracle.com/technetwork/middleware/bicloud/downloads/bicsdatasync2-3-readme-3715844.pdf (4)

 

NEW QUESTION 41
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 42
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

• A. Select the backup from which restore needs to be done.
• B. Select the snapshot of the backup.
• C. Select the archived redo logs.
• D. Specify the point in time (timestamp) to restore.
• E. Backup and recovery must be done using Recovery Manager(RMAN).

Answer: A,D

Explanation:
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C

 

NEW QUESTION 43
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. MEDIUM
• C. TP
• D. HIGH

Answer: B

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 44
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

• A. Data Pump Export File
• B. Microsoft SQL Server (.mdf)
• C. JSON
• D. Text
• E. Parquet
• F. Avro

Answer: F

 

NEW QUESTION 45
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. TPURGENT
• B. MEDIUM
• C. TP
• D. LOW

Answer: A

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 46
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are exported?

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

Answer: B,C

 

NEW QUESTION 47
Which task is NOT automatically performed by the Oracle Autonomous Database?

• A. Backing up the database.
• B. Patching the database.
• C. Automatically optimize the workload.
• D. Mask your sensitive data.

Answer: D

Explanation:
https://www.oracle.com/database/what-is-autonomous-database.html

 

NEW QUESTION 48
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 49
Which task is NOT automatically performed by the Oracle Autonomous Database?

• A. Backing up the database.
• B. Patching the database.
• C. Automatically optimize the workload.
• D. Mask your sensitive data.

Answer: D

Explanation:
- Oracle patch the full stack-including the firmware, the OS, clusterware, and the database.
- Oracle Autonomous Database is actually a family of cloud services, with each member of the family optimized by workload. Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads and Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload.
- it is possible to use Oracle Data Safe data masking capabilities with cloned instances of ADB. but by the customer
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846

 

NEW QUESTION 50
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

• A. Place the credential files on a share drive that all users can use to connect to the database.
• B. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
• C. When you share the credential files with authorized users, mail the wallet password and the file in the same email.
• D. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

Answer: D

Explanation:
Connection to Autonomous DB uses certificate authentication and Secure Sockets Layer (SSL). This ensures that there is no unauthorized access to Autonomous DB and that communications between the client and server are fully encrypted and cannot be intercepted or altered.
Certification authentication uses an encrypted key stored in a wallet on both the client (where the application is running) and the server (where your database service on the Autonomous DB is running). The key on the client must match the key on the server to make a connection There's credentials zip file available for download once ADB is created, the zip file contains a collection of files, that needed to connect to your Autonomous DB. All communications between the client and the server are encrypted Wallet files, along with the Database user ID and password provide access to data in your Autonomous Transaction Processing database. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.
For better security, Oracle recommends using restricted permissions on wallet files. This means setting the file permissions to 600 on Linux/Unix.
Similar restrictions can be achieved on Windows by letting the file owner have Read and Write permissions while all other users have no permissions.
https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbconnecting.htm
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1

 

NEW QUESTION 51
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

• A. VALIDATE_ANALYTIC_VIEW
• B. VALIDATE_LEVELS
• C. VALIDATE_MEASURES
• D. VALIDATE_DIMENSION
• E. VALIDATE_HIERARCHY

Answer: A,E

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/18/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

 

NEW QUESTION 52
......

Pass Guaranteed Quiz 2022 Realistic Verified Free Oracle: https://www.easy4engine.com/1Z0-931-20-test-engine.html