Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Oracle Cloud Data Management 2023 Foundations Associate Question and Answers

Oracle Cloud Data Management 2023 Foundations Associate

Last Update May 2, 2024
Total Questions : 79

We are offering FREE 1z0-1105-23 Oracle exam questions. All you do is to just go and sign up. Give your details, prepare 1z0-1105-23 free exam questions and then go for complete pool of Oracle Cloud Data Management 2023 Foundations Associate test questions that will help you more.

1z0-1105-23 pdf

1z0-1105-23 PDF

$35  $99.99
 Add to Cart
1z0-1105-23 Engine

1z0-1105-23 Testing Engine

$42  $119.99
 Add to Cart
1z0-1105-23 PDF + Engine

1z0-1105-23 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

Which tool allows users to execute SQL statements, create relational models, load data, and monitor SQL queries from your browser?

Options:

A.  

SQL Developer

B.  

Service Console

C.  

Database Actions

D.  

OCI Operational Insights

E.  

Enterprise Manager

Discussion 0
Questions 2

New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?

Options:

A.  

Storage Disks

B.  

Database Servers

C.  

Persistent Memory

D.  

Compute Instances

Discussion 0
Questions 3

The Demand Side is data that is active and does something. What two data services are typi-cally part of the demand side? (Choose all correct answers)

Options:

A.  

Inert algorithms

B.  

Authorization

C.  

Payloads

D.  

Data Models

Discussion 0
Questions 4

Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which is an example of an in-database option?

Options:

A.  

Tuning of hyperparameter

B.  

Oracle Machine Learning for Python (OML4Py) APIs

C.  

REST Interface

D.  

Cognitive text

Discussion 0
Questions 5

Which ability is NOT provided out of the box with the Autonomous Database Tools set?

Options:

A.  

Cataloging

B.  

Data Loading

C.  

Data Labeling

D.  

Data Insight

Discussion 0
Questions 6

What connections to multiple public clouds are provided through 3rd party connectivity?

Options:

A.  

Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC)

B.  

Layer 3 and FastConnect

C.  

Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPC)

D.  

FastConnect and Direct Connect

Discussion 0
Questions 7

Which are two characteristics of Autonomous Transaction Processing (ATP)? (Choose all correct answers)

Options:

A.  

Focuses on creation of indexes

B.  

Stores data in columnar format

C.  

Statistics are gathered as part of bulk load operations

D.  

Optimized for response time

E.  

Creates autonomous data summaries

Discussion 0
Questions 8

What are three platforms where Oracle's Autonomous Database service can be deployed? (Choose all correct answers)

Options:

A.  

Oracle Public Cloud at Customer

B.  

Oracle Cloud Infrastructure

C.  

Dedicated Region Cloud at Customer

D.  

Hybrid Cloud Configurations

E.  

AWS Cloud at Customer

Discussion 0
Questions 9

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

Options:

A.  

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

B.  

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.

C.  

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

D.  

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 cur-rent compartment.

Discussion 0
Questions 10

After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?

Options:

A.  

If d VM DB system requires more block storage, increase the storage at any time without impacting the system.

B.  

Only bare metal DB systems can increase block storage at any time without impacting the system.

C.  

If a VM DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system.

D.  

After you have provisioned a VM DB system, you cannot increase or decrease block storage.

Discussion 0
Questions 11

Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?

Options:

A.  

Autonomous Data Warehouse

B.  

Compute

C.  

Exadata DB Systems

D.  

Monitoring

Discussion 0
Questions 12

Which two locations can be used to store your DB system database backups? (Choose all cor-rect answers)

Options:

A.  

You can store your DB system database backups on locally attached block storage vol-umes.

B.  

You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.

C.  

You can store your DB system database backups locally in the Fast Recovery Area of the DB system.

D.  

You can store your DB system database backups in on-premises local storage.

Discussion 0
Questions 13

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

Options:

A.  

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

B.  

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

C.  

The required patch is available on the Control Plane server.

D.  

Oracle Clusterware is down on the VM cluster.

Discussion 0
Questions 14

Oracle Lakehouse provides extensive data processing capabilities, to accommodate the migration of existing architectures or the creation of new, agile ones. Which service does NOT provide data processing on Oracle Cloud Infrastructure (OCI) Lakehouse?

Options:

A.  

NoSQL Service

B.  

Autonomous Database

C.  

Big Data Service

D.  

OCI Data Flow

Discussion 0
Questions 15

Which three can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer?

Options:

A.  

amount of database OCPUs required

B.  

amount of database storage required

C.  

workload type

D.  

client network

E.  

size of the shared global area (SGA) to use

Discussion 0
Questions 16

Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two services are used for persistence of the data in Lakehouse? (Choose all correct answers)

Options:

A.  

OCI Data Catalog

B.  

Autonomous Database

C.  

OCI Object Storage

D.  

OCI GoldenGate

Discussion 0
Questions 17

Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?

Options:

A.  

Audit Vault and Database Firewall

B.  

Oracle Native Network Encryption and TDE (Transparent Data Encryption)

C.  

Oracle Key Vault

D.  

Database Vault and Data Masking Pack

Discussion 0
Questions 18

Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) work-flows?

Options:

A.  

Database Actions (including real time SQL monitor)

B.  

ADB console (including Performance Hub)

C.  

SQLcl (including Liquibase)

D.  

SQL Developer (including ADB wallet)

Discussion 0
Questions 19

What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats?

Options:

A.  

Data is encrypted

B.  

Admin passwords are disabled after provisioning

C.  

Security updates are applied online

D.  

Protects data from admin snooping using Database Vault

Discussion 0
Questions 20

Oracle Maximum Security Architecture is used for data that requires something higher than normal baseline security. Which two controls added to the baseline security apply to maximum security architecture?

Options:

A.  

Strong passwords

B.  

Network Encryption

C.  

Database Vault

D.  

Privilege Analysis

E.  

Database Firewall

Discussion 0
Questions 21

What is the primary goal of Oracle Maximum Availability Architecture for customer systems?

Options:

A.  

Scale out, application availability and protection

B.  

Active Replication, Data Protection and continuous availability

C.  

Continuous Availability, network security and failover

D.  

Data Protection, access and reporting

Discussion 0
Questions 22

What are two characteristics of CI/CD?

Options:

A.  

It prevents developers from merging their code changes back to the shared branch for security.

B.  

It introduces automation into all stages of app/database development.

C.  

Development changes are automatically V tested on push/commits and merges.

D.  

It requires Liquibase

Discussion 0
Questions 23

Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?

Options:

A.  

OCI Object Storage

B.  

OCI File Storage

C.  

OCI Block Volumes

D.  

OCI Data Safe

Discussion 0