1Z0-1093-23: 02_21_al_40

A database is running on Exadata Database Service on Dedicated Infrastructure in the public cloud. Which statement is true for Performance Hub? (Choose the best Answer.). Performance Hub provides Database Management features for Oracle Cloud Databases and is available as part of two management options (Basic and Full). Performance Hub is only available once you enable and pay for the Full Database Management option. Performance Hub in Basic or Full mode is free but Full mode requires more storage. Performance Hub with the Basic Database Management option delivers advanced features for monitoring Exadata, RAC Database Monitoring. SQL Tuning Advisor, Database Fleet Monitoring, and Database Administration features.

Which statement regarding Data Regions is false? (Choose the best Answer.). A Data Region for Oracle NoSQL Database Cloud Service is a localized geographic area. The Oracle NoSQL Database Cloud Service can be accessed based on Data Regions using the service endpoints. A Default Data Region is configured for the user based on the Oracle Cloud Account. A Data Region can have only one Region Identifier with its respective Oracle NoSQL Database Cloud Service endpoint.

What capability in the OCI Database Management Service is available using Database Groups? (Choose the best Answer.). Predict long-term capacity trends for the databases. View database log events. Execute a SQL query for the databases. Install patches for the databases.

How many IPs are required for the Backup Subnet supporting an Exadata Database Service with six Database Compute Servers? (Choose the best Answer.). 15. 9. 12. 24.

Which NoSQL Database Cloud Service API statement can be used to adjust table capacity? (Choose the best Answer.). TableProvision. TableUnits. TableRequest. TableLimits.

MySQL HeatWave offers three flexible deployment options. Which deployment option uses an innovative in-memory analytics engine to provide 400x query acceleration for MySQL at a very compelling price and can be used for high volume with analytic processing? (Choose the best Answer.). The High Availability option. The Standalone option. The HeatWave option.

Which statement is FALSE about using a compartment? (Choose the best Answer.). It allows you to isolate resources. It can be organized in a hierarchical fashion. It is a physical concept that separates users. It can be used to secure resources.

You can manage and monitor performance of an autonomous database running on autonomous Exadata CloudCustomer using the Performance Hub. Which two actions can be undertaken by Performance Hub? (Choose two.). scale OCPUs for an autonomous database. Configure auto indexing. View ASH Analytics. Configure IO resource management (IORM). Kill a running SQL session.

You have been brought in to help an organization with slow nightly batch processing running on their Exadata Database Service. You determine that the workload is CPU-bound during the batch window. Which command-line tool would you use to script an increase or decrease in OCPUs? (Choose the best Answer.). OCI CLI. ocpucli. dbnodecli. exacli.

What three steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell? (Choose three.). Connect to the MySQL Database Service instance. Install MySQL Shell on the MySQL database system instance. SSH into the compute instance from your local machine. Add an ingress rule for port 20. Start MySQL Shell on the compute instance.

Which network is used to facilitate the secure monitoring and administration of Oracle-managed infrastructure components in Exadata CloudCustomer? (Choose the best Answer.). Backup network. InfiniBand network. Client network. Cloud operations network.

How many IPs do you need at a minimum for the Client Subnet, when you plan to have six Database Compute Servers for your Exadata Database Service? (Choose the best Answer.). 16. 18. 24. 9. 12.

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 Database Services? (Choose the best Answer.). Enable ingress for TCP traffic only for port 1521. Enable egress for TCP traffic for all outbound ports. Enable egress for TCP traffic only for port 1521. Enable egress for TCP traffic only for port 22. Enable egress for TCP traffic only for port 1521 and port 22.

What is the minimum OCPUS per compute server allowed on Exadata Database Service on Dedicated Infrastructure (ExaDB-D) in the public cloud? (Choose the best Answer.). Zero enabled OCPUS per compute server is allowed for ExaDB-D. Four minimum enabled OCPUS per compute server are allowed for ExaDB-D. Minimum enabled OCPUs for ExaDB-D must match your BYOL entitlement. Two minimum enabled OCPUS per compute server are allowed for ExaDB-D.

How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database? (Choose the best Answer.). Two for both the primary and standby databases, because a DB system with the database that you want to use as the standby must already exist before you enable Oracle Data Guard. It depends on how many standby databases you want for your primary database in the Oracle Data Guard configuration in Oracle Cloud Infrastructure. Three, first for the primary database, second for the standby database, and a third for the staging database in the Oracle Data Guard configuration. Only one for the primary database, because a new DB system is provisioned for the standby database when it is created and associated with the primary database while enabling Oracle Data Guard.

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 two.). You want to restore to an existing System Change Number (SCN). The DB system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored. Restore the database from a backup in Object Storage that was created by using the Console or the API. 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.

You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase to solve this? (Choose the best Answer.). OCPU for all servers in the cluster. Index size. Data size. Storage capacity.

You used the "Stop" option from the Console of an Exadata Database Service virtual machine within a VM cluster. Which two statements are true? (Choose two.). All the databases in the VM cluster are stopped. All the VMs in the cluster are stopped. Billing for the OCPU stops but billing for the Exadata Infrastructure continues. The stopped VM is not available to any other database deployment. Billing for the OCPU and Infrastructure are stopped until the VM restarts.

Which of the following is false about the automatic backup configuration settings? (Choose the best Answer.). There is a 7-day backup cycle with one full backup of the database taken every Sunday, followed by daily incremental backups. Automatic backups are scheduled daily. For database deployments with Oracle Data Guard, automatic backups can be executed only on the primary site. Archived redo log files are backed up every 3 hours.

You want to move your VM Cluster to a different Oracle Cloud Infrastructure (OCI) compartment for increased isolation from other teams that use the Exadata Database Service in your tenancy. What happens if you do this? (Choose the best Answer.). The VM Cluster cannot change compartments, after it is deployed. The VM Cluster and the underlying Exadata Infrastructure will move to the new compartments. All other resources will remain in the existing compartment. The VM Cluster and its dependent resources will move to the new compartment. The dependent resources for a VM. Cluster are the database homes, the databases, and their automatic backups. All other resources will remain in the existing compartment. The VM Cluster and associated databases will move to the new compartments. All other resources will remain in the existing compartment.