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
.Where are customer-managed encryption keys stored for Autonomous Database on dedicated infrastructure?
In a separate key vault external to the EXADATA infrastructure
.Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
Using Oracle zero downtime Migration (ZDM) / Using Data Pump / Using Golden Gate
.(CHK) Which statement is FALSE about Oracle Autonomous JSON Database?
There is a 20GB limit on JSON collection
.(CHK) Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose three.)
FIles in AWS S3 Storage / Oracle Cloud Storage / Local Files
.Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?
Restore a database the ACL is not overwritten by the restore
CHK) Which two statements are true about accessing Autonomous Database Tools? (Choose two.)
?
SQL Developer Web is exclusively availabgle on Autonomous Database / Oracle APEX can be accessed only from the developer menu in the service console.
.(CHK) Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in oracle autonomous database?
RAC but only when only scaling beyond 16 OCPUs and Multitenand
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?
120 days
.(CHK) Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared?
exec dbms_cloud_admin.enable_app_cont (‘<service_name>');</service_name>
.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?
The base number of OCPU’s is not garanteed
.Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?
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.
.Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
IOPS, Storage used by tablespace, apply and transport lag
.Which three options do NOT change when enabling auto scaling? (Choose three.)
Amount of Storage, Parralelism settings, Level of concurrency
.Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
Aut. Exadata Infrastructure; Aut. Backup; Aut. Container Database; Aut. Database
.Which two statements are true about Data Insights? (Choose two.)
You can retrieve previous executed Data Insight searches; You can search for Data Insight against a base table or business model
.Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
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
.Which three options are available to access data in an Autonomous JSON Database? (Choose three.)
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
.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?
db-type
.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?
The container database in which the Aut. Instance should run
.Which two options are available for restoring an Autonomous Database? (Choose two.)
Specify the point in time (timestamp)to restore; Specify the archived custom image
.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?
By using Oracle Client and the cx_oraole interface
.Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?
OCI Metrics; Performance Hub; Enterprise Manager Cloud control
.Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure? (Choose two.)
Oracle Cloud Infrastructure Object Storage; Oracle Cloud Infrastructure Object Storage Classic
.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?
Increase the number of OCPUs allocated to the database
.Which four file formats are supported when loading data from Cloud Storage?
AVRO, Parquet, JSON, CSV
.Which is NOT needed to manage Oracle Autonomous Database with REST APIs?
Database Admin Password
.Which of the following two statements are correct? (Choose two.)
ODI Web Addition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace; All Capabilities of ODI classics are available ODI Web Addition
.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?
Create a REST - enabled database user (with connect and object privileges) and grant the DWROLE role
.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?
PDBs can not be migrated to an Aut. Database using plug, unplug or clone
.Which statement is correct about the Service console in an Autonomous Database?
Manage runaway SQL Statements on an Aut. Database
.When cloning from a backup, what is the earliest timestamp of the backup allowed?
2 hours
.Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose two.)
SQL*Plus ; SQL Developer
.Which three advanced options can you enable or disable while creating a business model? (Choose three)
Analytic View Transparency View; Aut. Aggregat Cache; Analytic View Base Table Query Transformation
.Which native data type is used to store spatial information?
SDO_Geometry
.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?
Rotate the instant wallet and share the new wallet with the remaining users
.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?
Standby database is also stopped
