Updated Jan-2024 Pass 1z0-1115-23 Exam - Real Practice Test Questions [Q16-Q37]

Updated Jan-2024 Pass 1z0-1115-23 Exam – Real Practice Test Questions [Q16-Q37]

January 5, 2024 admin 0 Comments

4.6/5 - (7 votes)

Updated Jan-2024 Pass 1z0-1115-23 Exam – Real Practice Test Questions

Download Free Oracle 1z0-1115-23 Real Exam Questions

Oracle 1z0-1115-23 Exam Syllabus Topics:

Topic	Details
Topic 1	Implement Oracle Database Service for Azure Implement and manage VCN components
Topic 2	Explain the prerequisites and onboarding options for Oracle Database Service for Azure Multi-cloud Connection Options
Topic 3	Administer OCI Database services, such as Base Databases Oracle Database Service for Azure
Topic 4	Federate OCI Identity Domains with identity providers Implement OCI-Azure Interconnect
Topic 5	Explain common multi-cloud use cases and their implementation in OCI Autonomous Databases, MySQL Database

QUESTION 16
An organization wants to deploy Oracle Database Service for Azure in the existing Oracle Cloud Infrastructure and Azure tenancies that are in the supported regions. However, they want to have full control over the Azure permissions that should be granted.
Which option should they choose during the sign-up process?

Fully automated configuration

Guided account linking

Fully scripted configuration

Auto pilot linking

The keyword mentioned in the question is “However, they want to have full control over the Az-ure permissions that should be granted. ” The fully-automated onboarding option for OracleDB for Azure is faster and more convenient than the guided account linking, but some organizations may have security policies that do not allow them to grant the required permissions to the Oracle Database Service enterprise applica-tion that runs in their Azure account.
Guided onboarding is provided for customers who do not want to grant OracleDB for Azure all the Azure permissions required for fully automated onboarding.
The remaining two options – Auto pilot linking and Fully scripted configuration are INVALID. There doesn’t exist anything like these in Oracle Database Service for Azure onboarding.
Hence the correct answer is Guided account linking

QUESTION 17
To achieve high availability in a 2-node RAC DB System in Oracle Cloud Infrastructure, what would you use to distribute your nodes to provide database instance fault isolation?

Availability Domains

Remote region

Fault Domains

Local region

A fault domain is a grouping of hardware and infrastructure within an availability domain.
Fault domains provide anti-affinity: they let you distribute your instances so that the instances are not on the same physical hardware within a single availability domain.
To control the placement of your compute instances, bare metal DB system instances, or virtual machine DB system instances, you can optionally specify the fault domain for a new instance or instance pool at launch time.

QUESTION 18
Which feature is supported in all Oracle Database editions in Oracle Cloud Infrastructure?

Data Guard

Diagnostic Packs

Transparent Data Encryption

In-Memory Database

All editions include Oracle Database Transparent Data Encryption, Machine Learning, and Spa-tial and Graph.
Standard Edition includes Oracle Database Standard Edition.
Enterprise Edition includes Oracle Database Enterprise Edition, Data Masking and Subset-ting Pack, Diagnostics and Tuning Packs, and Real Application Testing.
Enterprise Edition High Performance extends Enterprise Edition with the following options: Multitenant, Partitioning, Advanced Compression, Advanced Security, Label Security, Da-tabase Vault, OLAP, Database Lifecycle Management Pack and Cloud Management Pack for Oracle Database.
Enterprise Edition Extreme Performance extends High Performance with the following options: In-Memory Database, Active Data Guard, Real Application Clusters.
Data Guard is not supported Oracle Database Standard Edition.

QUESTION 19
What should you do to prepare your Oracle Cloud Infrastructure (OCI) Virtual Cloud Network (VCN) for potential security risks when connected to a Microsoft Azure VNet?

Allow all traffic from the Azure VNet without restrictions.

Limit all inbound and outbound traffic from the Azure VNet to expected and well-defined traffic.

Remove all OCI security rules.

Disable the connection between Azure VNet and OCI VCN.

Controlling Traffic Flow Over the Connection
Even if a connection has been established between your VCN and VNet, you can control the packet flow over the connection with route tables in your VCN. For example, you can restrict traf-fic to only specific subnets in the VNet.
Controlling the Specific Types of Traffic Allowed
It’s important that you ensure that all outbound and inbound traffic with the VNet is intended or expected and well defined. Implement Azure network security group and Oracle security rules that explicitly state the types of traffic one cloud can send to the other and accept from the other.

