Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dumps65

Oracle 1z0-1105-23 Dumps

Page: 1 / 8
Total 79 questions

Oracle Cloud Data Management 2023 Foundations Associate Questions and Answers

Question 1

Which Lakehouse service should you use for serverless Spark processing?

Options:

A.

OCI Data Flow

B.

Oracle Analytics Cloud

C.

OCI Object Storage

D.

OCI Data Catalog

Question 2

Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud? (Choose all correct answers)

Options:

A.

Streaming Service

B.

Compute VM

C.

Exadata Cloud Service

D.

Autonomous Database

Question 3

What is a main feature of APEX's low code platform?

Options:

A.

Use graphical interfaces and configuration for building web applications

B.

Simplified core-based licensing

C.

Limited productivity

D.

Build scalable web apps for MongoDB

E.

Use traditional computer programming paradigms

Question 4

What security control area determines if there is sensitive data in a system?

Options:

A.

Detect

B.

Protect

C.

Assess

D.

Users

Question 5

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

Question 6

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

Question 7

Which two statements about ORDS are true? (Choose all correct answers)

Options:

A.

ORDS is a low code development platform to build responsive applications.

B.

ORDS stores, manages and indexes JSON documents

C.

ORDS makes REST APIs in the Oracle Database available.

D.

ORDS creates servlets for the Data Dictionary

Question 8

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

Question 9

What is the FINAL release supporting the non-CDB architecture?

Options:

A.

Oracle Database 23c

B.

Oracle Database 21c

C.

Oracle Database 18c

D.

Oracle Database 19c

Question 10

Which two are key features of MySQL Database Service?

Options:

A.

Integration with Oracle Technologies: Uses a diem s existing Oracle investments and easily integrates MySQL Database Service with Oracle technologies

B.

inter active Documents: Uses a built-in web-based notebook tool for designing and sharing SQL-based data-driven scripts

C.

in Memory Lookups: Avoids unnecessary I/O operations by replacing storage indexes with a few m memory lookups

D.

Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements. including GDPR, PCI, and HIPPA

Question 11

Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage?

Options:

A.

File Storage

B.

Object Storage

C.

Flash Local Storage

D.

Block Volume Storage

E.

Archive Storage

Question 12

Which statement is true about MySQL Database Service?

Options:

A.

Its users are responsible for database and operating system patching tasks.

B.

It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.

C.

It is a public cloud service built on MySQL Community Edition.

D.

It is a fully managed Oracle Cloud Infrastructure (OCI) native service.

Question 13

You have stopped the HeatWave cluster. Which two statements are correct?

Options:

A.

The data loaded in HeatWave cluster memory is lost.

B.

Billing will stop for the HeatWave cluster.

C.

The HeatWave cluster data will remain loaded.

D.

The HeatWave cluster stop action will also stop DB Syster

E.

Billing will continue for the HeatWave cluster.

Question 14

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

Question 15

What are two important reasons to upgrade and patch? (Choose all correct answers)

Options:

A.

Restructure the database

B.

Security

C.

Validation of application

D.

Support Compliance

Question 16

Where should you store unstructured, high volume data sets of unknown value for best price/performance?

Options:

A.

OCI Data Flow

B.

OCI Object Storage

C.

OCI Data Catalog

D.

OCI GoldenGate

Question 17

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

Question 18

Which is NOT a key to successful database upgrades?

Options:

A.

Enable Performance Stability with SPM. STA, and RAT

B.

Download and use Auto Upgrade

C.

Download and install Oracle 19c

D.

Download and install Oracle 21c

E.

Download and install newest RU

Question 19

How does the Converged Database help to access data using an API?

Options:

A.

The database provides only one universal RES interface which makes integration of applications extremely agile.

B.

A REST API is automatically generated on top of SQL or stored procedures.

C.

Each database comes with a REST-enabled compute instance to provide access to data.

D.

Developer can point their application to the location of ADB Wallet which integration all REST API calls.

Question 20

Which is NOT a resource type for NoSQL Database Cloud Service?

Options:

A.

Nosql-keys

B.

Nosql-indexes

C.

Nosql-rows

D.

Nosql-tables

Question 21

Which three are prerequisites for using the MySQL Database Service? (Choose all correct answers)

Options:

A.

You must create a tenancy and be able to sign in to it

B.

You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

C.

You or your group must be granted the policies described in Mandatory Policies.

D.

You must download the latest MySQL version from https://edelivery.oracle.com/

You must create a compartment to store your resources

Question 22

What are the two main features of APEX's low code platform? (Choose all correct answers)

Options:

A.

Use traditional computer programming paradigms

B.

Use graphical user interfaces and configuration

C.

Focus on business requirements

D.

Limited productivity

Build scalable web apps for MongoDB

E.

Simplified core-based licensing

Question 23

Which statement can be detected by monitoring of access to sensitive data?

Options:

A.

SELECT SYSDATE from DUAL;

B.

CREATE index emp_id_idx on EMPLOYEES(emp_id);

C.

UPDATE quarter_reference set Q1='012022'

D.

SELECT * from EMPLOYEES;

Page: 1 / 8
Total 79 questions