1Z0-1093-23 Online Practice Questions and Answers

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?

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

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

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

D. It patches the underlying operating system of the MySQL database.

In which case can you fast provision a virtual machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for storage management?

A. Oracle Database versions 18c and greater

B. Oracle Database versions 12.2 and greater

C. Oracle Databases that could use Automatic Storage Management (ASM)

D. any currently supported release of the Oracle Database

Which two tools are used to monitor Exadata Database Service? (Choose two.)

A. Oracle Enterprise Manager

B. Oracle Management Cloud

C. Oracle Cloud Monitor

D. Oracle Internet Monitoring Suite (IMS)

E. Service Console

You are asked to create a MySQL Database Service system. You log in to the group's Oracle Cloud Infrastructure tenancy and access the assigned compartment, and find that all policies have been configured and tested. What is the next step to create a MySQL Database Service?

A. Create the MySQL DB system.

B. Connect to the MySQL Database Service system endpoint.

C. Create a Linux compute instance.

D. Create a Virtual Cloud Network by using the VCN Wizard.

Which two statements are true when enabling Data Guard on Exadata Database Service? (Choose two.)

A. You should use similar configurations for your Primary and Standby databases to ensure you meet the same performance service level after a role transition.

B. You can enable Data Guard to support your Standby or Disaster Recovery (DR) needs with a single API call or mouse click in the UI using cloud automation.

C. You can use Active Data Guard, which extends Oracle Data Guard capabilities by providing read/write functionality on the Standby or Disaster Recovery system.

D. You must configure Data Guard manually to create the Standby or DR instance for your Primary Exadata Database.

E. You cannot edit your configuration to change between synchronous or asynchronous transport of data to the DR site, after enabling Data Guard.

Which three are prerequisites for using the MySQL Database Service? (Choose three.)

A. You must create a compartment to store your resources.

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

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

D. You must download the latest MySQL version from https://edelivery.oracle.com/.

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

Which statement is FALSE related to loading a table into HeatWave?

A. Data is distributed among analytics nodes by slicing tables by vertically.

B. Data is read from InnoDB using batched, multi-threaded reads.

C. Data is partitioned by primary key unless data placement keys are defined.

D. Data is converted into columnar format and sent over the network.

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

A. OCI Data Safe

B. OCI File Storage

C. OCI Object Storage

D. OCI Block Volumes

Resources are allocated to the DB system based on the shape selected.

Which two are options for a DB system? (Choose two.)

A. Two-Node Virtual Machine with Automatic Storage Management (ASM) as the storage management software

B. Single-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software for the "fast provisioning" option

C. Single-Node Virtual Machine with Local Storage

D. Two-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software

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)

A. Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region.

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

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

D. The Exadata Cloud@Customerregion can be changed after the infrastructure is created.

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