Examen 931

Which three benefits are offered by the Self-Securing capability of the AutoDatabase

Secure configuration with full database encryption.

Protection from external and malicious internal threats.

Automatic application of security updates onlines.

Protection from external security threats only.

Automatic application of security updates offline.

Sensitive data protection from privileged users.

Which predefined service is only applicable for the ATP Database ?

- TP
- MEDIUM
- URGEN
- CRITICAL
- HIGH

Which threee source files are valid for loading data using DBMBS_CLOUD.COPY_DATA in the Autonomous Database?

- SAN or NAS storage.
- Cloud block storage.
- Oracle object storage.
- Amazon S3 object storage
- Azure blob storage.

Which two can be used for troubleshooting the data load operation in the Autonomous Database?

- Log files accessible from file system.

- Load operations logged in *_load_operations dictionary.

- Load operation logged in file system.

- Log files only accessible as tables.

- Log and bad files accessible as tables.

Which metric shows the number of running SQL Statements during the selected interval in the Autonomous Database ?

- current SQL statements.
- top SQL statements.
- SQL statements
- queued statements
- running SQL statements

Which method can be used to connect to an Autonomous Database instance to create a database user?

- Autonomous Database Console as an Oracle Cloud user.

- SQL *Plus connection as a sysdba

- Oracle Enterprise Manager Cloud Control as a system user

- SQL Developer Web Console as an Admin user.

- SQL Developer connection as a dbadmin user

Which two statements are correct with respect to the Private Cloud setup in the Autonomous Database Dedicated deployment?

- 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.

- It is not necessary to create Compartments

- Half rack does not offer various shapes to choose from

Identify the correct policy for assigning Database Administrators to access Autonomous Database Dedicated resources.

- Allow group ADB-Admins to manage autonomous-database in tenancy where tarhet.workloadType='ADB.'

- Allow group ADB-Admins to manage-database in tenancy.

- Allow group ADB-Admins to manage autonomous-database in tenancy where tarhet.workloadType='ANY'

- Allow group ADB-Admins to manage autonomous-database in tenancy where tarhet.workloadType='ADB-D'

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

Which statement is true about the Security feature in the Oracle Autonomous Database?

- Certificate-based authentication uses an encrypted key stored in a wallet on the server.

- Database clients can only connect securely using the wallet.

- Database clients can connect securely using TLS/wallet.

- Some connections use certificate-based authentication and SSL.

Which three tools are bundled with the Autonomous Database ?

OCI console

SQL developer web

SQL developer

enterprise manager cloud control.

enterprise manager grid control

Which three can be accessed via the Service Console of the Autonomous Database?

database restore

scaling CPU

enable database security

disable transparent data encryption

manage Oracle ML users

Which three tasks are automatically performed by the Coracle Autonomous Database?

optimizing the workload

compressing historical data

backing up the database

patching the database

masking sensitive data

Which two statements are correct about Autonomous Database Backups ?

The retention period for backups is 30 days.

The Autonomous Database automatically performs recovery of point-in-time specified.

Manual backups are placed in ASM.

Manual backups are placed in the Cloud Object Storage bucket.

Point-in-time recovery cannot be initiated using the Cloud console manually.

Which three statements are true about the Autonomous Database OCI Integration ?

- It allows connectivity to object stores sunch as Amazon S3

- Its components incluide Oracle Machine Learning

Backups can be accessed like any other file on object store.

It offers unlimited accesss to the Autonomous Database for all OCI resources.

Autonmous Database is hosted in the availability domains.

Which file needs to be edited to enable a HTTP Proxy connection to an Autonomous Data Warehouse instance?

tnsnames.ora

sqlnet.ora

listener.ora

cwallet.sso

Which three selections are required for provisioning an Autonomous Database Service after login to the OCI Console?

compartment

availability domain

region

object storage

tenant

workload type

Which two services are applicable for both ATP and ADW Database?

HIGH
MEDIUM
CRITICAL
TP
URGENT

Which threee statements are true with respect to the new Database role in the Aunomous Database?

It requires a simple password.

DWROLE incluides all necessary privileges for a DW developer/user.

By default, the database password will not expire until 360 days.

ADWROLE includes all necessary privileges for a ADW developer/user.

ADBROLE includes all necessary privileges for a ADB developer/user.

Threre´s no need to specify anything except the password.

Which statement is true about the Auto Scaling feature while provisioning a Non-Free Tier Autonomous Database instance?