QUESTION 20
Which step is NOT valid while implementing an OCI-Azure Interconnect?

Set up an Oracle FastConnect virtual circuit.

Create a Dynamic Routing Gateway and attach it to the OCI VCN.

Select FastConnect Direct as the connection type.

Set up an Azure ExpressRoute circuit.

As you can see in the below screenshot (from the OCI Console), while implementing OCI-Azure Interconnect you need to select Connection type: FastConnect partner and select Microsoft Azure ExpressRoute as the Partner.
Hence, “Select FastConnect Direct as the connection type” is NOT VALID and hence the correct answer.

QUESTION 21
Which database system is NOT available in Oracle Database Service for Azure?

Autonomous Database on shared Exadata infrastructure

Base Database using Oracle Enterprise Edition or Oracle Standard Edition 2 databases

Oracle Exadata Database

Autonomous Database on dedicated Exadata infrastructure

Oracle Database Service for Azure offers the following products:
Oracle Exadata Database: You can provision flexible Exadata systems that allow you to add database compute servers and storage servers to your system at any time after provision-ing.
Autonomous Database on shared Exadata infrastructure: Autonomous Database pro-vides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database administration.
Base Database: Using OracleDB for Azure, you can deploy Oracle Enterprise Edition or Oracle Standard Edition 2 databases on virtual machine DB systems. You can deploy single-node systems or 2-node RAC systems.
MySQL Database with HeatWave: MySQL Database Service is a fully managed Oracle Cloud native service available through OracleDB for Azure. It is developed, managed, and supported by the MySQL team in Oracle. Optionally, you can add a HeatWave cluster to a MySQL DB system. HeatWave is a distributed, scalable, shared-nothing, in-memory, hybrid columnar, query processing engine designed for extreme performance.
Hence, “Autonomous Database on dedicated Exadata infrastructure” is NOT available and hence the CORRECT ANSWER.

QUESTION 22
Which type of traffic is NOT supported by the OCI-Azure Interconnect?

Traffic between an Azure VNet and peered OCI VCNs in different regions

Traffic between an on-premises network and Azure VNet through the OCI VCN

Traffic between an Azure VNet and an OCI VCN

Traffic between an Azure VNet and peered OCI VCNs in the same region

You can connect your VNet and VCN so that traffic that uses private IP addresses goes over the cross-cloud connection.
The connection enables traffic to flow from the VNet through the connected VCN to a peered VCN in the same Oracle Cloud Infrastructure region, or a different region.
The Cross-cloud connection does not enable traffic between your on-premises network through the VCN to the VNet, or from your on-premises network through the VNet to the VCN.

QUESTION 23
Which is NOT a security capability available with OracleDB for Azure?

IPsec tunnel

Encryption of data at rest and in transit

Automatic security updates for the database

Security features such as network isolation and access controls

QUESTION 24
Which components are required to establish a cross-cloud connection between Microsoft Azure and Oracle Cloud Infrastructure?

Azure Site-to-Site VPN and OCI Site-to-Site VPN

Azure Load Balancer and OCI Load Balancer

Azure ExpressRoute circuit and Oracle FastConnect virtual circuit

Azure Virtual Network and OCI Virtual Cloud Network

For cross-cloud networking between Oracle Cloud and Microsoft Azure, set up a connection be-tween a FastConnect circuit in Oracle Cloud and an ExpressRoute circuit in Microsoft Azure.

QUESTION 25
What is the primary difference between using Oracle FastConnect with an Oracle partner and using FastConnect with colocation with Oracle?

The method of establishing the physical connection to Oracle Cloud Infrastructure

The number of available redundancy models

The type of virtual circuits supported

The geographical locations available for connections

FastConnect: With an Oracle Partner:
You can establish a FastConnect connection from your on-premise or remote data center to the data center where your Oracle Cloud resources are provisioned by requesting cloud connectivity services from any of Oracle’s FastConnect partners. Oracle has integrated the FastConnect service with a geographically diverse set of IP, VPN, and Ethernet network providers and cloud exchanges to make it easy for you to establish a connection to Oracle Cloud services.

FastConnect: Colocation with Oracle:
If you have purchased colocation space from a data center provider, you can use Oracle FastCon-nect to establish connectivity from your network equipment in that colocation facility to your Oracle Cloud services provisioned at this location. Oracle will provide you a letter of authorization (LOA) that the data center provider will need in order to establish a direct cross-connect into Oracle’s FastConnect edge devices provider will need in order to establish a direct cross

