Limited-Time Offer: Enjoy 60% Savings! - Ends In 0d 00h 00m 00s Coupon code: 60OFF
Welcome to QA4Exam
Logo

- Trusted Worldwide Questions & Answers
Mail Us support@qa4exam.com
0
Menu

Most Recent Oracle 1Z0-997-23 Exam Questions & Answers


Prepare for the Oracle Cloud Infrastructure 2023 Architect Professional exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Oracle 1Z0-997-23 exam and achieve success.

The questions for 1Z0-997-23 were last updated on Jan 18, 2025.
  • Viewing page 1 out of 3 pages.
  • Viewing questions 1-5 out of 13 questions
Get All 13 Questions & Answers
Question No. 1

Challenge 2 - Task 2 of 5

Deploy a Serverless Function and Access Using an API Gateway

Deployment in OCI

Scenario

You have joined ACME as their new Cloud Solutions Architect. Your organization wants to verify if

they can execute their microservices deployed as serverless functions on another cloud provider

using Oracle Functions in OCI.

Preconfigured

To complete this requirement, you are provided with the following:

* Access to an OCI Tenancy, an assigned compartment, and OCI credentials.

* Access to Cloud Shell to execute the Fn CLI and Docker commands.

* Code for a sample Python function, ExamFunction-main.zip.

* Permissions to perform only the tasks within the challenge.

Note: Throughout your exam, ensure to use assigned Compartment 99248134-

C01and Region us-ashburn-1

Complete the following task:

In the field below, write an IAM policy statement that allows API Gateway to access Oracle Functions

in your compartment.

Show Answer Hide Answer
Correct Answer: A

One possible IAM policy statement that allows API Gateway to access Oracle Functions in your compartment is:

ALLOW any-user to use functions-family in compartment <your-compartment-name> where ALL {request.principal.type = 'ApiGateway', request.resource.compartment.id = '<your-compartment-OCID>'}

This statement grants the any-user group the permission to use the functions-family resource type in the specified compartment, but only if the request is coming from an API Gateway and the function belongs to the same compartment as the API Gateway. For more information, see Create a Policy to Give API Gateways Access to Functions.


Question No. 2

A large E-commerce company is looking to run seasonal workloads in Oracle Cloud

Infrastructure. The Oracle database used by their E-commerce application can use up to 52

cores at peak workloads. Due to the seasonal nature of the business, the database will be not

be used for 10 months in a year and can also be shut down during non-business hours.

Show Answer Hide Answer
Correct Answer: A

Option A is correct because using Autonomous Transaction Processing with shared Exadata infrastructure is the most suitable option for running seasonal workloads in Oracle Cloud Infrastructure. Autonomous Transaction Processing is a fully managed, serverless, and elastic database service that can scale up or down automatically based on the workload demand. It also supports stopping and starting the database to save costs when it is not in use. It runs on Exadata infrastructure, which provides high performance, availability, and security for transactional and mixed workloads12.

Option B is incorrect because using Oracle Cloud Infrastructure Exadata DB Systems is not optimal for running seasonal workloads in Oracle Cloud Infrastructure. Exadata DB Systems are dedicated, high-performance database systems that can run multiple databases with different shapes and versions. However, they are not serverless or elastic, and they do not support stopping and starting the database. They are more suitable for mission-critical and steady-state workloads that require consistent performance and availability3 .

Option C is incorrect because using Oracle Cloud Infrastructure Virtual Machine DB Systems is not optimal for running seasonal workloads in Oracle Cloud Infrastructure. Virtual Machine DB Systems are flexible and cost-effective database systems that can run single-node or RAC databases with different shapes and versions. However, they are not serverless or elastic, and they do not support stopping and starting the database. They are more suitable for development, testing, or production workloads that require moderate performance and availability .

Option D is incorrect because using Oracle Cloud Infrastructure Bare Metal DB Systems is not optimal for running seasonal workloads in Oracle Cloud Infrastructure. Bare Metal DB Systems are high-performance database systems that run single-node databases with locally attached NVMe storage. However, they are not serverless or elastic, and they do not support stopping and starting the database. They are more suitable for high-performance, latency-sensitive, specialized, or traditional workloads that require full control over the entire cloud stack .


Question No. 3

You designed and deployed your Autonomous Data Warehouse (ADW) so that it is

accessible from your on-premise data center and servers running on both private and public

