Autonomous 2022 Flashcards

1
Q

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with private endpoint? (Choose three.)

A

NSG, Subnet, VCN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

.You have been tasked with analyzing a year’s worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?

A

Business Models

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which two actions can be performed when an Autonomous Database is stopped? (Choose two.)

A

Start, License Type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which three are use cases for Graph Studio? (Choose three.)

A

Pattern, Clustering, 3-D Modelling

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

.Which three event types are supported for Autonomous Database? (Choose three.)

A

Terminate End, Maintenance Begin, Change Compartment Begin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

(CHK) You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

A

Create a rule for “Oracle Cloud Infrastructure Event” for “Autonomous Database Stop End”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

.In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?

A

Compartment Quotas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

.What happens with the standby database when disabling Autonomous Data Guard?

A

The Standby Database is Terminated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

.In which four ways can Oracle Database optimally access data in Object Storage? (Choose four.)

A

Optimize data archive using hybrid partitionend tables / optimize data archive using partitionend external tables / scan avoidance using partitioned external tables /scan avoidance using columnar prunning for columnar stores like parquet and orc

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

.Which statement is FALSE about Oracle Data Safe? (Choose two.)

A

It supports only Autonomous Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

.What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

A

Only ADW uses Columnar compression by default

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

.Which statement is FALSE about setting up compartment quotas?

A

compartment quota cannot be set on root compartment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

.Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A

The market OCI image can be used with an always free Autonomous Database Account.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

.You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism. Which Service will you need to connect to?

A

TPURGENT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

.What are the two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose two.)

A

Users are offered greater Control and isolation starting at the EXADATA Cloud infrastructure level / Users can customize the OS Level and add packages

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

.Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)

A

A NSG is required inside your virtual cloud network (VCN) before you can provision a shared autonomous database to use private endpoints / Private Endpoints can be created when cloning a shared autonomous database that was initially created with public endpoints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

.Which stage of the indexing pipeline divides text into tokens?

A

Lexer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

.Which set of options can be specified when defining the preferred maintenance schedule of the Exadata Infrastructure for Autonomous Database Dedicated?

A

Month of Quarter, Week of Month, Day of Week, Start hour

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

.You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?

A

The SQL Statement is queued

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

.Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

A

Catalog

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

.How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?

A

Execute “DBMS_Cloud_Admin_Grant_Tablespace_Quot (username => ‘MTHEO’, tablespace_quota = ‘UNLIMITED’)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

.Which option should you use to create a graph with Graph Studio?

A

Tables in the Autonomous Tablespace Instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

.Which method does NOT permit you to change the database ADMIN user’s password of an Oracle Autonomous Database on Shared Infrastructure?

A

OS command line from the database server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

.(CHK) Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three.)

A

Routinely tune your alarms / Select the correct alarm interval for your metrics / Select alarm through investigation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

.Where are customer-managed encryption keys stored for Autonomous Database on dedicated infrastructure?

A

In a separate key vault external to the EXADATA infrastructure

24
Q

.Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

A

Using Oracle zero downtime Migration (ZDM) / Using Data Pump / Using Golden Gate

25
Q

.(CHK) Which statement is FALSE about Oracle Autonomous JSON Database?

A

There is a 20GB limit on JSON collection

26
Q

.(CHK) Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose three.)

A

FIles in AWS S3 Storage / Oracle Cloud Storage / Local Files

27
Q

.Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?

A

Restore a database the ACL is not overwritten by the restore

28
Q

CHK) Which two statements are true about accessing Autonomous Database Tools? (Choose two.)
?

A

SQL Developer Web is exclusively availabgle on Autonomous Database / Oracle APEX can be accessed only from the developer menu in the service console.

29
Q

.(CHK) Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in oracle autonomous database?

A

RAC but only when only scaling beyond 16 OCPUs and Multitenand

30
Q

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

A

120 days

31
Q

.(CHK) Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared?

A

