[Nov 19, 2023] Get Unlimited Access to 1z0-1093-22 Certification Exam Cert Guide [Q13-Q36]

Rate this post

[Nov 19, 2023] Get Unlimited Access to 1z0-1093-22 Certification Exam Cert Guide

Reliable Study Materials for 1z0-1093-22 Exam Success For Sure

Q13. 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

Q14. 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.

Q15. 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

Q16. 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

Q17. 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.

Q18. Which statement is true about moving virtual machine (VM) database (DB) systems from one compartment to another?

You do not need access permissions to the compartment that the resource Is being moved to when moving VM DB systems to a different compartment.

You can move DB systems to a different compartment if you have sufficient access permissions to the compartment that the resource is being moved to, as well as the current compartment.

You have to move dependent resources like Database Homes and databases to the destination compartment before moving the VM DB system.

You can move VM DB systems from one compartment to another by only using Oracle Cloud Infrastructure REST APIs.

Q19. 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.

Q20. 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.

Q21. 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

Q22. 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.

Q23. 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.

Q24. You want to move an Exadata Cloud@Customer VM cluster to a different OCI compartment for increased isolation from other teams that use Exadat a. What happens when you use the console to do this?

The VM cluster and associated databases will move to the new compartment. All other resources will remain in the existing compartment.

After it is deployed, a VM cluster cannot change compartments.

The vm cluster, compute nodes, and associated databases will move compartments. All other resources will remain in the existing compartment.

The vM cluster, compute nodes, and underlying Exadata infrastructure will move to the new compartment. All other resources remain the same.

Q25. 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.

Q26. 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

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

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

Create a Virtual Cloud Network by using the VCN Wizard.

Create a Linux compute instance.

Create the MySQL DB system.

Connect to the MySQL Database Service system endpoint.

Q29. Resources are allocated to the DB system based on the shape selected. Which TWO are options for a DB system? (Choose all correct answers)

Two-node bare metal servers with 512 GB memory and locally attached drives

Two-node virtual machine X7 with Block Storage which can be scaled up

One-node bare metal server with up to 52 OCPU cores and locally attached drives to the system

One-node virtual machine XS with 24 OCPU cores

Q30. 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

Q31. 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

Q32. 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.

Q33. 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.

Q34. 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 all correct answers)

The pp system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.

You want to restore to an existing System Change Number (SCN).

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.

Restore the database from a backup in Object Storage that was created by using the Console or the API.