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

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

Most Recent Oracle 1Z0-997-23 Exam Dumps

 

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 Jun 6, 2026.
  • Viewing page 1 out of 3 pages.
  • Viewing questions 1-5 out of 13 questions
Get All 13 Questions & Answers
Question No. 1

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. 2

Challenge 1

Implement Private DNS Names and Private DNS Resolver

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 Compartment99248134-

C01 and Region us-ashburn-1

Complete the following tasks in the provisioned OCI environment:

1. Create a new VCN with the name exam-vcn within your assigned compartment by using the

Start VCN Wizard.

2. Create a new Oracle Functions application named exam-app within your assigned

compartment by using the private subnet in your previously created VCN.

Ensure you use all defaults provided with the Create VCN with Internet Connectivity option.

Show Answer Hide Answer
Correct Answer: A

Here are the steps to complete the challenge:

To create a new VCN with the name exam-vcn within your assigned compartment by using the Start VCN Wizard, follow these steps:

In the OCI Console, go to Networking and click Virtual Cloud Networks.

Select your assigned compartment from the list on the left.

Click Start VCN Wizard.

Select Create VCN with Internet Connectivity and click Start VCN Wizard.

Enter exam-vcn as the VCN Name and leave the other fields as default. Click Next.

Review the summary and click Create. This will create a VCN with a public subnet, a private subnet, an internet gateway, a NAT gateway, a service gateway, and a route table.

To create a new Oracle Functions application named exam-app within your assigned compartment by using the private subnet in your previously created VCN, follow these steps:

In the OCI Console, go to Developer Services and click Functions.

Select your assigned compartment from the list on the left.

Click Create Application.

Enter exam-app as the Application Name and select your previously created VCN from the VCN dropdown menu.

Select the private subnet from the Subnet dropdown menu and leave the other fields as default. Click Create. This will create an Oracle Functions application that can run serverless functions in a private subnet.


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

Your company needs to migrate a business critical application from your data center to

Oracle Cloud Infrastructure (OCI). The application runs on Oracle * Deploy Virtual Machine RAC

DB system on OCI and use the Oracle Database Backup module with RMAN to migrate the

data from customer on-premises to OCI. The application server is WebLogic server running on

multiple 4-core servers and the database is deployed as an Oracle Database Enterprise Edition

RAC database on 2 servers (4-cores each). Which method of database migration should you

choose so that the application has minimal impact? (Choose the best answer.)

Show Answer Hide Answer
Correct Answer: A

Option A is correct because deploying a Virtual Machine RAC DB system on OCI and using the ZDM tool for the database migration is a method that can minimize the impact on the application. ZDM is a software solution that allows you to directly and seamlessly migrate your on-premises Oracle Databases to the Oracle Cloud, whether in OCI or ExaCC.ZDM supports a wide range of Oracle Database versions, and ensures that there is minimal to no production downtime during the migration1.ZDM also supports migrating RAC databases to RAC databases on OCI2.

Option B is incorrect because deploying an Autonomous Transaction Processing Database on OCI and using the MV2ADB tool for the database migration is not a suitable method for this scenario. MV2ADB is a command-line tool that allows migrating data from an Oracle database on-premise to Oracle Autonomous Database in ''one-click''.It is based on Oracle Data Pump export and import utility3.However, MV2ADB does not support migrating RAC databases to Autonomous Database, nor does it support migrating Enterprise Edition databases to Autonomous Database4.

Option C is incorrect because deploying an Exadata Cloud Service Base rack and using Oracle Data Pump tool to migrate the data from customer on-premises to OCI is not a method that can minimize the impact on the application.Oracle Data Pump is a technology that enables you to move data and metadata from one database to another5. However, Oracle Data Pump requires intermediate storage for the dump files, which can add complexity and overhead. It also requires downtime during the export and import operations, which can affect the availability of the application.


Question No. 5

A company runs a public-facing application that uses a Java-based web service via a

RESTful API in their on-premises data center. Use of the API is expected to double with a new

product launch. The business wants to migrate their application to Oracle Cloud Infrastructure

(OCI) to meet the scale and reliability requirements. In order to achieve this, they will divert only

40% of the traffic to the new Apache Tomcat web servers running on OCI and serve the

remaining 60% traffic through their on-premises infrastructure. Once the migration is complete

and application works fine, they will divert all traffic to OCI.

How can these requirements be met with the LEAST amount of effort?

Show Answer Hide Answer
Correct Answer: B

Option A is incorrect because using OCI Traffic management service with failover steering policy will not distribute the traffic between OCI and on premises infrastructure.Failover steering policy will only route traffic to a secondary endpoint if the primary endpoint is unresponsive2. This is not suitable for a gradual migration scenario.

Option B is correct because using OCI Traffic management service with Load Balancing steering policy will distribute the traffic between OCI and on premises infrastructure based on a ratio or round robin algorithm2. This will allow you to control the percentage of traffic that goes to the new infrastructure in OCI and monitor the results.

Option C is incorrect because using an OCI load Balancer will not distribute the traffic between OCI and on premises infrastructure.A load balancer will only distribute the traffic among multiple compute instances within a single region in OCI2. This will not help you migrate from your on premises infrastructure.

Option D is incorrect because using VPN connectivity between on premises Infrastructure and OCI and creating routing tables to distribute the traffic between them will require more effort than using OCI Traffic management service.You will need to set up a VPN connection, configure routing rules, and monitor the network performance2. This will not be as simple and reliable as using a DNS-based solution.


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