[UPDATED] Oracle 1Z0-1093-21 Certification Exam Questions [Q32-Q53] : Valid Premium Exam : http://premium.validexam.com

NO.32 Which three statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers) HeatWave uses periodic long-running ETL batch jobs to refresh the data.

Heatwave is a in-memory, query-processing engine designed for fast execution of analytic queries.

Heatwave is Exclusively available in Oracle Cloud Infrastructure.

Heatwave uses machine learning to automate operations, increasing DBA productivity and reducing costs.

HeatWave data which is needed for analytic processing is stored in disk files.

NO.33 You are asked to measure useful quantitative data about a MySQL Database Service system. You must provide information such as current connection information, statement activity, latency, and host OCPU, memory, and disk I/O utilization. Which THREE Oracle Cloud Infrastructure monitoring methods should you use? (Choose all correct answers)

data points

metrics

notifications

alarms

queries

NO.34 You want to scale within Exadata System. Which of the following two statements are true? (Choose all correct answers)

The setting of database parameter CPU_COUNT is affected by modifying the number of enabled OCPU cores.

Modifying the number of enabled OCPU cores does not require database downtime.

Modifying the number of enabled OCPU cores requires database downtime.

The setting of database parameter CPU_COUNT is not affected by modifying the number of enabled OCPU cores.

NO.35 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.36 Which system configuration is offered by the Oracle Database Exadata Cloud Service?

Each system configuration starts with a fixed amount of memory and storage resources.

Each system configuration starts with a fixed amount of OCPU and storage resources.

Each system configuration starts with a fixed amount of OCPU, memory, storage, and network resources.

Each system configuration starts with a fixed amount of OCPU, memory, and network resources.

NO.37 You are considering whether or not to implement bare metal or virtual machine shapes. Which TWO statements are true about bare metal and virtual machine (VM) database (DB) systems? (Choose all correct answers)

Both bare metal and vm DB systems support two-node Real Application Clusters (RAC) systems.

The Console, API, and Oracle Cloud Infrastructure CLI are options for managing bare metal DB systems.

Bare metal shapes determine the total raw storage allocated to bare metal DB systems.

Bare metal and VM DB can only have a single Database Home, and the single database will be the version of the Database Home.

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

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

NO.40 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.41 Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

cellcli

OCI CLI

dbaascli

exacli

NO.42 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.43 Which network is used to facilitate the secure monitoring and administration of Oracle-managed infrastructure components in Exadata Cloud@Customer?

InfiniBand network

Backup network

Client network

Control plane network

Cloud operations network

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

NO.45 In a two-node Real Applications Cluster environment, the Internet and VCN Resolver are supported for DNS in the DB system. Which TWO tasks are required for the network setup? (Choose all correct answers)

After the VCN is created, modify the DNS settings to use DNS Hostnames.

when creating the database, specify a value in the Hostname Prefix.

Select “Use DNS Hostnames in this VCN” as the VCN is being created.

Select the hostname field for a DNS label when the subnet is being created.

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

NO.47 What NoSQL Database Cloud Service API statement can be used to adjust table capacity?

tableRequest

tableunits

tableLimits

tableProvision

NO.48 Which TWO statements are true about Interface for Exadata I/O Resource Management (IORM)? (Choose all correct answers)

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.

IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service.

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

NO.50 Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?

The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes.

Oracle Clusterware is down on the VM cluster.

The required patch is available on the Control Plane server.

All database compute nodes of the VM cluster are up and running.

NO.51 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 Cloud Services?

Tcp traffic only for port 1521 and port 22

Tcp traffic only for port 1521

Tcp traffic only for port 22

Open for all protocols

NO.52 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.53 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.