Best Preparations of 1Z0-931-20 Exam 2021 Oracle Cloud Unlimited 118 Questions
Focus on 1Z0-931-20 All-in-One Exam Guide For Quick Preparation.
NEW QUESTION 34
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "POST" REST call
- B. A "PUT" REST call
- C. An "INSERT" REST call
- D. A "GET" REST call
Answer: A
Explanation:
Use REST verb POST to create Autonomous Database with REST AP
https://docs.cloud.oracle.com/iaas/api/#/en/database/20160918/AutonomousDatabase/CreateAutonomousDatabase
NEW QUESTION 35
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 36
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. SQLDeveloper
- B. OS command line from the database server.
- C. OCI CLI
- D. Admin page of the Cloud Service Console
Answer: C
NEW QUESTION 37
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 only load files into tables (insert-only), the customer has to write the additional code.
- B. Data Sync can not transform your data while loading it into the destination table.
- 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:
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/data-sync.html
NEW QUESTION 38
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. HIGH
- C. MEDIUM
- D. TP
Answer: A
Explanation:
https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md
NEW QUESTION 39
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
- A. Create a database link from source database to the ADB environment and clone the PDB.
- B. Unplug into a pdb archive which can be uploaded to object storage.
- C. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- D. Unplug to an xml file so database files and xml file can be uploaded to object storage.
Answer: C
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
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, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION 40
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
- A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
- B. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
- C. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
- D. Data Sync can load your data in parallel in order to speed up the loading process.
Answer: A,D
Explanation:
https://www.oracle.com/technetwork/middleware/bicloud/downloads/bicsdatasync2-3-readme-3715844.pdf (4)
NEW QUESTION 41
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter user MTHEO quota unlimited on tablespace DATA;
- B. Execute alter tablespace DATA set quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter database for user MTHEO tablespace DATA quota = 10G;
Answer: B
NEW QUESTION 42
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
- A. VALIDATE_LEVELS
- B. VALIDATE_MEASURES
- C. VALIDATE_DIMENSION
- D. VALIDATE_ANALYTIC_VIEW
- E. VALIDATE_HIERARCHY
Answer: D,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 43
Which statement is true in regards to database links?
- A. Connect from Autonomous Database to remote database using a database link.
- B. You can call PL/SQL procedures and functions using a database link.
- C. Connect to Autonomous Database from remote database using a database link.
- D. Create a database link from one Autonomous Database to another Autonomous Database instance.
Answer: D
Explanation:
https://blogs.oracle.com/datawarehousing/making-database-links-from-adw-to-other-databases
NEW QUESTION 44
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Neither service ignores hints by default.
- B. Both services ignore hints by default.
- C. Autonomous Data Warehouse.
- D. Autonomous Transaction Processing.
Answer: C
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 45
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.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- C. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- 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 46
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet Administrators create, monitor and manage Autonomous Databases.
- B. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- C. Fleet Administrators are responsible for patching and backups of all container databases.
- D. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
Answer: D
NEW QUESTION 47
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. Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.
- B. Use the automated backups.
- C. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.
- D. Take monthly manual backups to supplement the automated backups and preserve them for 12 months.
Answer: C
NEW QUESTION 48
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter system set application_continuity=true
- B. alter session set application_continuity=true
- C. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- D. alter database set application_continuity=true
Answer: A
NEW QUESTION 49
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Active Data Guard
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Transparent Data Encryption
- D. Multitenant
- E. Exadata
Answer: A,B
NEW QUESTION 50
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Neither service ignores hints by default.
- B. Both services ignore hints by default.
- C. Autonomous Data Warehouse.
- D. Autonomous Transaction Processing.
Answer: C
Explanation:
http://blog.umairmansoob.com/tag/oracle-autonomous-data-warehouse/
NEW QUESTION 51
Which task is NOT automatically performed by the Oracle Autonomous Database?
- A. Patching the database.
- B. Automatically optimize the workload.
- C. Mask your sensitive data.
- D. Backing up the database.
Answer: C
Explanation:
https://www.oracle.com/database/what-is-autonomous-database.html
NEW QUESTION 52
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
- A. Backup and recovery must be done using Recovery Manager(RMAN).
- B. Select the archived redo logs.
- C. Select the snapshot of the backup.
- D. Select the backup from which restore needs to be done.
- E. Specify the point in time (timestamp) to restore.
Answer: D,E
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 53
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?
- A. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
- B. the Listener endpoint where the Autonomous Database should register on
- C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
- D. the 'High Availability Container Database' in which the Autonomous instance should run
- E. the Client Credentials wallet which is used to connect to the Autonomous Database
Answer: E
NEW QUESTION 54
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Schemas
- B. Reports
- C. Tablespaces
- D. Data
Answer: A,D
NEW QUESTION 55
Which is NOT required to connect to Autonomous Database from SQL developer?
- A. Service name
- B. Wallet file
- C. Database name
- D. Username and password
Answer: C
Explanation:
One of the most productive tools to use with Autonomous Database is SQL Developer, which is included for free with Autonomous Database. In this section, we show how to connect the Autonomous Database with SQL Developer. SQL developer fully supports connectivity to Autonomous Database and is Autonomous Database aware. To establish a connection to Autonomous Database, select the Connections green plus sign at the top left corner of the tool.
A new connection screen will appear, the same for an autonomous or non-autonomous database. In the top three lines, you will want to name the connection and fill in the appropriate username and password for the user you will be connecting to. Under Connection Type, the type to use for Autonomous Database is Cloud Wallet. When using this connection type, which is the only connection type supported for Autonomous Database, the location of the downloaded wallet must be specified in the configuration file entry.
Navigate to and select the downloaded wallet file. If the correct wallet file is selected, the service drop down will list all the services available to the Autonomous Database. Select the one that most appropriately provides the ser vice level your connection will require. Please refer to the section on user connections and services in another module for more information on this. Finally, to establish a connection, click Connect.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev182.html#GUID-14217939-3E8F-4782-BFF2-021199A908FD
NEW QUESTION 56
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are exported?
- A. Schemas
- B. Reports
- C. Tablespaces
- D. Data
Answer: A,D
NEW QUESTION 57
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
- A. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- B. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
- D. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
Answer: D,E
NEW QUESTION 58
......
Guaranteed Success with 1Z0-931-20 Dumps: https://www.fast2test.com/1Z0-931-20-premium-file.html