OCI 2022 Exam Study Questions
222 Questions with 100% Correct Answers
COMPLETE SOLUTION
What is the bronze policy for backups of block volumes? - ✔✔Monthly incremental backups run on the
first of the monthy and retai
...
OCI 2022 Exam Study Questions
222 Questions with 100% Correct Answers
COMPLETE SOLUTION
What is the bronze policy for backups of block volumes? - ✔✔Monthly incremental backups run on the
first of the monthy and retained for twelve months with a full backup yearly on January first
What is the silver policy for backups of block volumes? - ✔✔Weekly incremental backups that run on
Sunday and retained for four weeks + bronze policy
What is the gold policy for backups of block volumes? - ✔✔Daily incremental backuips retained for
seven days + silver policy
What information is contained in an instance configuration? - ✔✔OS image, metadata, shape, vNIC's,
Storage, AD, Subnet and compartment information. Similar to a launch template in AWS
What do I need to create an instance pool? - ✔✔Instance Configuration
What are some benefits of an instance pool? - ✔✔You can deploy uniform instances to different
availability domains, attach the instance config to a load balancer to provide scalability and manage
many as one including stop, start, terminate and update a large number of instance with a single
instance configuration change.
How can compute health, capacity and performance be monitored? - ✔✔Using metrics, alarms and
notifications.
How would you automatically adjust the number of compute instances in an instance pool? - ✔✔You
would use an autoscaling configuration.
How does an autoscaling configuration work? - ✔✔It allows you to automatically adjust the number of
compute instances based on performance metrics such as cpu and memory utilization.Need to add or reset ssh keys for the opc user how would you do this? - ✔✔Need to create and use a
console connection.
What do console connections allow you to do? - ✔✔Add or reset opc user ssh keys, edit system
configuation files, fix images that do not successfully boot, enter a non-responsive instance.
What are the two types of console connections? - ✔✔Serial and VNC console connections
Once connected through the serial console what's the process to get into the vm? - ✔✔Reboot the vm
from the console wait for the list of available boot images to load. Type e to edit the startup and add
init=/bin/bash to get a bash prompt on startup. So the changes take: /usr/sbin/load_policy -i Then
mount:
/bin/mount -o remount, rw /
then go to the opc user ssh dir and make changes and reboot
What's missing from console `$ ssh -o ProxyCommand='ssh -W %h:%p -p 443...` - ✔✔Need to specify the
ssh key at the begining of both ssh commands -i /
/
What are the required steps to get cost usage reports in your tenancy? - ✔✔In the root compartment
you must define two policies.
1 - define tenancy usage-report as
ocid1.tenancy.oc1..aaaaaaaaned4fpwkisbwwkr56u7gj63lf3wfyprpwknfwetvzub7fffqkggq
2 - endorse group to read objects in tenancy usage-report
When creating a custom image from a running instance what is not included? - ✔✔Data from attached
bloc volumes
When creating a custom image from a running instance what's the maximum size for an image? -
✔✔300 GB
What are the three import modes for images? - ✔✔Emulation, Para-virtualized, and Native modeOf the import modes what is Emulation mode and what are the pro's and con's? - ✔✔Fully emulated
NIC, block boot, legacy bios boot. Pro's: compatibility with wide range of older/custom OS. Con's: Low
Performance - 20% loess compared with Native mode
Of the import modes what is Para-virtualized mode and what are the pro's and con's? - ✔✔Current OCI
VM experience offering maximum performance with modern OS's. Pro's: Available for Oracle provided
VM's, smaller set of modern OS's only. Con's: Incompatible with wide range of older OS
Of the import modes what is Native mode and what are the pro's and con's? - ✔✔Balance between
performance and compatibility. Pro's: Support a wide range of older and new OS, minimal performance
gap between virtio and iSCSI. Con's: Has to work with virtIO driver
Can load balances cross regions? - ✔✔No
How does a virtual IP assist with HA? - ✔✔A compute instance can be assigned a secondary IP if that vm
has a problem the vip can be igrated to another vm in the same subnet to achieve instance failover
How do you set up IPsec VPN HA? - ✔✔DRG must have multiple VPN endpoints so that each IPSec VPN
connection consists of multiple redundant IPSec tunnels that use static routes to route traffic. To ensure
HA you must have two CPE's and allow the internal network to be able to use either path when needed.
How do you configure FastConnect HA? - ✔✔Need to set up more than 1 virtual circuit from the CPE to
the DRG
How is OCI storage built for HA? - ✔✔Object storage uses checksums to verify data integrity and corrupt
data is auto detected and healed from reduntant copies.
List the RPO and RTO for Backup and Restore. - ✔✔24 hour RPO and 24 hour RTO
List the RPO and RTO for Standby DR. - ✔✔12 RPO and 4 hour RTOList the RPO and RTO for Active / Active? - ✔✔< 2 hour RPO and 15 RTO
How do I connect two different regions to enable DR? - ✔✔Remote VCN peering
What filters are available for the cost analysis tool? - ✔✔start and end date, compartment, tag key and
tag value
How do budgets work? - ✔✔You can set alerts based on actual or forcasted spend as a percent of a set
budget number for an entire tenancy or specific compartment
What group must you be in to use budgets? - ✔✔Any group that can use usage-budgets
What are usage reports? - ✔✔CSV files that have one record per resource per hour with metadata and
tags. Automatically generated daily and stored in an oracle owned object storage bucket.
How long are usage reports stored for? - ✔✔One year and each report containes 24hrs of usage data
How do compartment quotas work? - ✔✔Allows you to allocate resources to projects or departments
using policy statements
What are the three policy statements used for Quota policies - ✔✔set - sets the maximum number of a
cloud resourrce that can be used for a compartment, unset - resets the quotas back to the default
service limits, zero - removed access to a cloud resource for a compartment
General format of quota policy statement? - ✔✔(set, unset, zero) quota (name,...) <~to~>
<~value~> in (conditions, ...)
What are some key capabilites of NVMe storage and what shapes is it available on? - ✔✔Up tp 51.8 TB
of local storage, 3 million IOPS, and less than 100 microsecond latency. DenseIO shapes have locally
attached NVMe devicesHow are NVMe device data protected? - ✔✔It is not there are no images, back ups or RAID configured
on NVMe devices data protection is the customers responsibility
What to do when an NVMe device fails? - ✔✔Start another instance with the same amount of storage
or more then copy data to the new instance and migrate over. Tools like rsync can copy the data over.
What are the minimum IOPS on smalled dense IO shape? - ✔✔200k on VM.DenseIO1.4 and 400k at 1.16
max 3M 2.52
What are key capabilities of Block Storage? - ✔✔Scalable 1PB and 650,000 IOPS per compute instance
and sla backed performance guarantees
What are the block storage characteristics? - ✔✔50gb to 32 tb volumes in 1GB increments and up to 32
volumes on each instance. Scheduled backups, cross-region backup copy for dr or workload migration
What are volume groups? - ✔✔These are structures for grouping together block and boot volumes from
multiple compartments across multiple compute instances, can have up to 32 volumes per group
What can you do with volume groups? - ✔✔Create backups and clones that are point in time and crash
resistant. You can manually trigger a full or incremental backup that's coordinated accross all volumes
Key features of volume group backups and restores? - ✔✔Online with no downtime and both take
seconds to complete
What is the OCI block volume service built on and how does performance scale? - ✔✔The service uses
NVMe based storage and is designed for consistency, performance scales linerarly per GB volume size
and IOPS performance is independent of isntance type or shape
Some block volume performance numbers... - ✔✔50GB 24MB/s throughput 3000 iops, 200GB 12000
iops, 500GB 25000 iopsWhat are the key capabilities of the file storage service? - ✔✔Exabyte scale, no need to provision pay
and scale as you go, easy snapshotting, NFSv3 support
List some file storage performance metrics - ✔✔1TB 100MB/s bandwidth and 2500 iops, 100TB 250,000
IOPS
Some file storage guidelines. - ✔✔Scales based on consumed capacity, performance increases with
parallelism and multiple mount targets, clients and systems should be in the same AD and for best
performance do not set mount point options
What are Autonomous serverless primary benefits? - ✔✔Fully managed service starting at 1ocpu and
1TB of storage, 1hr time commitment and grow or shrink on demand.
What are the benefits of Autonomous on dedicated hardware? - ✔✔Private database cloud, highest
isolation and control of provisioning, updates, availability and density
How are upgrades handled on serverless Autonomous? - ✔✔RAC on the exadata cloud infrastructure
provides for rolling upgrades and fast failover
What's the maximum number of Autonomous databases per ocpu? - ✔✔10 per ocpu
Maximum number of Autonomous container databases per cluster? - ✔✔4 per cluster
How is the AD selected for an Autonomous Serverless system? - ✔✔There is no Availability Domain
placement controls
How long must you subscribe for dedicated Autonomous? - ✔✔1 month minimum subscription
How do you create a test database in Dedicated Autonomous and can you have AD placement? -
✔✔Need to export to and import from object store and you do have AD placement controlHow does Dedicated Autonomous minimize application downtime? - ✔✔It uses Oracle Transparent
Application Continuity
What database features does ATP-D have? - ✔✔create tablespace, transparent application continuity,
database vault, profile, 19c, auto-indexing, documented rto/rpo, OCI notification service integration,
maintenance history reporting
What database features does ATP-D not have? - ✔✔clone support, auto-scaling
What database features does ATP-S have? - ✔✔Clone support, Application Continuity Only and 19c
preview and Auto-indexing preview only
What Autonomous service has VCN, Private IP, Azure Secure Connect? - ✔✔ATP-D
What Autonomous service has Backup Retention Configuration? - ✔✔ATP-D
How many tenants for ATP-D? - ✔✔Private single tenant IaaS
What can software controls do you get with ATP-D? - ✔✔Update versions and update schedules can be
controlled
What tools are available for ATP-D? - ✔✔sql dev - web / EM monitoring
Connection feature available to ATP-D? - ✔✔Non-TLS SQL * NET
Can you skip updates with ATP-S? - ✔✔No only dedicated has this along with RAC session co-location
tagging
What is the ATP-D resource for dedicated hardware resources? - ✔✔autonomous-exadatainfrastructuresWhat is the ATP-D IAM resource autonomous-container-database for? - ✔✔runtime environments that
meet specific SLA's
What is the ATP-D IAM resource for application databases? - ✔✔autonomous-databases
What is the ATP-D IAM resource for data archives? - ✔✔autonomous-backups
List details of ATP-D OLTP TPURGENT service. - ✔✔Default parallellism is manual, 12 shares of resources
and 100xCPU's concurrency before queuing
List details of ATP-D OLTP TP service. - ✔✔Default parallelism is 1, 8 shares of resources and 100xCPU's
before queuing
List details of ATP-D OLAP HIGH service. - ✔✔Default parallelism equal to the number of CPU's, 4
resource shares and concurrency of 3 before queuing
List details of ATP-D OLAP MEDIUM service. - ✔✔Default parallelism 4 and 2 resource shares with
concurrency of 1.25xCPU's before queuing
List details of ATP-D OLAP LOW service. - ✔✔Default parallelism 1 and 1 resource share with
concurrency of 100xCPU's before queuing
What's the best way to migrate to Autonomous? - ✔✔Have to use data pump, can't make an old car into
a self driving one have to move passengers into the self driving car. However, goldengate replication can
be used to keep databases online during migration
How can you load data pump data into Autonomous serverless? - ✔✔Put dumps in object storage then
you need to use DBMS_CLOUD package -> CREATE_CREDENTIAL then COPY_DATA. Can also be used for
small data files.How can you load data pump data into Autonomous dedicated? - ✔✔Use impdp/expdp directly,
DBMS_CLOUD is not available
Where is the dbcli binary located? - ✔✔/opt/oracle/dcs/bin/ and the path is included in the root users
environment
Where are teh dbcli command output logs stored? - ✔✔dcscli.log and dcs-agent.log are stored in
/opt/oracle/dcs/log
What is the general form of the dbcli command? - ✔✔dbcli command [parameters]
How do you update the dbcli and what db systems is it not included on? - ✔✔cliadm update-dbcli [-h] [-
j] and this command is not available on 2 node RAC DB systems
How do you clone with dbcli? - ✔✔dbcli clone-database
How do you create a db with dbcli? - ✔✔dbcli create-database
How do you delete a db with dbcli? - ✔✔dbcli delete-database
How do you describe a db with dbcli? - ✔✔dbcli describe-database
How do you list databases with dbcli? - ✔✔dbcli list-databases
How do you modify a db with dbcli? - ✔✔dbcli modify-database
How do you recover a db with dbcli? - ✔✔dbcli recover-database
How do you register a db with dbcli? - ✔✔dbcli register-databaseHow do you update a db with dbcli? - ✔✔dbcli update-database
List db home commands for dbcli - ✔✔dbcli: create-dbhome, describe-dbhome, delete-dbhome, listdbhomes, update-dbhomes
List db storage commands for dbcli - ✔✔dbcli: list-dbstorages, describe-dbstorage, create-dbstorage,
delete-dbstorage
List db backup commands for dbcli - ✔✔dbcli: create-backup, getstatus-backup, schedule-backup
How do you used dbcli to backup to object storage? - ✔✔dbcli create-objectstoreswift then create a
backup configuration with dbcli create-backupconfig and associate the backup configuration with the
database using dbcli update-database
What commands can be used to manage object stores with dbcli? - ✔✔dbcli: create-objectstoreswift,
describe-objectstoreswift, list-objectstoreswifts
What are the three major operations supported on OCI DBaS vm for dataguard? - ✔✔SetupDataguard
SwitchOver/Failover/Reinstate
DeleteStandbyDatabase
What's types of data guard standby's are created in OCI? - ✔✔physical standby's
How would you configure data guard system across regions or between on prem and OCI? -
✔✔DGMGRL
How would you configure data guard for minimal RPO and RTO - ✔✔RTO of seconds with automatic
failover when configured with Data Guard Fast-Start failover and RPO less than a second for Data Guard
with ASYNC transport or RPO zero for Data Guard in SYNC or FAR SYNC configurationsWhat transport type does the console support for data guard? - ✔✔Async only
What is the only protection mode supported for data gaurd in the console? - ✔✔Maximum performance
What are the four operational phases of zero downtime migration? - ✔✔Analysis and preparation,
migration, switch and finalize
