And select the client credentials zip file enter the service name

1. d) Users are given OS logons or SYSDBA privileges to prevent phishing attacking

Explanation

1. Flashback Database

2. Java in the Database

Lists the Oracle Database features that are not available in Autonomous Database. Additionally, database features designed for administration are not available.

List of Removed Oracle Features

Oracle R capabilities of Oracle Advanced Analytics

Oracle Industry Data Models

Oracle Multimedia

Java in DB

2. Mask your sensitive data

3. Patching the database

Question 4:

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.

SQL Developer is a free integrated development environment (IDE) provided by Oracle that simplifies the development and management of Oracle databases. A Java based platform, this IDE can run on Linux, Mac OS X, and Windows platforms. SQL Developer facilitates database migrations by providing options to use Oracle tools like Data Pump export, database copy, and SQL*Loader

Question 5:

4. Recovery Manager (RMAN)

Explanation

2. UPDATE_OBJECT_INFO

3. CREATE_BASELINE_TEMPLATE

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

1. a) Connecting to the Cloud Infrastructure Command console via SSH wallet. b) It cannot be done.

Question 8:

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?

5. ora

Explanation

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

1. TPPERFORMANT

Explanation

Predefined Database Service Names for Autonomous Transaction Processing

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

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

4. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Question 11:

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

Explanation

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

3. Data Pump

4. Original Import/Export tools

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

1. CREATE ATTRIBUTE DIMENSION

Explanation

The following system privileges allow the user to create, alter, or drop analytic view component objects.

CREATE ATTRIBUTE DIMENSION

Create an attribute dimension in the grantee's schema. CREATE ANY ATTRIBUTE DIMENSION

ALTER ANY ANALYTIC VIEW

Rename analytic views in any schema except SYS.

Drop analytic views in any schema except SYS.

DROP ANY ATTRIBUTE DIMENSION

Query or view any analytic view or hierarchy in any schema

Question 14:

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

Explanation

PUT_OBJECT Procedure

This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB). VALIDATE_EXTERNAL_TABLE Procedure

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?

Explanation

Autonomous Transaction Processing provides all of the performance of the marketleading 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, IoT, and JSON document store.

2. VALIDATE_LEVELS

3. VALIDATE_MEASURES

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

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?

Explanation tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.

Concurrent Statements in tpurgent: 100 × OCPUs

3. Golden Gate

4. Recovery Manager (RMAN)

Which three data dictionary views contain information about analytic view objects?

1. ALL_ANALYTIC_VIEW_PATHS

Explanation

- Analytic View Views

ALL_ANALYTIC_VIEW_COLUMNS

ALL_ANALYTIC_VIEW_DIM_CLASS

ALL_ANALYTIC_VIEW_LEVEL_CLASS

ALL_ANALYTIC_VIEW_LEVELS

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

1. Select the snapshot of the backup

Explanation

You can initiate recovery for your Autonomous database using the cloud console. Autonomous database automatically restores and recovers your database to the point-in-time you specify.

When the restore operation finishes your Autonomous Data Warehouse instance opens in readonly mode and the instance details page Lifecycle State shows Available Needs Attention.

At this point you can connect to your Autonomous Database instance and check your data to validate that the restore point you specified was correct.

1. SQL

2. JSON

Export a Notebook

You can export a notebook as a .json (JavaScript Object Notation) file, and later import it in to the same or a different environment.

Question 22:

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

Connection to Autonomous DB uses certificate authentication and Secure Sockets Layer (SSL). This ensures that there is no unauthorized access to Autonomous DB and that communications between the client and server are fully encrypted and cannot be intercepted or altered.

Certification authentication uses an encrypted key stored in a wallet on both the client (where the application is running) and the server (where your database service on the Autonomous DB is running). The key on the client must match the key on the server to make a connection

Question 23:

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

Explanation

Create the Autonomous Data Warehouse Connection in Oracle Analytics Cloud.

• Click Select next to Client Credentials. In File Upload, select the wallet zip file from your download location.

The Client Credentials field is populated with cwallet.sso, and the Service Name field contains a value.

Question 24:

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

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.

Question 26:

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

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

Question 27:

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

Explanation

Predefined Database Service Names for Autonomous Transaction Processing

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.

3. Active transactions are paused.

4. Active transactions continue running unaffected.

1. Autonomous Data Warehouse.

2. Neither service ignores hints by default

Question 30:

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

Explanation

All data is encrypted at rest using transparent data encryption, and data redaction is part of ADB.

3. An "INSERT" REST call

4. A "PUT" REST call

1. SCOTT

2. ADMIN