1Z0-1093-23: 02_01_al_20

Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures? (Choose the best Answer.). • OCI Block Volumes. • OCI File Storage. • OCI Object Storage. • OCI Data Safe.

Exadata Database Service is started with BYOL as the license type. How can you change your license type? (Choose the best Answer.). Use the Update License Type option on the VM Cluster details page to switch license type online. Update the license type by submitting a service request (SR) to support. Use the Move database option to relocate to a new Database Home on the VM Cluster with the desired license type. Use the Update License Type option on the VM Cluster details page to restart the VM Cluster with the desired license type.

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 two.). 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.

You want to scale within Exadata System. Which of the following two statements are true? (Choose two.). The setting of database parameter CPU_COUNT is affected by modifying the number of enabled OCPU cores. Modifying the number of enabled OCPU cores requires database downtime. Modifying the number of enabled OCPU cores does not require database downtime. The setting of database parameter CPU_COUNT is not affected by modifying the number of enabled OCPU cores.

When you create your VCN, subnets, and Exadata VM Cluster, which three identifiers must you carefully set that are related to DNS in the VCN? (Choose three.). Hostname prefix for the Exadata VM cluster. Gateway domain label. Subnet domain label. VCN domain label.

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? (Choose the best Answer.). Create a Linux compute instance. Create a Virtual Cloud Network by using the VCN Wizard. Create the MySQL DB system. Connect to the MySQL Database Service system endpoint.

Which three Oracle Cloud Infrastructure (OCI) services can be used to connect to on-premises networks? (Choose three.). Service Gateway. FastConnect. IPSec VPN. Dynamic Routing Gateway (DRG). Internet Gateway.

Which two key architecture choices lead to a compelling performance and cost advantage with HeatWave? (Choose two.). Data stored in binary JavaScript Object documents. Innovative in-memory columnar analytics engine. Combination of Innodb and MyISAM tables to improve HeatWave performance. Optimized for Oracle Cloud Infrastructure.

Your company has decided on a Hybrid Cloud strategy and wants to monitor their cloud and on-premises Oracle databases. Which action should they take? (Choose the best Answer.). Use the cloud console to monitor all your Exadata systems that are on-premises or in the cloud from a single interface. Subscribe to cloud events to send custom notifications about cloud Exadata systems to the on-premises Enterprise Manager. Configure the cloud console to send notifications about cloud Exadata systems to the on-premises Enterprise Manager. Use Enterprise Manager to monitor all your Exadata systems that are on-premises or in the cloud from a single interface.

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 two.). Define a SQL Developer connection in your MySQL Database Service database system. SSH into the compute instance from your local machine. Install the MySQL client on your local computer. Connect to your database system by using the MySQL client on the Linux compute instance.

Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database? (Choose three.). 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. 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.

When you created your development database on Exadata CloudCustomer, you selected "None" for backup location. You now need to enable Automatic backups on the development database with a retention period of 60 days. Which action should you perform? (Choose the best Answer.). No action can be taken, because a new backup location cannot be set after creation. Change the database backup location to Object storage with the default retention period set. Change the database backup location to a local storage and set the retention period to 60 days. Change the database backup location to an NFS backup location and set the retention period to 60 days.

What three capabilities does the database fleet summary provide? (Choose three.). View the current database resource usage. View the status of the databases. View database log entries. View database log entries. Execute a DDL command on the databases. Compare database performance metrics over time.

Which TWO statements are true about Interface for Exadata I/O Resource Management (IORM)? (Choose two.). IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service. IORM allows workloads and databases to share I/O resources automatically according to admin-defined policies. 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 user requests.

Which three are prerequisites for using the MySQL Database Service? (Choose three.). You must create a compartment to store your resources. 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 create a tenancy and be able to sign in to it. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

Oracle NoSQL Database Cloud Service supports many common data types. Which three are data types that are supported by Oracle NoSQL Database Cloud Service? (Choose three.). Char. Binary. Date. Long. Double.

You enable automatic backups on your Exadata CloudCustomer? (Choose the best answer.). Server parameter file (SP file). Transparent Data Encryption (TDE) keystore (wallet). Database control files. Database archivelog files.

While configuring a Virtual Machines (VM) database (DB) system, the next step after selecting a shape for the DB system is to select storage options and configuration. Which two configurations should you select and use? (Choose two.). Use Object Storage buckets for DATA, redo logs, and archive logs. Configure storage to assign 40% to DATA and the rest to redo logs and archive logs. Use Automatic Storage Management (ASM) for the storage management software of single and two node VM deployments. Use Logical Volume Manager (LVM) for the storage management of single-node VM deployments.

Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.). Oracle 18c Database deployed on Oracle Exadata CloudCustomer. Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine. Oracle 11gR2 Database deployed on an Oracle Private Cloud. Oracle Autonomous Database 19c deployed on an OCI Tenant.

Which two statements are true about cloning a Virtual Machine DB System? (Choose two.). When creating a clone, you must use the same SSH key and admin password as the source Virtual Machine DB system. When creating a clone of the Virtual Machine DB system, you need to specify a new SSH key and admin password. Cloning creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, including the storage configuration software and database volumes. Cloning only creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, but does not include the storage configuration software and database volumes.