Oracle Autonomous Database Cloud Specialist

What is the retention period for the backups in Autonomous Database? 45 days 60 days 7 days 30 days

60 days

What is the default Backup retention policy for the Autonomous Container Database? 30 15 8 7

7

What is the default retention period for performance data? 7 days 8 days 14 days 15 days

8

Which statements are true about a Virtual Cloud Network (VCN)? (Choose three) A VCN cannot connect to another VCN. A VCN can have only one subnet. A subnet for a VCN can be defined in different Ads. A VCN is a software/virtual version of a traditional network. A VCN can be used with only one DB System. A VCN can reside only in a single region but can cross multiple availability domains (AD).

A subnet for a VCN can be defined in different Ads. A VCN is a software/virtual version of a traditional network. A VCN can reside only in a single region but can cross multiple availability domains (AD).

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. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed. B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to. C. Adding, removing, or modifying tablespaces is allowed. D. 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.

B https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienceddatabase-users.html#GUID-58EE6599-6DB4-4F8E-816D-0422377857E5

From which cloud services does DBMS_CLOUD provide support for loading data from files to tables in Autonomous Database? (Choose three) Amazon AWS S3 Dell EMC Elastic Cloud Storage IBM Spectrum Storage OCI Object Storage OCI Object Storage Classic

Amazon AWS S3 OCI Object Storage OCI Object Storage Classic

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are exported? A. Tablespaces B. Data C. Reports D. Schemas

B, D

Which two PL/SQL functions can be used to validate an analytic view? (Choose two.) A. VALIDATE_LEVELS B. VALIDATE_HIERARCHY C. VALIDATE_DIMENSION D. VALIDATE_ANALYTIC_VIEW E. VALIDATE_MEASURES

B. VALIDATE_HIERARCHY D. VALIDATE_ANALYTIC_VIEW You can validate the data for analytic view and hierarchy objects with the following procedures in the DBMS_HIERARCHY package: CREATE_VALIDATE_LOG_TABLE procedure VALIDATE_ANALYTIC_VIEW function VALIDATE_CHECK_SUCCESS function VALIDATE_HIERARCHY function For details about this package, see DBMS_HIERARCHY in Oracle Database PL/SQL Packages and Types Reference. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-FC745EA1-721D-48E3-96D1-B4DE1758AFF8

Can Data Pump import data from an Oracle DB sitting on any system, or just Linux (any)

Any system

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? A. UPDATE_OBJECT_INFO B. MODIFY_SNAPSHOT_SETTINGS C. CREATE_BASELINE_TEMPLATE D. MODIFY_BASELINE_WINDOW_SIZE

B The retention time can be changed by modifying the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS. Be aware that increasing the retention time will result in more storage usage for performance data https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitorperformance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)? A. Replicate the table using Golden Gate B. Create a Data Set C. Load data using Data Pump D. Import Table

B To import objects from the Autonomous Data Warehouse into Oracle Analytics Cloud, click on Create Data Set. Then select the connection you created earlier. If you skipped the step on creating a connection, click on the Create Connection button and follow the screens to create it. Then continue. https://blogs.perficient.com/2019/07/22/loading-data-into-oracle-autonomous-data-warehouseusing-oac/

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. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to C. Adding, removing, or modifying tablespaces is allowed D. 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

B https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienceddatabase-users.html#GUID-58EE6599-6DB4-4F8E-816D-0422377857E5

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.) A. through the Oracle Cloud Infrastructure service console B. through SQL/Developers C. using DBMS_CLOUD_ADMIN package D. through SQLPIus

B. through SQL Developer D. through SQL PIus https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-createservice https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connectsqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqldev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417 https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloudadmin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B

Which DB system type provides Instance isolation? Exadata DB Systems only Bare Metal DB Systems only Bare Metal and Exadata DB Systems Virtual Machine DB Systems only Bare Metal and Virtual Machine DB Systems

Bare Metal DB Systems only