exec dbms_cloud_admin.enable_app_cont (‘<service_name>');</service_name>

32
Q

.Autonomous Database’s auto scaling feature allows your database to use up to three times the current base number of OCPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature?

A

The base number of OCPU’s is not garanteed

33
Q

.Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?

A

Aut. Exadata Infrastructure Instances and Aut. Container Databases have no dependent resources that move with them. Assocoated (non-dependent) resources remain in there current compartment.

34
Q

.Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

A

IOPS, Storage used by tablespace, apply and transport lag

35
Q

.Which three options do NOT change when enabling auto scaling? (Choose three.)

A

Amount of Storage, Parralelism settings, Level of concurrency

36
Q

.Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

A

Aut. Exadata Infrastructure; Aut. Backup; Aut. Container Database; Aut. Database

37
Q

.Which two statements are true about Data Insights? (Choose two.)

A

You can retrieve previous executed Data Insight searches; You can search for Data Insight against a base table or business model

38
Q

.Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?

A

Aut. Exadata Infrastructure Maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems update) and includes infrastructure database patching

39
Q

.Which three options are available to access data in an Autonomous JSON Database? (Choose three.)

A

Rest API calls to the database (not enabled by default); NoSQL Statement using SImple Oracle Document Access (SODA); Oracle Cloud Infrastructure console using the JSON Online Developer Tool

40
Q

.You need to create a new database via the oci cli with the following requirements: - Autonomous Transaction Processing - License Included - Shared Infrastructure Which Parameter you won’t use?

A

db-type

41
Q

.During the provisioning of an Autonomous Database on dedicated hardware, what should the database administrator select to determine where the Autonomous Database is created on the dedicated infrastructure?

A

The container database in which the Aut. Instance should run

42
Q

.Which two options are available for restoring an Autonomous Database? (Choose two.)

A

Specify the point in time (timestamp)to restore; Specify the archived custom image

43
Q

.A new Python developer has joined your team and needs to access the Autonomous Database data. How does the developer connect to and interact with the Autonomous Database from Python?

A

By using Oracle Client and the cx_oraole interface

44
Q

.Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

A

OCI Metrics; Performance Hub; Enterprise Manager Cloud control

45
Q

.Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure? (Choose two.)

A

Oracle Cloud Infrastructure Object Storage; Oracle Cloud Infrastructure Object Storage Classic

46
Q

.A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?

A

Increase the number of OCPUs allocated to the database

47
Q

.Which four file formats are supported when loading data from Cloud Storage?

A

AVRO, Parquet, JSON, CSV

48
Q

.Which is NOT needed to manage Oracle Autonomous Database with REST APIs?

A

Database Admin Password

49
Q

.Which of the following two statements are correct? (Choose two.)

A

ODI Web Addition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace; All Capabilities of ODI classics are available ODI Web Addition

50
Q

.A new business analyst has joined the team and would like to explore the Autonomous Database tables using Autonomous Database’s Data Tools. Which step should you to perform to enable the new team member?

A

Create a REST - enabled database user (with connect and object privileges) and grant the DWROLE role

51
Q

.Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?

A

PDBs can not be migrated to an Aut. Database using plug, unplug or clone

52
Q

.Which statement is correct about the Service console in an Autonomous Database?

A

Manage runaway SQL Statements on an Aut. Database

53
Q

.When cloning from a backup, what is the earliest timestamp of the backup allowed?

A

2 hours

54
Q

.Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose two.)

A

SQL*Plus ; SQL Developer

55
Q

.Which three advanced options can you enable or disable while creating a business model? (Choose three)

A

Analytic View Transparency View; Aut. Aggregat Cache; Analytic View Base Table Query Transformation

56
Q

.Which native data type is used to store spatial information?

A

SDO_Geometry

57
Q

.An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database. Other than changing the shared user password, what can an administrator do to protect the instance?

A

Rotate the instant wallet and share the new wallet with the remaining users

58
Q

.Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped. Which statement is true?

A

Standby database is also stopped