QUESTION 26
Which database system does NOT require an Azure Virtual Network during provisioning?

MySQL Database with HeatWave

Base Database with Oracle Enterprise Edition or Oracle Standard Edition 2

Autonomous Database on shared Exadata infrastructure

Oracle Exadata Database

See the screenshots below for the databases mentioned in the question:
You can
see the Azure Virtual Network option for Base Database, MySQL Database with Heat-Wave and Oracle Exadata Database.
Base Database: Requires Azure Virtual Network
MySQL Database with HeatWave: Requires Azure Virtual Network

Oracle Exadata Database : Requires Azure Virtual Network

Autonomous Database on shared Exadata infrastructure: DOES NOT require an Azure VNeT

QUESTION 27
A company has deployed a multi-tier application in Oracle Cloud Infrastructure (OCI), with web servers in a public subnet and database servers in a private subnet. The database servers need to ac-cess data from OCI Object Storage, and the company wants to ensure that this communication is secure and not exposed to the public internet. Which OCI feature should be used to achieve this objective?

Use a Local Peering Gateway to peer with the Object Storage subnet.

Use a Service Gateway to establish a secure connection to Object Storage.

Use a NAT Gateway to enable private access to Object Storage.

Use a VPN Gateway to create an encrypted tunnel to Object Storage.

A service gateway lets your virtual cloud network (VCN) privately access specific Oracle services without exposing the data to the public internet. No internet gateway or NAT gateway is required to reach those specific services.
The resources in the VCN can be in a private subnet and use only private IP addresses. The traffic from the VCN to the Oracle service travels over the Oracle network fabric and never traverses the internet.

QUESTION 28
What is the purpose of identity federation in the context of OracleDB for Azure?

To link Azure subscriptions to your OCI tenancy

To allow users to log in to the OCI Console using the same Azure credentials

To enable bidirectional communication between applications in the Azure tenancy and the database resources in OracleDB for Azure

To provide a way for customers to manage database resources in OracleDB for Azure without using the OCI Console

Azure users log into OracleDB for Azure using their Azure credentials, and OracleDB for Azure streams much of the day-to-day operational data from the OracleDB for Azure managed OCI data-bases to Azure Application Insights and Azure Log Analytics. Because of this, Azure developers spend most of their time in Azure.
In some instances, an OracleDB for Azure user must log into the OCI Console to perform specific tasks that aren’t enabled or available in OracleDB for Azure today. To make this process easier, Az-ure customers setup identity federation between the Azure and OCI tenancies. With this in place, authorized users use a single set of credentials, their Azure credentials, to log into Azure and OCI

QUESTION 29
What Azure admin roles are required for an Azure user to use the fully-automated onboarding op-tion for OracleDB for Azure?

Network Contributor, Security Reader, User Access Administrator, or Virtual Machine Contributor

Application Administrator, Cloud Application Administrator, Privileged Role Adminis-trator, or Global Administrator

Key Vault Administrator, Log Analytics Contributor, or Security Manager

Resource Group Contributor, Subscription Contributor, Backup Contributor, or Stor-age Account Contributor

The automated onboarding process requires that the Azure user onboarding to OracleDB for Az-ure have at least one of the following admin roles:
Application Administrator, Cloud Application Administrator, Privileged Role Administrator, or Global Administrator.

QUESTION 30
What is the primary Oracle Cloud Infrastructure region associated with an OCI account during Ora-cleDB for Azure setup?

The region specified during OracleDB for Azure onboarding

The region with the most available resources for OracleDB for Azure

The region with the lowest latency for Azure communication

The home region of the OCI account

Identify the primary OCI region you want to use as your default region for OracleDB for Azure resource provisioning.
During OracleDB for Azure setup, this region becomes the primary OCI region associated with your OCI account.

QUESTION 31
What is the primary Oracle Cloud Infrastructure region associated with an OCI account during Ora-cleDB for Azure setup?

The region with the most available resources for OracleDB for Azure

The home region of the OCI account

The region with the lowest latency for Azure communication

The region specified during OracleDB for Azure onboarding

QUESTION 32
Which is a database service that CANNOT be provisioned in the Oracle Public Cloud?

Autonomous Database on Dedicated Infrastructure

Exadata Database Service on Shared Infrastructure

Autonomous Database on Shared Infrastructure

Exadata Database Service on Dedicated Infrastructure