1z0-931-20 Free Practice Test

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

1. A. It cannot be done.
2. B. Using Database Configuration Assistant (DBCA) on the database server.
3. C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
4. D. Connecting to the Cloud Infrastructure Command console via SSH wallet.

Correct Answer: C
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureO

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

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

Correct Answer: E

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

1. A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
2. B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
3. C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
4. D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Correct Answer: D
- 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-414 https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

1. A. On the Autonomous Database Console.
2. B. SSH keys are not required in Oracle Cloud Infrastructure.
3. C. SSH keys cannot be added from consol
4. D. They have to be added using REST APIs only.
5. E. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Correct Answer: D
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.

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?

1. A. 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.
2. B. Create a database user with the default privileges.
3. C. Create a database user with connect, resource, and object privileges.
4. D. Create an IDCS use
5. E. Create a database user with connect, resource, and object privileges.

Correct Answer: A