networks in Oracle Cloud Infrastructure (OCI).

As you are testing the connectivity to your ADW database from the different access paths, you

notice that the server running on the private network is unable to connect to ADW.

Which two steps do you need to take to enable connectivity from the server on the private network to

ADW? (Choose two.)

Show Answer Hide Answer
Correct Answer: B, E

Option A is incorrect because adding an entry in the Security List of the ADW allowing ingress traffic for CIDR block 10.2.2.0/24 will not enable connectivity from the server on the private network to ADW.This is because ADW does not use security lists to control access to its database service2.

Option B is correct because adding an entry in the route table (associated with the private subnet) with destination of 0.0.0.0/0; target type of NAT Gateway, will allow outbound internet access from the server on the private network without exposing its private IP address3. Additionally, adding a stateful egress rule to the security list (associated with the private subnet) with destination of 0.0.0.0/0 and for all IP protocols will allow outbound traffic from any source port to any destination port.

Option C is incorrect because adding an entry in the access control list of ADW for IP address 129.146.160.11 will not enable connectivity from the server on the private network to ADW. This is because this IP address belongs to the NAT gateway, not to the server on the private network.

Option D is incorrect because adding an entry in the route table (associated with the private subnet) with destination of 0.0.0.0/0; target type of Internet Gateway, will expose the private IP address of the server on the private network to the public internet3. This is not recommended for security reasons and may also cause routing conflicts.

Option E is correct because adding an entry in the access control list of ADW for CIDR block 10.2.2.0/24 will allow access from any IP address within that range, including the server on the private network2.


Question No. 4

You are working as a solution architect with a global automotive provider who is looking to

create a multi-cloud solution. They want to run their application tier in * Deploy the Oracle

database system into a public subnet in your VCN and assign a public IP address. Connect your

application tier running in Azure to the public IP address of the database system over the

internet.

Microsoft Azure while utilizing the Oracle DB Systems in the Oracle Cloud Infrastructure (OCI).

What is the most-fault tolerant and secure solution for this customer? (Choose the best answer.)

Show Answer Hide Answer
Correct Answer: A

Option A is correct because creating a FastConnect virtual circuit with Microsoft Azure as the provider to establish a private interconnect between the application tier running in the Azure Virtual Network and the OCI VCN that contains the Oracle Databases is the most-fault tolerant and secure solution for this customer. This option provides low latency, high throughput, and consistent network performance across the clouds.It also avoids exposing the traffic to the public internet, which enhances security and reliability12.

Option B is incorrect because creating an encrypted, Virtual Private Network connection between the Microsoft Azure Virtual Network that contains the application tier and the OCI Virtual Cloud Network (VCN) that contains the Oracle Databases is not as fault-tolerant and secure as option A.This option relies on the public internet for connectivity, which can introduce latency, bandwidth limitations, and security risks12.

Option C is incorrect because using an OCI Virtual Cloud Network remote peering connection to create a remote network connection between the application tier running in Microsoft Azure Virtual Network and Oracle Databases running in the OCI Virtual Cloud Network (VCN) is not possible. Remote peering connections can only be used to connect two VCNs within the same region or across regions within OCI.They cannot be used to connect a VCN with a VNet in another cloud provider3.


Question No. 5

You are running a mission-critical database application in Oracle Cloud Infrastructure (OCI).

You regular backups of your DB system to OCI Object Storage. Recently, you notice a failed

database back status in the console. * Ensure that the database is not active and running while

the backup is in progress.

What troubleshooting action can you perform to determine the cause of the backup failure?

Show Answer Hide Answer
Correct Answer: C

Option A is incorrect because restarting the dcsagent program might be necessary if it has the status of stop/waiting to resolve a backup failure1. This is one of the possible database service agent issues that can cause backup failures.

Option B is incorrect because setting the database archiving mode to NOARCHIVELOG will prevent you from performing online backups.You need to set the database archiving mode to ARCHIVELOG to enable online backups1. This is one of the possible database issues that can cause backup failures.

Option C is correct because ensuring that your database host can connect to OCI Object Storage is essential for performing backups.You need to check the object store connectivity issues that can cause backup failures, such as firewall rules, proxy settings, network routes, and security lists1.


Unlock All Questions for Oracle 1Z0-997-23 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 13 Questions & Answers
Explore Other Oracle Exams