It needs to be explicitly enabled.

It is enabled by default.

It is not a supported feature

It cannot be disabled.

Which three can be considered as valid predefined service connection names?

DBNAME_CRITICAL
DBNAME_LOW
DBNAME_NONE
DBNAME_URGENT
DBNAME_HIGH
DBNAME_TP

Which migration approach is not supported for the Autonomous Database?

SQL developer migration workbench

datapump export/import
golden gate cloud service
golden gate on-premise installation
RMAN cross-platform backup and restore.

Which statement is true about effectively protecting customer data in the Oracle Autonomous Database?

Customers can identify data and mask it for user in production environments only.

It automatically identifies sensitive data and masks it for user in production environments only.

It automatically identifies sensitive data and masks it for user in development environments only.

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

Which is not a valid resource in the Autonomous Database Dedicated Deployment?

autonomous database

autonomous container infrastructure

autonomous exadata infrastructure

autonomous container database.

Which three are required to connect to the Autonomous Database instance from the SQL Developer?

Oracle cloud username and password

wallet file

database username and password

database unique name

database service name

Oracle cloud service name

What is the differentiating factor between Autonomous Transaction Processing and Autonomous Database Warehouse?

optimizing database workload

provisioning database

patching database

backing up database

securing database

Which three considerations are necessary for migrating to the Autonomous Database?

How small is the dataset to be exported?

Does the method support third-party database?

What is the output file format ?

Does the method support using Oracle and/or third-party Object Store?

How large is the datase to be imported?

Which two Security features are enabled by default in the Autonmous Database?

RMAN backups only

data pump export dump file

Oracle native network

cloud backups only

transparent data encryption

Which two valid ADB connectivity methods are used from a third-party software?

JDBC uses FastConnect only

SQL *Net uses SSL for encryption

.NET uses public internet only

ODBC uses SSL with public internet

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

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)
 
Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.

Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

Data Pump is faster to migrate database than using RMAN (= Recovery MANager).

Data Pump creates the tablespaces used by your Autonomous Database.

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

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

Backing up the database.
Mask your sensitive data.
Patching the database.
Automatically optimize the workload.

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

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

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.

The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

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.

Which of these database features is NOT part of the Autonomous Database?

Online Indexing
Flashback Database
Real Application Clusters (RAC)
Java in the Database

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

Data Sync can connect to any JDBC compatible source like MongoDB, RedShift and Sybase.

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

Data Sync can load your data in parallel in order to speed up the loading process.

Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

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

In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.

The Oracle Client Credential file is downloaded as a ZIP file.

The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.

You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

¿Qué dos diferencias hay en cuanto a optimización entre ATP y ADW?

Undo Manage
Memory usage
Data format
Index storage
Backup

Which is the default port number for ADW and ATP?

1521
1522
1523
1524
1525
1526

Which three data dictionary views contain information about analylic view objects?
 
ALL_ANALYTIC_VIEW_PATHS

ALL_ANALYTIC_VIEW_DIM_CLASS

ALL_ANALYTIC_VIEW_ID_ATTRS

ALL_ANALYTIC_VIEW_LVLGRPS

ALL_ANALYTIC_VIEW_KEYS

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

Which two activities are performed by Fleet administrator ?

Provisions Exadata Infrastructure

Provisions Container Databases

Provisions new Autonomous Database

Creates users in the Autonomous Databases

Backup Autonomous Databases

Wich two are used to secure a connection to the Aunomous Database Shared Infra ?

Certificate Authentication and SSL

TDE Wallet

Client Credentials Wallet

Connections are done using plain Oracle Net Protocol

A user working on Autonomous Database stops the Database for a day but finds out that he has been charged for the Dabase even in stopped state.

What could be the reason?

User has been incorrectly charged and should contact Oracle support

User has been charged for the CPU as the database was not terminated

User has been charged for the CPU and storage as the database was not terminated

User has been charged for the storage as the database was not terminated

Which cannot be gathered form the web-based monitoring console?

Queued SQL statements in each consumer group

SQL statements executed per sec

SQL queries failed in last 24 hours

Average number of session in the database using CPU

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?

18.1 onwards
Any version
17.4 onwards
12c Release 2 onwards

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

Using Database Configuration Assistant (DBCA) on the database server.

It cannot be done

Connecting to the Cloud Infrastructure Command console via SSH wallet

Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

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

The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully

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

What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

ADBDEV

ADMIN

DWROLE

ADWC

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