How does SQL Dev's data-loading wizard help you test that the loading of a file will be successful? - it creates a temp table and only loads the data in the table if successful - it tests a sample before running the import - it tests the whole data before importing - when you define the column mapping, it verifies that the data type is consistent for all the data of the columns in your file

"The test will simply create the External table and show the results of trying to query it via your load parameters as defined in the previous screens."

DBMS_CLOUD_ADMIN Package (to read) - Only available on ADW and ATP on Autonomous Shared version (in the Dedicated version you can do it directly on the DB) - Provides administrative operations - The package is available to ADMIN user - To run the CREATE_DATABASE_LINK as a user other than ADMIN, the user must be granted EXECUTE on CREATE DATABASE LINK privilege. - Use GRANT_TABLESPACE_QUOTA to explicitly grant a quota to a user if they need to load data

- CREATE_DATABASE_LINK - DROP_DATABASE_LINK - ENABLE_APP_CONT - DISABLE_APP_CONT - GRANT_TABLESPACE_QUOTA

Which statement is true about effectively protecting customer data in the Oracle Autonomous Database? - Customers can identify sensitive data and mask it for use in partner or development environments - Customer can identify sensitive data and mask it for use in production environments only - It automatically identifies sensitive data and masks it for use in production environments only - It automatically identifies sensitive data and masks it for use in development environments only

- Customers can identify sensitive data and mask it for use in partner or development environments

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 has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata. C. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database. D. Data Sync can load your data in parallel in order to speed up the loading process

- Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase - Data Sync can load your data in parallel in order to speed up the loading process https://www.ateam-oracle.com/configuring-the-data-sync-tool-for-bi-cloud-service-bics

Which statement is true about the Security feature in the Oracle Autonomous Database? - Database clients can connect securely using TLS/wallet - Some connections use certificate-based authentication and SSL - Certificate-based authentication uses an encrypted key store in a wallet on the server - Database clients can only connect securely using the wallet

- Database clients can connect securely using TLS/wallet

Which three statements are true about the Autonomous Databa OCI Integration? - It allows connectivity to object stores such as Amazon S3 - Autonomous Database is hosted in the availability domains - Its components include Oracle Machine Learning - Backups can be accessed like any other file on object store - It offers unlimited access to the Autonomous Database for all OCI resources

- It allows connectivity to object stores such as Amazon S3 - Autonomous Database is hosted in the availability domains - Its components include Oracle Machine Learning

Which statement is true about Auto Scaling feature while provisioning a Non-Free Tire Autonomous Database instance? - It cannot be disabled - It is not supported feature - It is enabled by default - It needs to be explicitly enabled

- It is enabled by default

Which two can be used for troubleshooting the data load operation in the Autonomous Database? - Log and bad files accessible as tables - Log files accessible from file system - Load operations logged in file system - Load operations logged in *_load_operations dictionary - Log files only accessible as tables

- Log and bad files accessible as tables - Load operations logged in *_load_operations dictionary

Which two statements are correct with respect to the Private Cloud setup in the Autonomous Database Dedicated deployment? - Half rack does not offer various shapes to choose from - It is not necessary to create Compartments - OCI Compartments are assigned to IT and end-users based on the organizational structure - You need to create private networking overlay for the organizational structure

- OCI Compartments are assigned to IT and end-users based on the organizational structure - You need to create private networking overlay for the organizational structure

Which three tools are bundled with the Autonomous Database? - OCI console - enterprise manager cloud control - SQL developer web - enterprise manager grid control - SQL developer

- OCI console - enterprise manager cloud control - SQL developer web

Which two valid ADB connectivity methods are used from a third-party software? - ODBC uses SSL with public internet - SQL *Net uses SSL for encryption - .NET uses public internet only - JDBC uses FastConnect only

- ODBC uses SSL with public internet - SQL *Net uses SSL for encryption

Which three statements are true with respect to the new Database role in the Autonomous Database? - There's no need to specify anything except the password - ADBROLE includes all necessary privileges for a ADB developer/user - ADWROLE includes all necessary privileges for the ADW developer/user - By default, the database password will not expire until 360 days - DWROLE includes all necessary privileges for a DW developer/user - It requires a simple password

