lOMoARcPSD|22745437

Oracle Cloud DBA - OCP 2021 [1Z0-1093-21]

1z0-997-20 OCI professional Incomplete (Somali International University)

Studocu is not sponsored or endorsed by any college or university

Downloaded by Long Ph?m ([email protected])
Oracle Database Cloud Administrator 2021 Certified Professional
Certification

Provision and connect to MySQL Database

2. You are asked to create a MySQL Database' Service system. You can log in to the
group's Oracle Cloud Infrastructure tenancy and access the assigpedicompartment,
and all policies have been configured and tested.

What is the next step to create a MySQL Database Service?

Create a Virtual Cloud Network by using the VCN wizard.

Create a VM Cloud Service and the components needed (options

networking/shapesiexpansionietm Automatic Storage Management (ASM) and Logical Volume
Manager (LVM)

15. While using virtual machines (VMS), the next step after selecting a shape for the DB system
is to select storage options and configuration.

Which TWO configurations can be selected and

used? (Choose all correct answers)

 Use Automatic Storage Management (ASM) for the storage management software.
 Configure storage to assign 40% to DATA and the rest to redo logs and archive logs.

Explain connecting to the NoSQL Database Cloud Service

18. What Information is required to connect to the NoSQL Database Cloud Service?

Signing key fingerprint, API signing key, tenancy OCID

Describe Backup and Recovery (backup destinations, backup options, recovery options)

27. You enable automatic backup on your Exadata Cloud@Customer.

Which type of file is NOT backed up by default and is the customer’s responsibility to back up?

Server parameter file (SP file)

Manage the Database VM Cloud Service Lifecycle (Expansion/Scaling/state/patching infra/GI)

7. Which TWO statements are true about changing the shape of a virtual machine (VM)
database (DB) Mark to system to adapt to changes in performance needs?

(Choose all correct answers)

 After you provision a VM DB system, you cannot change the shape. You 'have
to provision another VM DB system using a full backup.

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
 It is possible to change the shape of a VM DB system' with a Higher number
OCPUs. However, reducing the number of OCPUs is not permitted.

Provision and connect to MySQL Database

3. You want to connect to your MySQL DB system's endpoint. You create an Oracle Linux
compute instance on the same Virtual Cloud Network as your MySQL DB system.

Which TWO actions must you perform to connect to your MySQL Database Service

system? (Choose aft correct answers)

 Install the MySQL client on your local computer.

 Connect to your database system by using the MySQL client on the Linux compute
instance.

Explain Patch and upgrade (CLI and UI options, operations; analyze, apply and switchback, manual
patching)

4. Which is NOT a prerequisite for patching Grid Infrastructure or database homes when
using the console?

Oracle Clusterware is down on the VM cluster.

Explain the VM Cloud Service Architecture (Compute/Storage/Networking/Interconnects/ support

database editions and versions)

36. When configuring connectivity for hosts in the VCN, security lists contain defaults for
implementing security rules.

Which TWO additional rules are needed for database

systems? (Choose all correct answers)

 allows SSH traffic from anywhere

 allows SQLNET traffic from within the VCN

Explain the Database Lifecycle management (patching/homes/move/backup/restore) (old 6.1, 9.1

11)

16. In addition to the automatic backup of your Oracle Database associated with a database
deployment, you are planning to take an on-demand backup of a database on Exadata Cloud
Service.

How do you do this?

Use the Create Backup button in the backup section of the Database, Details

page. Explain table security management

5. What permissions do you need to perform actions, on a NoSQL table?

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

Create WI Clusters (pre-requisites and policies, create/edit VM cluster, OCPU scaling)

1. You want to move an Exadata Cloud@Customer VM cluster to a different OCT

compartment for increased isolation from other teams that use Exadata.

What happens when you use the console to do this?

The VM cluster, compute nodes, and associated database will move compartments. All other
resources will remain in the existing compartment.

Manage the Database VM Cloud Service Lifecycle (Expansion/Scaling/state/patching infra/GI)

6. After you have provisioned a virtual machine (VM), database (DB) system, what action can you take

to Meet changes in block storage requirements?

If a VM DB system requires more block storage, increase the storage at any time without impacting
the system.

Monitor MySQL Database

19. You are asked to measure useful quantitative data about a MySQL Database Service system
you must provide information such as current connection information, statement activity, latency,
and host OCPU, memory, and disk I/O utilization.

Which THREE Oracle Cloud Infrastructure monitoring methods should you

use? (Choose all correct answers)

 alarms
 metrics
 notifications

Describe the Exadata Cloud Service command-line interface (ExaCLI, dbaascli, OCI CLI)

26. You have been brought in to help a company with slow nightly batch processing running on their
Exadata Cloud Service. You have determined the workload is CPU-bound during the batch window.

Which command line tool can be used to script increase or decrease OCPUs?

OCI CLI

Describe Backup and Recovery (backup destinations, backup options, recovery options)

28. When you created your development database on Exadata Cloud@Customer, you selected

"None" for Backup location during provisioning. You now need to enable automatic backups on the

development

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
Database with a retention period of 45

days. Which action should you perform?

No action can be taken, because a new backup location cannot be set after creation.

Create a VM Cloud Service and the components needed (options/networking/shapes/expansion/et

Automatic Storage Management (ASM) and Logical 'Volume Manager (LVM)

14. In a two-node Real Applications Cluster environment, the Internet and VCN Resolver are
supported for DNS in the DB system.

Which TWO tasks are required for the network

setup? (Choose all correct answers)

 When creating the database, specify a value in the, Hostname, Prefix.

 Select "Use DNS Hostnames in this VCN" as the VCN is being created.

Explain the Exadata Cloud Service (Architecture/ database editions and versions)

25. What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud

Service? (Choose all correct answers)

 For triple mirroring of data

 For high availability

Create and manage Oracle Homes (OH): pre-requisites and policies, OH versions and options (shared/non-
shared), create and manage dbs, db connections/monitoring

46. Your company's security policy requires you to patch the database within a month of a relevant
database patch being released by Oracle.

Which method requires the least amount of down time?

Create a new database home, patch it to the version you want, and then move the database to the
new home.

Explain the VM Cloud Service Architecture (Compute/Storage/Networking/Interconnects/ sup database

editions and versions)

37. Resources are allocated to the DB system based on the shape selected. Which TWO are
options for a DB system? (Choose all correct answers)

 One-node bare metal server with up to 52 OCPU cores and locally attached drives to the
system
 Two-node virtual machine X7 with Block Storage which can be scaled up

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
Describe NoSQL data models

38. Which set of data types is supported by the NoSQL Database Cloud Service tables?

enum, map, record

Explain Exadata Cloud Service and the components needed (options

networking/shapes/expansion)

12. Which system configuration is offered by the Oracle Database Exadata Cloud Service?

Each system configuration starts with a fixed amount of OCPU, memory, storage, and network

resources. Oracle Cloud Database Services

32. You want to scale within Exadata System. Which of the following two statements are true?

 Modifying the number of enabled OCPU cores requires database downtime.

 The setting of database parameter CPU_COUNT is affected by modifying the number of
OCPU cores.

Oracle Cloud Database Services

30. You can manage and monitor performance of an autonomous database running on
autonomous Exadata Cloud@Customer using the Performance Hub.

Which two actions can be undertaken by Performance

Hub? (Choose all correct answers)

 View ASH Analytics

 Kill a running SQL

session Create, manage and use

Heatwave

52. You want to permanently delete the DB System and its attached Heatwave cluster. Which action
should you perform?

Delete the DB system and it will also delete the attached HeatVVave

Cluster. Explain monitoring options with Exadata Cloud Service

24. Which tool can be used to monitor a storage server in Exadata Cloud Service?

exacli

Configure Maximum Availability Architecture (01AA) and Data Guard for Exadata Cloud Service

13. In Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is the
minimum egress requirement needed to enable Data Guard between Exadata Cloud
Services?

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
TCP traffic only for port

1521 Oracle Cloud Database

Services

33. Patching requires role permissions. However, since roles are not granted by default, which role
needs to be added to someone patching the DB system?

Let database admins manage DB systems.

Monitor Bare Metal and Virtual Machine (BM/VM) DB Systems

39. You are considering whether or not to implement bare metal or virtual machine shapes.

Which TWO statements are true about bare metal ‘and virtual machine (VM) database (DB)
systems?

(Choose all correct answers)

 The console, API, and Oracle Cloud Infrastructure CLI are options for managing bare
metal DB systems.
 Bare metal shapes determine the total raw storage allocated to bare metal DB systems.

Manage the Exadata Cloud Service Lifecycle (Expansion/Scaling/state/patching infra/GI)

8. Which TWO statements are true about Interface for Exadata I/O Resource Management

(IORM)? (Choose correct answers)

 IORM can be enabled across multiple databases using the Cloud interface of Exadata
Cloud Service.
 IORM allows workloads and databases to share I/O resources automatically according to
admin- defined policies.

Describe NoSQL language SDKs

10. What NoSQL Database Cloud Service AM statement, can be used to adjust table capacity?

Table Request

Describe Backup and Recovery (backup destinations, backup options, recovery options)

28. When you created your development database on Exadata Cloud@Customer, you selected
"None" for backup location during provisioning.

You now need to enable automatic backups on the development database with a retention period of
45 days.

Which action should you perform?

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
No action can be taken, because a new backup location cannot be set after creation.

Oracle Cloud Database Services

31. Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud
Service environment?

exacli

Describe the Oracle Cloud Platform for Database in the Cloud

22_ Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)?

(Choose all correct answers)

 Local Storage
 Block Storage
 Object Storage
 File Storage

Explain monitoring options with Exadata Cloud Service

23. What can you use to enable an on-premises Enterprise Manager instance to monitor Exadata
Cloud Service in a private OCI subnet?

FastConnect

Explain provisioned throughput for NoSQL Database Service

40. Which characteristic is NOT a factor that Impacts the capacity units for provisioning a NoSQL
Database Cloud Service table?

durability level

Configure/ Deploy Maximum Availability Architecture (MAA) and Data Guard for DB Systems

45. How many DB systems must you provision before, you can enable Oracle Data Guard for a virtual
machine DB system database?

One with the primary database, because! a new DB system with the standby database is created and
associated with the primary database when you enable Oracle Data Guard.

11. How many IP addresses do you need at a minimum for the client subnet when you plan to have
four Exadata compute nodes on Exadata Cloud Service?

18

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
Explain the VM Cloud Service Architecture (Compute/Storage/Networking/Interconnects/ sup database
editions and versions)

36. When configuring connectivity for hosts in the VCN, security lists contain defaults for implementing
security rules.

Which TWO additional rules are needed for database

systems? (Choose all correct answers)

No answers, required research on this

Set up Backup for MySQL Database Service

29. Your MySQL Database Service system is automatically backed up between midnight and 1 AM.
What must you do to change the starting time to 4 AM?

From the Edit MySQL DB System Details page, select Backup Window and set the start time to 4
AM

Create and manage Oracle Homes (OH): pre-requisites and policies, OH versions and options (shared/non-
shared), create and manage dbs, db connections/monitoring

47. The /u02 directory containing Oracle Homes (OH) is 80% utilized and you need to free up
space in it. You own two Oracle Homes (OH193_A and OH193_B), each with a test database
(193A and 1938 respectively). You decide to consolidate both databases into a single Oracle
Home (0H193_A) to free up space.

Which TWO actions must you

perform? (Choose all correct

answers)

 Schedule a downtime window with the Test teams who use the 193B database.
 Use the Move Database option from the console.

Describe the Oracle Cloud Infrastructure Strategy (OCI)

35. Which THREE Oracle Cloud Infrastructure (OCI) services can be used to connect to on-
premises network?

(Choose all correct answers)

 Dynamic Routing Gateway (DRG)

 IPsec VPN
 FastConnect

Oracle Cloud Database Services

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
34. Which three statements are true regarding MySQL Database Service

Heatwave? (Choose ail correct answers)

 Heatwave is Exdusively available in Oracle Cloud Infrastructure.

 Heatwave is a In-memory, query-processing, engine designed for, fast execution of
analytic queries
 Heatwave uses machine learning to automate operations, increasing DBA productivity
and reducing costs

Manage the Exadata Cloud Service Lifecycle (Expansion/Scaling/state/patching infra/GI)

9. You used the "Stop" option from the Console of an Exadata Cloud Service virtual machine within a
VM cluster.

What impact does this have?

The stopped virtual machine is not available to any other database

deployment. Describe the Oracle Cloud Platform for Database yin the

Cloud

21. Which are THREE strategies to migrate Oracle Database to Oracle Cloud Infrastructure

(OCI)? (Choose all correct answers)

 Golden Gate
 Zero Downtime Migration (ZDM)
 Migration workbench

Explain connecting to the NoSQL Database Cloud Service

17. Which statement is FALSE about using compartments?

They are a physical concept that separates users.

Configure/Deploy Maximum Availability Architecture (MAA) and Data Guard for DB Systems

44. Which THREE actions can you perform on a DB system that has an Oracle Data Guard
association with a standby database?

(Choose all correct answers)

If the primary database becomes unavailable, then you can use Oracle Data Guard to fail over the
standby database

You can use the reinstate command to return a failed database into standby role after correcting the
cause of failure.

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
 You can switch over the primary database to the standby role, perform maintenance on
the standby database, and then switch it back to the primary role.

Describe the MySQL Database Service

42. Which THREE are prerequisites for using the MySQL Database

Service? (Choose all correct answers)

 You must create a tenancy and be able to sign in' to it.

 You or your group must be granted the policies, described in Mandatory Policies
 You must create a compartment to store your resources

Manage the Database VM Cloud Service Lifecycle (Expansion/Scaling/state/patching infra/GI)

7. Which TWO statements are true about changing the shape of a virtual machine (VM) database

(DB) System to adapt to changes in performance needs?

No answers

Explain the deployment of Autonomous Database on ExaCC (Autonomous clusters, Autonomous container
databases, Autonomous pluggable databases)

48. Assume that there are no resource limits on your underlying Exadata Cloud@Customer hardware.

What is the maximum number of Autonomous container databases that can be created on one
Autonomous VM cluster?

12

43. You define a maintenance window for your MySQL DB systems. When the automatic

maintenance Process takes place, which TWO activities does the system perform while its status

is set to UPDATING? (Choose all correct answers)

 It patches the underlying operating system, of the 'MySQL database.

 It patches the MySQL server itself along with any underlying hardware.

20. You notice that throttling is occurring on your NoSQL Database Cloud Service. What
must you increase to Mack for Re solve this?

 OCPU for all servers in the cluster

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
49. Which TWO statements are true when enabling', autonomous Data Guard on Autonomous
Exadata Cloud Customer?

(Choose all correct answers)

 When in a Data Guard configuration patching `wilt ,alWayS take place on the standby
database first.
 Autonomous databases inherit their Data, Guard configuration from their Autonomous
Container Database.

50. Which two circumstances are FALSE when you Use the Console to recover a DB system
database from a backup stored in Oracle Cloud Infrastructure Object, Storage?

(Choose all correct answers)

 The DB system has no access to the Oracle, Cloud Infrastructure Object Storage service
location where the backup is stored.
 Restore the database from an unmanaged backup' in Object Storage, created directly by
using RMAN.

41. Which service is used by default by the MySQL Database Service to store user data to make it
more resistant to failures?

OCI Block Volumes

51. Which statement is true about moving virtual machine (VM) database (DB) systems from
one compartment to another?

You can move DB systems to a different compartment if you have sufficient access permissions to the
compartment that the resource is being moved to as well as the current compartment.

53. Which TWO statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to
register an Exadata Cloud Customer infrastructure in?

(thoese all correct answers)

No Answer

1. You want to move an Exadata Cloud@Customer VM cluster to a different OCT

compartment for isolation from other teams that use Exadata.

Downloaded by Long Ph?m

Oracle Database Cloud Administrator 2021 Certified Professional
Certification
The VM Cluster, compute nodes, and associated databases will move compartments. All other
resources will remain in the existing compartment.

54. Which network is used to facilitate the secure monitoring, and administration of Oracle-managed
infrastructure components in Exadata Cloud©Customer?

Cloud operations network

53. Which TWO statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to
reoister an Exadata Cloud@Custorner infrastructure in? „.

(Choose all correct answers)

Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure

is not registered in an OCI region.

55. What THREE steps must you perform to connect to a MySQL database in the database
system by using SSH and MySQL Shell?

(Choose all correct answers)

 Connect to the MySQL Database Service instance

 SSH onto the compute instance from your local machine.
 Add an ingress rule for port 20

Downloaded by Long Ph?m