Backups

Firmware Patching

Data Loading

Database Upgrades

Application User Creation

Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)

Data is encrypted at rest using transparent data encryption

Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.

Users are given OS logons or SYSDBA privileges to prevent phishing attacking

Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors

When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

TNSNAMES.ORA

CWALLET.SSO

OJDBC.PROPERTIES

SQLNET.ORA

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

An OCI 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

A single fault domain can be associated with multiple regions and availability domains

Regions are dependent on other regions and must be located with 5 thousand kilometers of each other

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?

Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster

ADW since operational reporting is a higher priority in this scenario

It is best to build a separate data warehouse, and move the OLTP data on a nightly basis

ATP. Using 'tpurgent' and 'high' TNS services to separate connection types

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?

The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.

The migration can be a success, both technically and functional due to datapump enhancements

The migration can be technically a success but the 3-rd party vendor needs to support the result

The tablespace names will result in a blocking error during datapump import because of ADB limitation

What are two security features enabled by default by the Autonomous Database?

One SYSDBA account
SQL Net Encryption
Read Only access to OS Audit logs
Transparent Data Encryption
Encrypted Database Links

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

The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database

Place the credential files on a share drive that all users can use to connect to the database

When you share the credential files with authorized users, mail the wallet password and the file in the same email

Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database

Which statement about the Export Wizard used to export database objects and data is NOT correct?

If “Dependents” is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported

Export DDL includes features such as “Show schema,” “Storage,” and “Terminator.”

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

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

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import. Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps

SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage

SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running

SQL Developer can only export/move/import files using datapump from databases running on Linux systems

You can run SQL Developer from the console

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?

Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB

Only the migration to ADB is possible from an on-premise installation of Golden Gate

The described scenario is correct, can be used for migration and fallback scenarios

Golden Gate on premise Is not certified with ADB because Golden Gate Cloud Service exists for this

The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB

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?

In Autonomous Data Warehouse direct access to the database node and the local file system is allowed

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

Adding, removing, or modifying tablespaces is allowed

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

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

RMAN Restore
SQL*Loader
Oracle GoldenGate
Transportable Tablespace
Oracle Data Pump

What REST verb is used to create an Autonomous Database service using REST APIs?
A “POST” REST call
An “INSERT” REST call
A “GET” REST call
A “PUT” REST call

Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

User with DWROLE can still access the database

Tools are no longer able to connect to a stopped instance

CPU billing is halted based on full-hour cycles of usage

In-flight transactions and queries are stopped

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database?
Data Pump
CSV files copied to Autonomous Database block storage
Golden Gate
Recovery Manager (RMAN)

Given the steps:

Create Oracle Machine Learning User
Create projects
Create workspaces
Create Notebooks
Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning?

Create projects
Create workspaces
Run SQL Scripts
Create Oracle Machine Learning User
Create Notebook

When loading data, which DBMS_CLOUD procedures are used?

COPY_DATA
CREATE_EXTERNAL_TABLE
GET_DATA
CREATE TABLE AS SELECT

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?

High provides highest concurrency and lowest resources, and DoP is i.

Medium provides intermediate resource and concurrency, and queries run in a serial.

High provides highest resources, lowest concurrency, and DoP is 1.

Low provides highest concurrency, lowest resources, and DoP =1.

Which can be Scaled independently of the number of CPUs in an Autonomous Database?

Storage
Memory
Parallelism
Concurency
Sessions

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure? A.

Terraform
REST API
Dlocker
Enterprise Manager

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

In the TEST phase of the wizard, a subset of accepted records are displayed based on your definition

In the TEST phase of the wizard a list is generated containing the records that would be rejected during import

In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table

In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition

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

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

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

through SQLPIus
using DBMS_CLOUD_ADMIN package
through the Oracle Cloud Infrastructure service console
through SQL/Developer

How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

Two. They are called ATP and ADW.
None. There are no pre-defined service names in tnsnames.ora.
Three. They are called high, medium and low
Five. They are called tpurgent, tp, high, medium and low.

What elements do you take with you when importing into Data Pump?

Data
Tablespaces
Schema

How should the customer unplug their database to migrate to Autonomous Database (ADB)?


Create a database link from source database to the ADB environment and clone the PDB

Pluggable databases cannot be migrated to ADB using plug, unplug or clone

Unplug to an xml file so database files and xml file can be uploaded to object storage

Unplug into a pdb archive which can be uploaded to object storage

Which is correct about security features that are available in Oracle Autonomous Database?

Data Redaction but not TDE
TDE but not Data Redaction
Neither Data Redaction nor TDE are supporte
Data Redaction and TDE are both supported

Which is NOT required to connect to Autonomous Database from SQL developer?

Username and password
Database name
Service name
Wallet file

What two methods can you use to define Machine Learning Users?

SQL/Developer
Use DBMS_CLOUD_ADMIN package
Oracle Cloud Infrastructure Console
Client tools

Which statement is true in regards to database links?

Create a database link from one Autonomous Database to another Autonomous Database instance

Connect from Autonomous Database to remote database using a database link

You can call PL/SQL procedures and functions using a database lin

Connect to Autonomous Database from remote database using a database link

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?

Start, Delete, Update, Query, Stop
Create, Get, List, Stop, Restore
Create, Query, Update, List, Start
Create, Query, List, Stop, Restore

On what infrastructure is ADB running:

Bar-metal
Exadata
Oracle Linux

What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?

DWDEV
SCOTT
ADMIN
SYS

Which operating system can Data Visualization Desktop be run on?

AIX
Windows
Linux
Solaris

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

RMAN backup & restore
Physical migration method like database cloning
Original Import/Export tools
Data Pump

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

Autonomous Data Warehouse workloads are optimized for mixed workloads

Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations

Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake

Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format Is columnar

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

Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet)

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

Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials

Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet

Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

Active transactions are terminated and rolled back.

Scaling cannot happen while there are active transactions in the database.

Active transactions continue running unaffected.

Active transactions are paused.

When exporting a notebook, what type of file is created?

XML
TXT
JSON
SQL
SCII

Which two system privileges does a user need to create analytic views?

CREATE ANALYTIC LEVEL
CREATE ANALYTIC HIERARCHY
CREATE ANALYTIC VIEW
CREATE ATTRIBUTE DIMENSION
CREATE ANALYTIC MEASURE

Which two options are available to restore an Autonomous Data Warehouse?

Backup and recovery must be done using Recovery Manager(RMAN).

Select the snapshot of the backup

Specify the point in time (timestamp) to restore

Select the backup from which restore needs to be done

Select the archived redo logs.

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

Replicate the table using Golden Gate
Load data using Data Pump
Import Table
Create a Data Set

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?

Data Sync can load a combination of data source, such as xsv, .xlsx and Oracle relational files

Data Sync can only load data from one source into one destination table

Data Sync can only load files into tables (insert-only), the customer has to write the additional code

Data Sync can not transform your data while loading it into the destination table

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?

MEDIUM
HIGH
TP
TPURGENT

Which two PL/SQL functions can be used to validate an analytic view?

VALIDATE_LEVELS

VALIDATE_ANALYTIC_VIEW

VALIDATE_MEASURES

VALIDATE_HIERARCHY

VALIDATE_DIMENSION

Can you validate the data for analytic view and hierarchy objects with the following procedures in the DBMS_HIERARCHY package. Four options

CREATE_VALIDATE_LOG_TABLE procedure

VALIDATE DBMS_HIERARCHY IN REST

VALIDATE_ANALYTIC_VIEW function

CREATE CREDENTIAL VALIDATE

VALIDATE_CHECK_SUCCESS function

VALIDATE_HIERARCHY function

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

30 days
7 days
One Year
60 days
90 days

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

On the Autonomous Database Console.

SSH keys cannot be added from console. They have to be added using REST APIs only.

Navigate to Identity, select Users panel on the console and select “Add Public Key”.

SSH keys are not required In Oracle Cloud Infrastructure

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

Autonomous Transaction Processing
Neither service ignores hints by default
Both services ignore hints by default
Autonomous Data Warehouse

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

TPPERFORMANT
LOW
MEDIUM
HIGH
TPURGENT

Depending on your JDBC or UCP connections are set up, you will need to do some of the following.

You will need JDK 8 or higher, specifically the JDK8u161 or higher, installed.

Also, there are specific JAR files needed to be in place.

If you're using JDBC Thin Driver 12.2.0.1 ojdbc8.jar, then you will need the 12.2.0 upc.jar.

If you're using the patched JDBC Thin Driver 12.1.0.2 ojdbc7.jar, then you will need the 12.1.0.2 upc.jar.

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

Creating and scaling of Autonomous Database service

Autonomous Databases monitoring for usage and query performance

Wizard to download connection wallet for connection from desktop tools.

Creating schemas