[Q30-Q44] Download Online VALID 1z0-1093-22 Exam Dumps File Instantly [Oct 07, 2023] : Top Exam Collection : http://blog.topexamcollection.com

NO.30 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.

NO.31 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

ocpucli

exacli

asmali

NO.32 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

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

XML, JSON, array

Iong, double, triple

enum, map, record

Boolean, date stamp, float

NO.34 Which THREE Oracle Cloud Infrastructure (OCI) services can be used to connect to on-premises networks? (Choose all correct answers)

Internet Gateway

Fastconnect

Dynamic Routing Gateway (DRG)

Service Gateway

IPSec VPN

NO.35 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)

mount block storage locally to the node.

Configure storage to assign 40% to DATA and the rest to redo logs and archive logs.

Use Object Storage buckets for DATA, redo logs, and archive logs.

Use Automatic Storage Management (ASM) for the storage management software.

NO.36 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.

NO.37 You want to permanently delete the DB System and its attached HeatWave cluster. Which action should you perform?

Terminate the DB system and drop the associated HeatWave Cluster.

Delete the Heatwave Cluster and it will also delete the DB system.

Delete the DB system and it will also delete the attached HeatWave Cluster.

Drop the DB system and terminate the associated HeatWave Cluster.

NO.38 You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase to solve this?

storage capacity

index size

OCPU for all servers in the cluster

NO.39 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)

Configure auto indexing.

Kill a running SQL session.

View ASH Analytics.

scale OCPUs for an autonomous database.

Configure IO resource management (IORM).

NO.40 Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)

Local storage

Object Storage

EFS Storage

Block Storage

File Storage

EBS Storage

NO.41 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.

NO.42 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?

Disable the automatic backup configuration and then take an on-demand backup.

First connect to the Exadata Cloud Instance as the oracle user and then take a backup.

Use the Create Backup button in the backup section of the Database Details page.

Perform a recovery operation to a specific long-term backup.

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

cellcli

OCI CLI

dbaascli

exacli

NO.44 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.