1Z0-1093-23 Actual Questions – Instant Download 57 Questions [Q33-Q52]

Rate this post

1Z0-1093-23 Actual Questions – Instant Download 57 Questions

Download Free Latest Exam 1Z0-1093-23 Certified Sample Questions

Oracle 1Z0-1093-23 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe Oracle Cloud Infrastructure Strategy (OCI) Manage Database Cloud Service on a Virtual Machine DB System
Topic 2	Explain provisioned throughput for NoSQL Database Cloud Service Oracle Cloud Infrastructure Database Management Service
Topic 3	Utilize Database Cloud Service Management Interfaces Discuss Database Cloud Services (Overview)
Topic 4	Provision and connect to MySQL Database Set up Backup for MySQL Database Service
Topic 5	Utilize Exadata Cloud Management tools Manage Exadata Infrastructure and VM Clusters

NO.33 Which two use cases can be used by the Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose two.)

Database data files

Database backups

Database log files

Database binaries

NO.34 Which two statements are true regarding MySQL Database Service HeatWave? (Choose two.)

HeatWave uses machine learning to automate operations, increase DBA productivity, and reduce costs.

HeatWave uses periodic long-running ETL batch jobs to refresh data

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

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

NO.35 What three capabilities does the database fleet summary provide? (Choose three.)

View database log entries.

View the current database resource usage.

View the status of the databases.

Migrate databases to OCI.

Compare database performance metrics overtime.

Execute a DDL command on the databases.

NO.36 You have permanently deleted your MySQL database system.
What happens to the two backups that are associated with the deleted database system?

They are archived and moved to Oracle Cloud Infrastructure file storage.

They are retained for their retention periods.

They are automatically deleted along with the database system.

They are moved to Oracle Cloud Infrastructure Object Storage.

NO.37 In which case can you fast provision a virtual machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for storage management?

Oracle Database versions 18c and greater

Oracle Database versions 12.2 and greater

Oracle Databases that could use Automatic Storage Management

any currently supported release of the Oracle Database

NO.38 Which method must you use to patch databases on Exadata Database Service with the least amount of downtime?

Conduct in place patching of the database Home.

Leverage Patchmgr to execute patching the database Home.

Create a Data Guard standby and execute standby first patching.

Leverage Opatch to execute patching the database Home.

Move the database to a new Home with the desired patch level.

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

Create the MySQL DB system.

Connect to the MySQL Database Service system endpoint.

Create a Linux compute instance.

Create a Virtual Cloud Network by using the VCN Wizard.

NO.40 What information is required to connect to the NoSQL Database Cloud Service?

Tenancy ID, passphrase. handshake key

User ID, tenancy ID. component ID

Signing key fingerprint. API signing key. tenancy OCID

API signing key, admin ID, user ID

NO.41 Which two statements are true about cloning a Virtual Machine DB System? (Choose two.)

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.

When creating a clone, you must use the same SSH key and admin password as the source Virtual Machine DB system.

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.

NO.42 What is true about Security Lists?

You can delete the default Security List if it is not required.

A Security List is defined at the VCN level.

A Security List controls ingress and egress rules that specify the types of traffic allowed in and out.

The default Security List is shared by all the Subnets in the VCN.

The Security List rules can be applied to Storage servers to restrict access.

NO.43 Which statement is FALSE about updating your Virtual Machine DB System database?

Updating the DB system updates the Grid Infrastructure for two-node RAC DB Systems with Automatic Storage Management (ASM) storage management software.

Ensuring/uOl has 15 GB of free space.

Updating the DB System also updates the operating system.

Updating the DB System does NOT update the operating system.

NO.44 Which statement is FALSE related to loading a table into HeatWave?

Data is distributed among analytics nodes by slicing tables by vertically.

Data is read from InnoDB using batched, multi-threaded reads.

Data is partitioned by primary key unless data placement keys are defined.

Data is converted into columnar format and sent over the network.

NO.45 Which of the following resources can be scaled up and down on your VM cluster on Exadata Cloud@Customer?

CPU, Persistent Memory (PMEM), Local Storage, and Exadata Storage

CPU, Memory, Local Storage, and Network

CPU, Memory, Local Storage, and Flash Storage

CPU, Grid Infrastructure Bandwidth, Memory, Local Storage, and Exadata Storage

CPU, Memory, Local Storage, and Exadata Storage

NO.46 Which two statements are true when enabling Data Guard on Exadata Database Service? (Choose two.)

You should use similar configurations for your Primary and Standby databases to ensure you meet the same performance service level after a role transition.

You can enable Data Guard to support your Standby or Disaster Recovery (DR) needs with a single API call or mouse click in the Ul using cloud automation.

You can use Active Data Guard, which extends Oracle Data Guard capabilities by providing read/write functionality on the Standby or Disaster Recovery system.

You must configure Data Guard manually to create the Standby or DR instance for your Primary Exadata Database.

You cannot edit your configuration to change between synchronous or asynchronous transport of data to the DR site, after enabling Data Guard.

NO.47 Which two statements are true about recommended Subnet configurations for Exadata Database Service? (Choose two.)

Use Regional Subnets for both Client and Backup.

Use a Public Subnet for Client and a Service Subnet for Backup.

Use a Private Subnet for Client and a Service Subnet for Backup.

Use two Public Subnets for Client and Backup.

Use a Private Subnet for Client and Private Subnet for Backup.

NO.48 What permissions do you need to perform actions on a NoSQL table?

NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

NO.49 NoSQL Database Cloud Service supports all three types of big data.
Which is NOT considered big data?

structured data

semi-structured data

unstructured data

free-structured data

NO.50 Which three statements are true about Exadata Snapshots on the Exadata Database Service? (Choose three.)

Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain all the data that is read and written by the Snapshots.

Exadata Snapshots are unable to utilize all the Exadata features.

Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain only changed blocks.

Multiple users can create independent Exadata Snapshots from the same test master, which is a full Read-Only clone of the source database.

Before creating Exadata Snapshots from the test master, you can modify the data in the test master, if required.

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

Billing for the CPU stops but billinq for the Exadata Infrastructure continues.

The stopped VM is not available to any other database deployment.

All the VMs in the cluster are stopped.

All the databases in the VM cluster are stopped.

Billing for the OCPU and Infrastructure are stopped until the VM restarts.

NO.52 On the Add HeatWave Cluster dialog, you are asked to provide the shape for the HeatWave nodes. Which detail does the shape selection provide to HeatWave?

The associated database system network

The Disk partition count for the HeatWave cluster

The private IP address for the Analytic Cluster

The number of CPUs for the Analytic cluster

Loading …