Service console for 1Z0-931 autonomous database

Question 1: 

What two tasks can be executed from the service console for Autonomous Databases?

1. Autonomous Databases monitoring for usage and query performance
2. Wizard to download connection wallet for connection from desktop tools.
3. Creating and scaling of Autonomous Database service
4. Creating schemas

Explanation

Each Autonomous Database instance has its own service console for monitoring that specific instance. The Overview and Activity tabs in the Service Console provide information about the performance of the service. The Activity tab also shows past and current monitored SQL statements and detailed information about each statement.

Also from the Service Console for your Autonomous Database you can download Client Credentials (Wallet) , pick Administration, then Download the Client Credentials (Wallet).

Question 2:

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

1. Autonomous Data Warehouse
2. Neither service ignores hints by default
3. Autonomous Transaction Processing
4. Both services ignore hints by default

Explanation

Optimizer Hints Ignored by default in ADW. where honored by default in ATP

Question 3:

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

1. Autonomous Data Warehouse workloads are optimized for mixed workloads
2. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake

1. d) Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations

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

Question 4:

Which two statements are true when running DBMS_CLOUD.COPY_DATA?

1. a) valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure

1. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the

Object Store

1. The target table will be created in Autonomous Database if it does not already exist

Explanation

• The package DBMS_CLOUD supports loading from files in the following cloud services: Oracle Cloud Infrastructure Object Storage, Oracle Cloud Infrastructure Object Storage classNameic, Azure Blob Storage, and Amazon S3.
• For data loading from files in the Cloud, you need to first store your object storage credentials in

your Autonomous Transaction Processing and then use the procedure DBMS_CLOUD.COPY_DATA to load data

Question 5:

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

1. OCPUs and storage can be scaled independently
2. OCPUs and storage must remain in sync
3. Increasing OCPUs will automatically increase storage
4. Storage in TB cannot be larger than the number of OCPUs

Explanation

Oracle allows you to scale compute and storage independently, no need to do it together. these scaling activities fully online (no downtime required)

Question 6: 

What are two security features enabled by default by the Autonomous Database? a) Encrypted Database Links

1. SQL Net Encryption
2. One SYSDBA account
3. Read Only access to OS Audit logs
4. Transparent Data Encryption

Explanation

In Autonomous Database, Oracle encrypt your data everywhere—whether in motion in SQL*Net traffic, and at rest in tablespaces and backups by default, each Autonomous Database service is automatically configured to use industrystandard TLS 1.2 to encrypt data in transit between the database service and clients or applications. Required client certificates and networking information are automatically packaged for the service consumer when the service is provisioned

Oracle encrypt data at rest, by default the Autonomous Database is automatically encrypted using Oracle Transparent Data Encryption in tablespaces and backups

Question 7: 

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) Unplug into a pdb archive which can be uploaded to object storage

1. Create a database link from source database to the ADB environment and clone the PDB
2. Pluggable databases cannot be migrated to ADB using plug, unplug or clone
3. Unplug to an xml file so database files and xml file can be uploaded to object storage

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.

Question 8:

What are three methods to load data into the Autonomous Database?

1. Transportable Tablespace
2. Oracle Data Pump
3. RMAN Restore
4. Oracle GoldenGate
5. SQL*Loader

Explanation

You can load data into the autonomous database using Oracle Database tools and Oracle and third-party data integration tools. ( Oracle Data Pump & PL/SQL package, DBMS_CLOUD & SQL*Loader)

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

Question 9:

Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?

1. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other
2. A single fault domain can be associated with multiple regions and availability domains

Explanation

Oracle Cloud Infrastructure is physically hosted in regions and availability domains. A region is a localized geographic area, and an availability domain is one or more data centers located within a region. A region is composed of one or more availability domains.

Availability domains are isolated from each other, fault tolerant, and very unlikely to fail simultaneously or be impacted by the failure of another availability domain. When you configure your cloud services, use multiple availability domains to ensure high availability and to protect against resource failure.

Question 10:

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?

1. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB
2. Golden Gate on premise Is not certified with ADB because Golden Gate Cloud Service exists for this
3. Only the migration to ADB is possible from an on-premise installation of Golden Gate
4. The described scenario is correct, can be used for migration and fallback scenarios

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.

Question 11:

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

1. Autonomous Data Warehouse
2. Neither service ignores hints by default
3. Autonomous Transaction Processing
4. Both services ignore hints by default

Explanation

Optimizer Hints Ignored by default in ADW. where honored by default in ATP

Question 12:

What two methods can you use to define Machine Learning Users? a) Use DBMS_CLOUD_ADMIN package

1. SQL/Developer
2. Oracle Cloud Infrastructure Console
3. Client tools

Explanation

An administrator can add an existing database user account to Oracle Machine Learning or create a new user account and user credentials with the Oracle Machine Learning User Management interface.

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-oml.html#GUID-94476A16-F873-4079-831F-ED0580EA2CD4

