Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Cloud Infrastructure
1z0-1105-23
Oracle Cloud Data Management 2023 Foundations Associate Questions and Answers

Pass the Oracle Cloud Infrastructure 1z0-1105-23 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-1105-23 Premium Access

View all detail and faqs for the 1z0-1105-23 exam

Go to Exam

803 Students Passed

84% Average Score

94% Same Questions

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side?

Options:

Reports

Technical definitions of business terms

Business rules

Domain objects

Answer

C, D

Questions # 12:

When should you change COMPATIBLE?

Options:

When the database is stopped

After upgrades

After patching

After database downgrades

Answer

Explanation

Changing COMPATIBLE after upgrades is one of the scenarios when you should change COMPATIBLE. According to the Oracle blog post7, “COMPATIBLE needs to be adjusted only once after you completed your last database upgrade.” The blog post also explains that changing COMPATIBLE requires a restart of the database and that it should not be changed before upgrades or patching or after downgrades.

Questions # 13:

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

Options:

Oracle Database 23c

Oracle Database 21c

Oracle Database 18c

Oracle Database 19c

Answer

Explanation

Oracle Database 19c is the final release supporting the non-CDB architecture. According to the Oracle documentation1, “Starting with Oracle Database 21c, non-CDB architecture is desupported. You must upgrade a non-CDB Oracle Database to a PDB on a CDB.” A CDB is a container database that can host multiple pluggable databases (PDBs) that share the same resources and memory.

Questions # 14:

Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI) re-sources? (Choose all correct answers)

Options:

Secure Shell (SSH)

Remote Desktop Protocol (RDP)

Serial console connection (SCC)

OCI REST APIs

OCI Command-line Interface (CLI)

Answer

D, E

Explanation

OCI REST APIs and OCI Command-line Interface (CLI) are two methods that you can use to create or modify Oracle Cloud Infrastructure resources. According to the Oracle documentation, “The Oracle Cloud Infrastructure APIs are typical REST APIs that use HTTPS requests and responses. You can use these APIs to interact with your cloud resources programmatically.” Additionally, according to the Oracle documentation, “The OCI CLI is a tool that enables you to interact with Oracle Cloud Infrastructure services from the command line.”

Questions # 15:

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:

OCI Data Catalog

Autonomous Database

OCI Object Storage

OCI GoldenGate

Answer

A, C

Questions # 16:

Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in?

Options:

Exadata Cloud@Customer is hosted in 4 customer data center so the Exadata infrastructure is not registered in an region.

Consider any business polices or regulations that preclude the use of a particular report 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

Consider the physical proximity of the region you register the infrastructure m to your data center.

Answer

B, D

Explanation

These are two statements that are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in. According to the Oracle documentation5, “When you register an Exadata Cloud@Customer infrastructure in an OCI region, consider any business policies or regulations that preclude the use of a particular region.” This means that you should be aware of any legal or compliance requirements that might limit your choice of OCI regions for Exadata Cloud@Customer. According to the Oracle documentation6, “Consider the physical proximity of the region you register the infrastructure in to your data center. The closer they are physically located, the lower the network latency between them.” This means that you should also consider the network performance and availability when choosing an OCI region for Exadata Cloud@Customer.

Questions # 17:

Which two are key features of MySQL Database Service?

Options:

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

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

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

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

Answer

A, D

Questions # 18:

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

Options:

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

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

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

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

Answer

Questions # 19:

Which deployment option provides the highest degree of security and governance while providing a completely self-service database experience?

Options:

Oracle MySQL Database Service

Oracle Autonomous Database

Oracle Database Cloud Service

Exadata Cloud Service

Answer

Questions # 20:

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)