- There's no need to specify anything except the password - By default, the database password will not expire until 360 days - DWROLE includes all necessary privileges for a DW developer/user

Which three selections are required for provisioning an Autonomous Database Service after login to the OCI Console? - availability domain - object storage - compartment - workload type - tenant - region

- availability domain - compartment - workload type

Which two features differentiate the Dedicated from the Shared Infrastructure Deployment options? - controllable software update version - VCN and private IP connect - availability domain placement choice - backup retention configuration

- controllable software update version - availability domain placement choice

How many CPU shares can be used by a SQL statement in a Low database service? 4 2 1 3

1

How many SQL statements a paragraph can contain? 1 5 10 2

1

What is the number of concurrent queries supported by the medium database service? 3 40 32 20

20

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud? A. Original Import/Export tools B. Physical migration method like database cloning C. Data Pump D. RMAN backup & restore

C 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/adbfaqs.html#MIGRATION

Which statement about the Export Wizard used to export database objects and data is NOT correct? A. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported. B. Export DDL includes features such as "Show schema," "Storage," and "Terminator." C. If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema. D. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.

C https://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm https://www.thatjeffsmith.com/archive/2012/06/copying-columns-from-grid-to-clipboard-in-sqldeveloper/

On what infrastructure does the Autonomous Database run on? A. VM on Oracle Cloud Infrastructure B. Any Oracle Engineered system C. Exadata on Oracle Cloud Infrastructure D. Bare-metal on Oracle Cloud Infrastructure

C. Exadata on Oracle Cloud Infrastructure

Which actions can be performed from the Autonomous Container Database (CDB) details page? (Choose three) A. Change maintenance schedule B. Stop CDB C. Move CDB to a different compartment D. Stop Autonomous Database E. Change backup retention policy for CDB F. Restart CDB

C. Move CDB to a different compartment E. Change backup retention policy for CDB F. Restart CDB

ADBMS_CLOUD_MACADM Package - Available on Autonomous Shared - Database Vault is configured using the CONFIGURE_DATABASE_VAULT package as the ADMIN user - This grants the roles DV_OWNER and DV_ACCTMGR to specified user - The DV_OWNER can then enable, disable and manage Database Vault - The DV_OWNER cannot be the ADMIN user - To disable Database Vault the Autonomous Instance must be restarted

CONFIGURE_DATABASE_VAULT ENABLE_DATABASE_VAULT DISABLE_DATABASE_VAULT DISABLE_USERMGMT_DATABASE_VAULT ENABLE_USERMGMT_DATABASE_VAULT

What is the degree of parallelism for HIGH database service? 4 Manual CPU_COUNT 1

CPU_COUNT

Which two system privileges does a user need to create analytic views? (Choose two.) REATE ANALYTIC MEASURE CREATE ANALYTIC LEVEL CREATE ANALYTIC HIERARCHY CREATE ANALYTIC VIEW CREATE ATTRIBUTE DIMENSION

CREATE ANALYTIC VIEW CREATE ATTRIBUTE DIMENSION

Which sources can Data Sync connect to?

CSV, XLSX, tables, views, SQL statements OTBI, JDBC data sources, and Oracle Service Cloud

What are the steps to create an analytics view?

Create Project > Data Set > Dashboard ..

With which of the following does Oracle Machine Learning allow access to data in Autonomous Database? Data Ingestion and Selection and Data Viewing and Discovery Data Ingestion and Selection only Data Ingestion and Selection and Data Viewing and Discovery, and Data Analysis Data Viewing and Discovery and Data Ingestion and Selection

Data Ingestion and Selection and Data Viewing and Discovery, and Data Analysis

Data Sync information - Load data source 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 - 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

Data Sync different Database - Oracle - DB2 - Microsoft SQL Server - MySQL - Teradata - TimesTen JDBC Data Sources - Greenplum - Hive - Impala - Informix - MongoDB - NetSuite - PostgreSQL - Redshift - Salesforce - Sybase

Which statements are true about backup and recovery in Autonomous Database? (Choose three) Database can be recovered to any point in time in the retention period. Manual recovery cannot be initiated. Database is automatically backed up. Automatic backups provide weekly backup and daily incremental backup. Manual backups cannot be taken.

Database can be recovered to any point in time in the retention period. Database is automatically backed up. Automatic backups provide weekly backup and daily incremental backup.

What are the prerequisites for taking manual backups in Autonomous Database? (Choose two) Create a compartment to hold the backups. Define Oracle Cloud Infrastructure Object Storage credentials only. Define Oracle Cloud Infrastructure Object Storage credentials and tenancy URL. Create a bucket to hold the backups.

Define Oracle Cloud Infrastructure Object Storage credentials and tenancy URL. Create a bucket to hold the backups.

By terminating an Autonomous Exadata Infrastructure, all the Autonomous Container Databases in it will also get terminated. TRUE FALSE

FALSE

Which statements are true about automated tuning? (Choose three) Partitioning not covered under the automated tuning Parallel execution of the queries needs to be monitored manually. Fast performance out of the box with zero tuning Built-in resource management plans Simple web-based monitoring console

Fast performance out of the box with zero tuning Built-in resource management plans Simple web-based monitoring console

Which JDBC driver versions support http proxy and ADB ?

From 18.1 up

From where can you create Oracle Machine Learning users? From the Administration tab in the Service Console From the Admin Password tab from the Details tab From the Activity tab in the Service tab From the Overview tab in the Service Console

From the Administration tab in the Service Console

Where can you find the URL for SQL Developer Web? - In the DB Connection dialog box, copy the URL of the SQL Developer Web from the connection strings section. - URL for the SQL Developer is present inside the client credentials wallet. - URL for the SQL Developer is present in the Actions tab on the Autonomous Database details page. - In the DB Connection dialog box, select Application connection and copy the URL of SQL Developer Web.

In the DB Connection dialog box, select Application connection and copy the URL of SQL Developer Web.

Which statements are true about DWROLE? (Choose two) It is by default granted to any new user added to the ADW database. It includes all necessary privileges for a developer. It has common privileges for both ADW and ATP workloads. It has privileges for ADW workload only.

It includes all necessary privileges for a developer. It has common privileges for both ADW and ATP workloads.

Which statements are true about the API Signing Key? (Choose two) It must be generated with a passphrase. An RSA key pair in PEM format must have a minimum of 1024 bits. It is an RSA key pair in the PEM format. It is required when using OCI API in conjunction with the SDK/CLI.

It is an RSA key pair in the PEM format. It is required when using OCI API in conjunction with the SDK/CLI.

Ideally which of the following tasks will a Fleet Administrator perform? (Choose two) Provision Autonomous Exadata Infrastructure Manage Autonomous Databases Create IAM users Provision Autonomous Container Databases Provision Autonomous Database Instances

Provision Autonomous Exadata Infrastructure Provision Autonomous Container Databases

Which chart shows the average number of queued SQL statements in each consumer group? Running SQL Statements Queued Statements Running Statements Average SQL Statements Response Time

Queued Statements

Which statements are true about built-in SQL Worksheet and Notebook? (Choose two) Need to install client query tool for the PL/SQL Quickly start running queries with built-in web-based notebooks Based on Apache Tomcat No need to install a client query tool

Quickly start running queries with built-in web-based notebooks No need to install a client query tool

Available consumer groups ADW - High: (Idem) High resources, low concurrency, parallelism - Medium: Less resources, higher concurrency, parallelism - Low: (idem) least resources, highest concurrency, no parallelism

Read card and memorize

Available consumer groups ATP - TPUrgent : priority transactional apps. Manual parallelism - TP: transactional apps. No parallelism - High : reporting. Parallelism (but only if specified in a clause) - Medium : reporting. Parallelism degree up to 4. (but only if specified in a clause) - Low: reporting. No Parallelism

Read card and memorize

CPU/IO shares for each consumer group ATP TPUrgent : 12 TP: 8 High : 4 Medium : 2 LOW: 1

Read card and memorize

Compression ADW - Enabled by default : uses Hybrid Columnar Compression - You can specify different compression methods for your tables using the compression clause in your CREATE TABLE or ALTER TABLE commands.

Read card and memorize

Compression ATP - Not enabled by default - Honors a compression clause if compression is specified on a table

Read card and memorize

Optimizer Hints and Parallel Hints ADW Ignores optimizer hints and PARALLEL hints by default. You can activate optimizer hints and parallel hints at the session or system level e.g. for parallel hints ALTER SESSION SET OPTIMIZER_IGNORE_PARALLEL_HINTS=FALSE;

Read card and memorize

Optimizer Hints and Parallel Hints ATP Honors optimizer and PARALLEL hints by default. You can disable them at the session or system level e.g. optimizer hints ALTER SESSION SET OPTIMIZER_IGNORE_HINTS=TRUE;

Read card and memorize

Optimizer stats ADW Automatically gathered for tables loaded with direct-path load operations(e.g. using DBMS_CLOUD). If you have tables modified using DML, you can run commands to gather stats automatically on stale tables in a schema BEGIN DBMS_STATS.GATHER_SCHEMA_STATS('SH', options=>'GATHER AUTO'); END; - this feature exists on-prem since a long time - stale statistics will be updated in an maintenance window

Read card and memorize

Optimizer stats ATP Automatically done for all tables. Runs in a standard maintenance window.

Read card and memorize

Parallelism (for SELECT queries) and parallel DML ADW Parallelism: - Enabled by default. - The degree of parallelism for SQL statements is set based on -> the number of OCPUs in the system -> and the database service the user is connecting to. Parallel DML: - Enabled by default - Can be disabled at the session level: -> ALTER SESSION DISABLE PARALLEL DML;

Read card and memorize

Parallelism (for SELECT queries) and parallel DML ATP Parallelism: - Not enabled by default - You can specify a degree of parallelism -> using the parallel clause for a table or an index ALTER TABLE sales PARALLEL 8; -> or by using a hint [but I guess you should have activated hints first] SELECT /*+parallel */ ename FROM emp; Parallel DML - Not enabled by default Can be enabled at the session level: -> ALTER SESSION ENABLE PARALLEL DML;

Read card and memorize

Result Cache ADW - Enabled by default for all SQL statements. - Changing the result cache mode is not allowed.

Read card and memorize

You want to migrate a schema from an on-premises database to an ATP dedicated instance using data pump export. You specified the ENCRYPTION parameter as DATA_ONLY and Oracle encryption wallet is open. Which type of encryption mode will be used in this scenario? Password None Dual Transparent

Transparent

Which of these do you need to enter when you set up the Config File using the oci setup config command? (Choose three) OCI Region OCID User OCID File format of the config file Location of the config file Tenancy OCID

User OCID Location of the config file Tenancy OCID

Which of the following are used by IAM service to authenticate a principal? (Choose three) Username / Password API signing key SSH Wallet Credentials Auth Tokens

Username / Password API signing key Auth Tokens

What are the inputs you provide when creating an Autonomous Exadata Infrastructure resource? (Choose three) Storage VCN Shape Availability Domain

VCN Shape Availability Domain

At what levels can we implement isolation with Autonomous Database Dedicated Deployment? (Choose three) Subnet Level Virtual Cloud Network (VCN) level Database level Container Database level Region level

Virtual Cloud Network (VCN) level Database level Container Database level

Does Data Sync perform parallel loading of data?

Yes For connections to Oracle BI Cloud Service, Data Sync loads a maximum of four tables in parallel. For connections to Database as a Service or on-premises databases, Data Sync defaults to 10 maximum, but you can specify how many tasks can run in parallel. You specify the number of parallel tasks that you want to allow using the # Parallel Tasks value on the Jobs

Can Data Pump import table space names?

Yes The Data Pump Import command-line mode TABLESPACES parameter specifies that you want to perform a tablespace-mode import.

Which dictionary views can be used to see the results of validate operations? (Choose two) dba_load_operations dba_workload_sql_map user_load_operations dba_workload_filters

dba_load_operations user_load_operations dba_load_operations: shows all load operations user_load_operations: shows the load operations in your schema Query tables to see the information about ongoing and completed data loads. USER_LOAD_OPERATIONS columns TYPE column - load operations with the type COPY LOGFILE_TABLE column - name of the table you can query to look at the log of a load operation (SELECT * FROM COPY$5_LOG) BADFILE_TABLE column - name of the table to see rows that got errors and were rejected for the load operation (SELECT * FROM COPY$5_BAD)

If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details? tnsnames.ora keystore.jks sqlnet.ora cwallet.sso ojdbc.properties

tnsnames.ora

In which Oracle client credentials' file (wallet file) can we find the port number? ojdbc.properties truststore.jks listener.ora tnsnames.ora sqlnet.ora

tnsnames.ora

What are the steps to create an OML user?

In the ADB service console, use the tab Administration to add OML users

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.) A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region. 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. A single fault domain can be associated with multiple regions and availability domains. D. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

A, B 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. Oracle Cloud Infrastructure is 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. Our region is composed of one or more available domains. Most cloud infrastructure resources are either region-specific, such as virtual cloud networks, or availability-domain-specific, such as compute instance. Traffic between availability domains and between regions is encrypted. Availability domains are isolated from each other, fault tolerant, and very unlikely to fail simultaneously. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one 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

Which statement is correct about the version of Java that is recommended for use with tools that use Java Database Connectivity (JDBC) connections? A. JDBC .Jar files are specific to each platform B. JDBC drivers do NOT support multiple Java Developer Kit versions C. It doesn't matter, but you must Install the JCE Unlimited Strength Policy Files D. Java Development Kit Version 7 E. Java Development Kit Version 8 or higher

A. JDBC .Jar files are specific to each platform

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. Pluggable databases cannot be migrated to ADB using plug, unplug or clone. B. Create a database link from source database to the ADB environment and clone the PDB. C. Unplug to an xml file so database files and xml file can be uploaded to object storage. D. Unplug into a pdb archive which can be uploaded to object storage.

A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone. 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.

Which statements are true about network security? (Choose two) Access can be restricted between tenancies and within the tenancy itself. Permissions can be used to isolate networking between compartments and VCNs. Tenancies cannot be completely network isolated. Access between tenancies can be restricted with the same availability domain. Subnets can be created only within an availability domain.

Access can be restricted between tenancies and within the tenancy itself. Permissions can be used to isolate networking between compartments and VCNs.

Which file do you need to modify to setup the proxy when connecting OAC to ADB (jdbc.properties or sqlnet.ora?)