Question 13:

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

1. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table
2. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition
3. In the TEST phase of the wizard, a subset of accepted records are displayed based on your definition

Explanation

Question 14:

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)? a) Import Table

1. Create a Data Set
2. Replicate the table using Golden Gate
3. Load data using Data Pump

Explanation

Data sets contain data from subject areas, Oracle Applications, databases, or uploaded data files such as spreadsheets.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-project-and-add-data-sets.html

Question 15:

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? a) Run SQL Scripts

1. Create Notebooks
2. Create workspaces
3. Create projects
4. Create Oracle Machine Learning User

Explanation

Which statement is true in regards to database links?

1. Connect from Autonomous Database to remote database using a database link
2. Connect to Autonomous Database from remote database using a database link
3. You can call PL/SQL procedures and functions using a database link
4. Create a database link from one Autonomous Database to another Autonomous Database instance

Explanation

• Before ADB May2019 update

ADB support ongoing database links only. so the correct answer is B

• After ADB May2019 update

Yes, database links are fully supported in ADB.

For serverless ADB deployments the target database must be configured to use TCP/IP with SSL (TCPS) authentication. ATP Dedicated does not support TCP/IP with SSL (TCPS) encrypted connections for DB Links.

so the correct answer should be all

Let's assume this question from old questions bulk and the answer is B

Question 17: 

Which operating system can Data Visualization Desktop be run on? a) Linux

1. Solaris
2. Windows
3. AIX

Explanation

System requirements to install Oracle Data Visualization Desktop

• Operating System: Microsoft Windows x64 (64-bit) 7 SP1+, 8.1, or 10; Windows Server 2012 R2;

MacOS Sierra (10.12), MacOS High Sierra (10.13), MacOS Mojave (10.14)

• CPU: Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz, 2992 Mhz 2 Cores, 2 Logical Processors or faster
• Memory: 4.00 GB Memory or more
• Minimum free disk space: 2GB plus space for any uploaded data files
• User privileges: You must have Admin privileges to perform the installation

https://www.oracle.com/solutions/business-analytics/analytics-desktop/oracle-analytics-desktop.html

Question 18:

The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames 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?

1. The migration can be technically a success but the 3-rd party vendor needs to support the result
2. The migration can be a success, both technically and functional due to data pump enhancements
3. The suggested data pump version will create an alias for non-standard tablespace names so the migration is successful.

Explanation

Autonomous Database configures and optimizes your database. You do not need to perform administration operations for configuring the database. SQL commands used for database administration such as CREATE TABLESPACE are not available.

The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.

Question 19:

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

1. Any version
2. 12c Release 2 onwards
3. 1 onwards

Explanation

JDBC Thin client versions earlier than 18.1 do not support connections through HTTP proxy

Question 20:

Which is NOT required to connect to Autonomous Database from SQL developer? a) Service name

1. Wallet file
2. Database name
3. Username and password

Explanation

This is the information required to connect to ADB from SQL Developer:

• Username: Enter the database username. You can either use the default administrator database account (ADMIN) provided as part of the service
• Password: Enter the password for the database user.
• Connection Type: Select Cloud Wallet
• Configuration File: Click Browse, and select the client credentials zip file.
• Service: Enter the service name. The client credentials file provides the service names.

Question 21:

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database. Which statement is true regarding the default configuration of the Autonomous Data Warehouse? a) Adding, removing, or modifying tablespaces is allowed

1. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed
2. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands

Explanation

• The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.
• You do not have direct access to the database node or to the local file system.
• Compression is enabled by default in ADW uses Hybrid Columnar Compression for all tables by default.

Question 22:

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure? a) Terraform

1. Enterprise Manager
2. REST API
3. Docker

Explanation https://www.terraform.io/docs/providers/oci/r/database_autonomous_database.html

Question 23:

Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's? a) Create, Query, Update, List, Start

1. Create, Query, List, Stop, Restore
2. Create, Get, List, Stop, Restore
3. Start, Delete, Update, Query, Stop

Explanation https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomous-database.html Available Commands: change-compartment create create-from-clone delete generate-wallet get

list

restore start stop update

Question 24:

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?

1. a) Data Pump creates the tablespaces used by your Autonomous Database

1. Data Pump is faster to migrate database than using RMAN
2. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

Explanation

The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.

Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Database.

Data Pump Import lets you import data from Data Pump files residing on Oracle Cloud

Infrastructure Object Storage, Microsoft Azure, AWS S3, and Oracle Cloud Infrastructure Object Storage classNameic. You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to

Question 25:

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

1. One Year
2. 90 days
3. 7 Days
4. 30 Days
5. 60 Days

Explanation

Autonomous Database automatically backs up your database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period.

Question 26

Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.

Which statement about these consumer groups is correct?

1. High provides highest concurrency and lowest resources, and DoP is i.
2. Medium provides intermediate resource and concurrency, and queries run in a serial.
3. High provides highest resources, lowest concurrency, and DoP is 1.
4. Low provides highest concurrency, lowest resources, and DoP =1.

Explanation

Predefined Database Service Names for Autonomous Data Warehouse

• high: The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements. Any SQL statement in this service can use all the CPU and IO resources in your database. The number of concurrent SQL statements that can be run in this service is 3, this number is independent of the number of OCPUs in your database.
• medium: The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements. Any SQL statement in this service can use multiple CPU and IO resources in your database. The number of concurrent SQL statements that can be run in this service depends on the number of OCPUs in your database.
• low: The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements. Any SQL statement in this service can use a single CPU and multiple IO resources in your database. The number of concurrent SQL statements that can be run in this service can be up to 100 times the number of OCPUs.

Question 27:

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

1. Click the Compute section of the menu, then choose Instance Configurations, then Download

Wallet

1. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then

Download the Wallet

1. e) Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials

Explanation

- To download client credentials, do the following from Oracle Cloud Infrastructure console:

(1)

Navigate to the Autonomous Database details page.

Click DB Connection.

On the Database Connection page click Download

(2)

Navigate to the Autonomous Database details page.

Click Service Console

Pick Administration tab, then Download the Client Credentials

Question 28:

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? a) DBNAME_MEDIUM

1. DBNAME_HIGH
2. DBNAME_CONCURRENT
3. DBNAME_LOW

Explanation

• high: The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements. Any SQL statement in this service can use all the CPU and IO resources in your database. The number of concurrent SQL statements that can be run in this service is 3, this number is independent of the number of OCPUs in your database.
• medium: The Medium database service provides a lower level of resources to each SQL statement potentially resulting a lower level of performance, but supports more concurrent SQL statements. Any SQL statement in this service can use multiple CPU and IO resources in your database. The number of concurrent SQL statements that can be run in this service depends on the number of OCPUs in your database.
• low: The Low database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements. Any SQL statement in this service can use a single CPU and multiple IO resources in your database. The number of concurrent SQL statements that can be run in this service can be up to 100 times the number of OCPUs.

Question 29:

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?

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

Explanation

Use Data Sync to upload, and manage data. You can load data from files (CSV and XLSX), various relational sources (tables, views, SQL statements), OTBI, JDBC data sources, and Oracle Service Cloud. You can load to relational tables or data sets.

Use Data Sync when you want to:

• Load data sources other than Oracle.
• Load a combination of data sources, such as CSV, XLSX, and Oracle relational files.
• Perform incremental data loads or rolling deletes.
• Perform insert-only or append strategies.
• Merge data from multiple sources.
• Transform your data (if you’re using Database As A Service or an on-premises database that is configured using the ‘Oracle (Thin)’).
• Schedule data loads. You can replace, append, and update data in tables by scheduling data loads and using the Load Strategy option of this utility.

Question 30:

Which two statements are true with regards to Oracle Data Sync?

1. a) Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database

1. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase
2. Data Sync can load your data in parallel in order to speed up the loading process.

Explanation

Use Data Sync when you want to:

• Load data sources other than Oracle.
• Load a combination of data sources, such as CSV, XLSX, and Oracle relational files.
• Perform incremental data loads or rolling deletes.
• Perform insert-only or append strategies.
• Merge data from multiple sources.
• Transform your data (if you’re using Database As A Service or an on-premises database that is configured using the ‘Oracle (Thin)’).
• Schedule data loads. You can replace, append, and update data in tables by scheduling data loads and using the Load Strategy option of this utility.

Use Data Sync to load data from these databases:

• Oracle
• DB2
• Microsoft SQL Server
• MySQL
• Teradata
• TimesTen

Load data from generic JDBC data sources too, for example:

• Greenplum
• Hive
• Impala
• Informix
• MongoDB
• NetSuite
• PostgreSQL
• Redshift
• Salesforce
• Sybase

Connection Type

================

• Select Oracle (BICS) if you’re loading data to the default Database Schema Service.
• If you’re loading data to Database Cloud Service, then select Oracle (Thin)

Question 31:

Which two methods can you use to create users and grant roles in Autonomous Database services?

1. through SQLPIus
2. through the Oracle Cloud Infrastructure service console
3. using DBMS_CLOUD_ADMIN package
4. through SQL/Developer

Explanation

To create users/grant roles in ADB, connect to the database as the ADMIN user using any SQL client tool.

Question 32:

Which three tasks by default are taken care of by the Autonomous Database? a) Database Upgrades

1. Application User Creation
2. Backups
3. Firmware Patching
4. Data Loading

Explanation

• By patching, Oracle patch the full stack—including the firmware, the OS, clusterware, and the database.
• Autonomous Database automatically backs up your database for you