Oracle 1Z0-1115-23 Online Practice Questions and Exam Preparation

Oracle 1Z0-1115-23 Online Questions & Answers

• Question 1:

  A company has deployed an application in Oracle Cloud Infrastructure consisting of multiple web servers, database servers, and application servers. The company wants to restrict communication be-tween these components, allowing only the necessary traffic between them. Which OCI feature would be most suitable to achieve this objective?

  A. Use Virtual Cloud Networks to create isolated networks for each component.
  B. Use Security Lists to configure network access rules for the entire Virtual Cloud Net- work.
  C. Use Network Security Groups to apply specific firewall rules for each component.
  D. Use Route Tables to define custom routing policies between each component.
  C. Use Network Security Groups to apply specific firewall rules for each component.

  ---

  Explanation/Reference:

  Network security groups (NSGs) act as a virtual firewall for your compute instances . An NSG consists of a set of ingress and egress security rules that apply only to a set of VNICs of your choice in a single VCN (for example: all the compute

  instances that act as web servers in the web tier of a multi-tier application in your VCN). Hence, "Use Network Security Groups to apply specific firewall rules for each component." is the CORRECT answer.

  In this question , you can straightaway reject "Use Virtual Cloud Networks to create isolated net-works for each component." and "Use Route Tables to define custom routing policies between each component." options.

  NSG wins here due to the keywords "restrict communication between these components" in the question. A network security group (NSG) provides a virtual firewall for a set of cloud re-sources that all have the same security posture.

• Question 2:

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

  A. MySQL Database with HeatWave
  B. Base Database with Oracle Enterprise Edition or Oracle Standard Edition 2
  C. Autonomous Database on shared Exadata infrastructure
  D. Oracle Exadata Database
  C. Autonomous Database on shared Exadata infrastructure

  ---

  Explanation/Reference:

  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

  

  

• Question 3:

  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?

  A. Availability Domains
  B. Remote region
  C. Fault Domains
  D. Local region
  C. Fault Domains

  ---

  Explanation/Reference:

  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 4:

  In the context of Oracle FastConnect, what are the two types of virtual circuits?

  A. Intra-Region and Inter-Region
  B. Layer 3 and Layer 4
  C. Standard and High-Performance
  D. Private and Public
  D. Private and Public

  ---

  Explanation/Reference:

  VIRTUAL CIRCUIT is an isolated network path that runs over one or more physical network connections to provide a single, logical connection between the edge of your existing network and Oracle Cloud Infrastructure. Private virtual circuits support private peering, and public virtual circuits support public peering.

• Question 5:

  What is the purpose of using Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) policies in a cross-cloud connection between Microsoft Azure and OCI?

  A. To control who can manage OCI route tables, network security groups, and security lists
  B. To control the location of the cross-cloud connection
  C. To control the type of traffic allowed between the Azure VNet and the OCI VCN
  D. To control the bandwidth of the connection between the Azure VNet and the OCI VCN
  A. To control who can manage OCI route tables, network security groups, and security lists

  ---

  Explanation/Reference:

  Controlling the Establishment of a Connection

  With Oracle Cloud Infrastructure IAM policies, you can control:

  Who in your organization has the authority to create a FastConnect virtual circuit. Who can manage route tables, network security groups, and security lists. Oracle and Microsoft have created a cross-cloud connection between Oracle Cloud

  Infrastructure and Microsoft Azure in certain regions. So, the option "To control the location of the cross-cloud connection" has nothing to do with IAM policies and hence is INCORRECT.

  The option "To control the type of traffic allowed between the Azure VNet and the OCI VCN" is also INCORRECT as you use Security Lists/Network Security Group to filter traffic and not IAM policies.

  IAM policies also have no role to play in determining the bandwidth of the connection.