Add the following line to the sqlnet.ora file to enable connections through an HTTP proxy: Copy SQLNET.USE_HTTPS_PROXY=on Add the HTTP proxy hostname and port to the connection definitions in tnsnames.ora: You need to add the https_proxy and https_proxy_port parameters in the address section of connection definitions. For example, the following sets the HTTP proxy to proxyhostname and the HTTP proxy port to 80; replace these values with your HTTP proxy information: ADWC1_high = (description= (address= (https_proxy=proxyhostname)(https_proxy_port=80)(protocol=tcps)(port=1522)(host=adwc.example.oraclecloud.com) ) (...) Note: Connections through an HTTP proxy are only available with Oracle Client software version 12.2.0.1 or later.

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario? A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster. B. ADW since operational reporting is a higher priority in this scenario. C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis. D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

D Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store. As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? A. On the Autonomous Database Console B. SSH keys are not required in Oracle Cloud Infrastructure C. SSH keys cannot be added from console. They have to be added using REST APIs only D. Navigate to Identity, select Users panel on the console and select "Add Public Key"

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.

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage? A. Storage in TB cannot be larger than the number of OCPUs. B. OCPUs and storage must remain in sync. C. Increasing OCPUs will automatically increase storage. D. OCPUs and storage can be scaled independently.

D You simply specify the number of OCPUs and the storage capacity in TB's for the database. At any time, you may scale, increase or decrease either the OCPUs or the storage capacity. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-addresources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0

How many CDB can you have in the Dedicated (you have an Exadata infrastructure) offer? A. 1 B. 2 C. 3 D. 4 E. 10

D. 4

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 snapshot of the backup C. Select the archived redo logs D. Select the backup from which restore needs to be done E. Specify the point in time (timestamp) to restore

D. Select the backup from which restore needs to be done E. Specify the point in time (timestamp) to restore 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/backkuprecover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure? A. Dlocker B. Enterprise Manager C. REST API D. Terraform

D. Terraform

Which procedure can be used to load data directly into the existing Autonomous Database tables? DBMS_CLOUD.COPY_DATA DBMS_CLOUD.LIST_FILES DBMS_CLOUD.CREATE_EXTERNAL_TABLE DBMS_CLOUD.PUT_OBJECT

DBMS_CLOUD.COPY_DATA

Loading data from files in the cloud DBMS_CLOUD package First you need to create the token to use in the CREATE_CREDENTIAL

DBMS_CLOUD.CREATE_CREDENTIAL ( credential_name IN VARCHAR2 username IN VARCHAR2 password IN VARCHAR2 ); DBMS_CLOUD.COPY_DATA { table_name IN VARCHAR2 credential_name IN VARCHAR2 file_uri_list IN CLOB schema_name IN VARCHAR2 DEFAULT field_list IN CLOB DEFAULT format IN CLOB DEFAULT);

Which procedure can be used to move the Data Pump Import log file from Autonomous Database to Oracle Cloud Object Storage? DBMS_CLOUD.LIST_FILES DBMS_CLOUD.COPY_DATA DBMS_CLOUD.CREATE_EXTERNAL_TABLE DBMS_CLOUD.PUT_OBJECT

DBMS_CLOUD.PUT_OBJECT

How to change the retention period of performance stats?

DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? A. DBNAME_HIGH B. DBNAME_MEDIUM C. DBNAME_CONCURRENT D. DBNAME_LOW

DBNAME_LOW For example, a user connecting with the adw1_low service uses the consumer group LOW. The basic characteristics of these consumer groups are: HIGH: Highest resources, lowest concurrency. Queries run in parallel. MEDIUM: Less resources, higher concurrency. Queries run in parallel. LOW: Least resources, highest concurrency. Queries run serially. For example, a user connecting with the atp1_tp service uses the consumer group TP. The basic characteristics of these consumer groups are: 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.

Which actions does SQL Dev's data loading wizard support? - the generated DDL is copied to you clipboard - the DDL can edit your schema

DDL stands for Data Definition Language. DML stands for Data Manipulation Language. DDL statements are used to create database, schema, constraints, users, tables etc. DML statement is used to insert, update or delete the records.

Can Data Sync only connect through JDBC, or also OCI and non-Oracle drivers (DB2, MySQL, Teradata)?

No, Data Sync can load data from and to different sources.

Can you use Golden Gate on-premises to sync ADB with an on-prem DB ? And vice versa?

Oracle Autonomous Database cannot be a source database. Use Oracle GoldenGate On Premises to replicate data to the Autonomous Database for: Real-time data warehousing: Replicate on-premises data to the Autonomous Database to set up a staging environment for downstream ETL or real-time data warehousing. Operational reporting: Replicate real-time data from multiple on-premises data sources and deliver to the Autonomous Database for creating reports.

What Is Oracle Data Redaction?

Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of the column. For example, columns of the NUMBER data type are redacted with a zero (0), and character data types are redacted with a single space. Partial redaction. You redact a portion of the column data. For example, you can redact a Social Security number with asterisks (*), except for the last 4 digits. Regular expressions. You can use regular expressions to look for patterns of data to redact. For example, you can use regular expressions to redact email addresses, which can have varying character lengths. It is designed for use with character data only. Random redaction. The redacted data presented to the querying application user appears as randomly generated values each time it is displayed, depending on the data type of the column. No redaction. The None redaction type option enables you to test the internal operation of your redaction policies, with no effect on the results of queries against tables with policies defined on them. You can use this option to test the redaction policy definitions before applying them to a production environment.