Autonomous 2022 Flashcards
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with private endpoint? (Choose three.)
NSG, Subnet, VCN
.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?
Business Models
Which two actions can be performed when an Autonomous Database is stopped? (Choose two.)
Start, License Type
Which three are use cases for Graph Studio? (Choose three.)
Pattern, Clustering, 3-D Modelling
.Which three event types are supported for Autonomous Database? (Choose three.)
Terminate End, Maintenance Begin, Change Compartment Begin
(CHK) You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
Create a rule for “Oracle Cloud Infrastructure Event” for “Autonomous Database Stop End”
.In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?
Compartment Quotas
.What happens with the standby database when disabling Autonomous Data Guard?
The Standby Database is Terminated
.In which four ways can Oracle Database optimally access data in Object Storage? (Choose four.)
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
.Which statement is FALSE about Oracle Data Safe? (Choose two.)
It supports only Autonomous Databases
.What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?
Only ADW uses Columnar compression by default
.Which statement is FALSE about setting up compartment quotas?
compartment quota cannot be set on root compartment
.Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
The market OCI image can be used with an always free Autonomous Database Account.
.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?
TPURGENT
.What are the two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose two.)
Users are offered greater Control and isolation starting at the EXADATA Cloud infrastructure level / Users can customize the OS Level and add packages
.Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)
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
.Which stage of the indexing pipeline divides text into tokens?
Lexer
.Which set of options can be specified when defining the preferred maintenance schedule of the Exadata Infrastructure for Autonomous Database Dedicated?
Month of Quarter, Week of Month, Day of Week, Start hour
.You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?
The SQL Statement is queued
.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?
Catalog
.How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?
Execute “DBMS_Cloud_Admin_Grant_Tablespace_Quot (username => ‘MTHEO’, tablespace_quota = ‘UNLIMITED’)
.Which option should you use to create a graph with Graph Studio?
Tables in the Autonomous Tablespace Instance
.Which method does NOT permit you to change the database ADMIN user’s password of an Oracle Autonomous Database on Shared Infrastructure?
OS command line from the database server
.(CHK) Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three.)
Routinely tune your alarms / Select the correct alarm interval for your metrics / Select alarm through investigation