• Question 6:

  You plan to use OracleDB Service for Azure to easily provision, access, and operate enterprise-grade Oracle Database services in Oracle Cloud Infrastructure (OCI) with a familiar Azure-like ex-perience. What should you do to sign up for the OracleDB for Azure service?

  A. Visit the sign up website at https://signup.multicloud.oracle.com/azure
  B. Visit the sign up website at https://signup.multicloud.azure.com/oracle
  C. Visit the Azure portal and navigate to the Oracle Database Service page.
  D. Contact Oracle support to request access to the service.
  A. Visit the sign up website at https://signup.multicloud.oracle.com/azure

  ---

  Explanation/Reference:

  To start OracleDB for Azure onboarding, go to https://signup.multicloud.oracle.com/azure Reference: OracleDB for Azure Onboarding Steps

• Question 7:

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

  A. Data Guard
  B. Diagnostic Packs
  C. Transparent Data Encryption
  D. In-Memory Database
  C. Transparent Data Encryption

  ---

  Explanation/Reference:

  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 8:

  An enterprise has a workload running in a VNet in Microsoft Azure and a database running in a VCN in Oracle Cloud Infrastructure. The enterprise wants to set up a private, secure, and isolated network connection between the two clouds to enable traffic flow between the workload and the database. Which option can be used to achieve this requirement?

  A. Use public internet to establish connectivity between the Microsoft Azure VNet and the OCI VCN.
  B. Use Azure VPN and Oracle FastConnect to establish a private and secure tunnel be- tween the Azure VNet and the OCI VCN.
  C. Use Azure Private Link to create a private connection between the workload and the database.
  D. Use Azure ExpressRoute and Oracle FastConnect to create a private interconnection between the Azure VNet and the OCI VCN.
  D. Use Azure ExpressRoute and Oracle FastConnect to create a private interconnection between the Azure VNet and the OCI VCN.

  ---

  Explanation/Reference:

  As per the question, the keywords are "The enterprise wants to set up a private, secure, and isolat-ed network connection between the two clouds" Use public internet to establish connectivity between the Microsoft Azure VNet and the OCI VCN - INCORRECT as this option won't provide private, secure and isolated connection. Use Azure VPN and Oracle FastConnect to establish a private and secure tunnel between the Azure VNet and the OCI VCN is INCORRECT as it won't provide a isolated connection. Use Azure Private Link to create a private connection between the workload and the database is INCORRECT as Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer- owned/partner services over a pri-vate endpoint in your virtual network. Use Azure ExpressRoute and Oracle FastConnect to create a private interconnection between the Azure VNet and the OCI VCN. is CORRECT. To create an integrated multi- cloud experience, Microsoft and Oracle offer direct interconnection between Azure and Oracle Cloud Infrastructure (OCI) through ExpressRoute and FastConnect. Through the ExpressRoute and FastConnect inter-connection, customers can experience low latency, high throughput, private direct connectivity be-tween the two clouds.

• Question 9:

  

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

  A. Network Contributor, Security Reader, User Access Administrator, or Virtual Machine Contributor
  B. Application Administrator, Cloud Application Administrator, Privileged Role Adminis- trator, or Global Administrator
  C. Key Vault Administrator, Log Analytics Contributor, or Security Manager
  D. Resource Group Contributor, Subscription Contributor, Backup Contributor, or Stor-age Account Contributor
  B. Application Administrator, Cloud Application Administrator, Privileged Role Adminis- trator, or Global Administrator

  ---

  Explanation/Reference:

  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.

  Reference: Fully-Automated Onboarding (oracle.com)

• Question 10:

  What is a key benefit of using Oracle Autonomous Database on Shared Exadata Infrastructure?

  A. Unlimited storage capacity
  B. Automatic database tuning and patching
  C. Seamless integration with third-party cloud providers
  D. Dedicated hardware resources for each database
  B. Automatic database tuning and patching

  ---

  Explanation/Reference:

  With Autonomous Database on shared Exadata infrastructure, you do not need to configure or manage any hardware or install any software. Autonomous Database handles provisioning the data-base, backing up the database, patching and upgrading the database, and growing or shrinking the database. Autonomous Database is a completely elastic service.An autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs.