1z0-1093-22 Questions Pass on Your First Attempt Dumps for Database Cloud Service Certified [Q14-Q31]

admin 1z0-1093-22 Oracle August 16, 2022

Rate this post

1z0-1093-22 Questions Pass on Your First Attempt Dumps for Database Cloud Service Certified

1z0-1093-22 Practice Test Pdf Exam Material

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

File Storage

Data safe

Block Volumes

Object storage

Q15. What information is required to connect to the NoSQL Database Cloud Service?

API signing key, admin ID, user ID

signing key fingerprint, API signing key, tenancy OCID

user ID, tenancy ID, component ID

tenancy 1D, passphrase, handshake key

Q16. 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 MySQL server itself along with any underlying hardware.

It analyzes, rebuilds, and optimizes MySQL database tables and indexes.

It patches the underlying operating system of the MySQL database.

It upgrades the associated compute instance to the latest Linux operating system version.

Q17. 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?

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

Change the database backup location to local storage backups and set retention to 45 days.

Change the database backup location to an NFS backup location with a 45-day retention period set.

Change the database backup location to Object Storage with the default retention period set.

Q18. 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 must download the latest MySQL version from https://edelivery.oracle.com/.

You or your group must be granted the policies described in Mandatory Policies.

You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

You must create a compartment to store your resources.

Q19. 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 pp system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.

You want to restore to an existing System Change Number (SCN).

Data Guard must be disabled, or you must first remove the Data Guard association by terminating the standby database before you can restore the database.

Restore the database from an unmanaged backup in Object Storage created directly by using RMAN.

Restore the database from a backup in Object Storage that was created by using the Console or the API.

Q20. 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?

Use the mysqlbackup command to establish a 4 AM backup start time.

Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.

Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time.

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

Q21. Which TWO statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer 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.

Consider any business policies or regulations that preclude the use of a particular region.

Consider the physical proximity of the region you register the infrastructure in to your data center.

The Exadata Cloud@Customer region can be changed after the infrastructure is created.

Consider which availability domain (within the region) to create the Exadata Cloud@Customer infrastructure in.

Q22. 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 193B respectively).You decide to consolidate both databases into a single Oracle Home (OH193. |_A) to free up space. Which TWO actions must you perform? (Choose all correct answers)

use the Move Database option from the console.

Schedule a downtime window with the Test teams who use the 193B database.

Copy the sqinet.ora file from OH193_B to OH193_A.

Create a new container under 0H193B and migrate the pluggable databases (PDBs) from 193B to 193A.

Q23. Which TWO statements are true when enabling autonomous Data Guard on Autonomous Exadat a. (Choose all correct answers)

Autonomous databases inherit their Data Guard configuration from their Autonomous Container Database.

Data Guard can be set per individual Autonomous Database within a Container Database.

Data Guard is not currently supported on Autonomous Exadata Cloud@Customer.

Autonomous Data Guard only supports Maximum Performance and Maximum Protection protection modes.

When in a Data Guard configuration patching will always take place on the standby database first.

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

OCI CLI

ocpucli

exacli

dbaascli

Q25. You enable automatic backups on your Exadata Cloud@Customer.?

database archivelog files

database control files

Transparent Data Encryption (TDE) keystore (wallet)

server parameter file (SP file)

Q26. Which statement is FALSE about using compartments?

They allow you to isolate resources.

They can be used to secure resources.

They can be organized in a hierarchical fashion.

They are a physical concept that separates users.

Q27. 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 to the primary role.

You can write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys.

You can terminate a primary database DB system.

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

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.

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

virtual Cloud Network (VCN)

Client subnet

Virtual Network Interface Card (VNIC)

FastConnect

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

Add an ingress rule for port 20.

Instantiate MySQL Shell on the MySQL database system instance.

Connect to the MySQL Database Service instance.

SSH into the compute instance from your local machine.

Start MySQL Shell on the compute instance.

Q30. 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 SQL*NET traffic from within the VCN

allows ONS and FAN traffic from within the VCN

allows SSH traffic from anywhere

allows Path MTU Discovery fragmentation messages

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

record size

data model

query pattern

durability level