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

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

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

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.


Question No. 4

(OCI) in two weeks. Their data center has been recently struck by a massive

hurricane and the building has been badly damaged, although still operational. They have a 100

Mbps Internet line but the connection is intermittent due to the damages caused to the electrical

grid.

In this scenario, what is the most effective service to use to migrate the data to OCI given the

time constraints? (Choose the best answer.)

Show Answer Hide Answer
Correct Answer: A

Option A is correct because using multiple OCI Data Transfer Appliances to transfer data to OCI is the most effective service to use to migrate the data to OCI given the time constraints. This option can securely move terabytes or petabytes of data between on-premises data centers and the cloud in days instead of weeks or months.It also avoids using the public internet, which can be slow, unreliable, and expensive45.

Option B is incorrect because setting up an OCI Storage Gateway to connect your data center and your VCN and uploading all data to OCI is not effective given the time constraints. This option requires using the public internet, which can be intermittent due to the damages caused by the hurricane.It also requires installing and configuring a software appliance on your premises, which can add complexity and overhead6.

Option C is incorrect because setting up a hybrid network by launching a 1Gbps FastConnect virtual circuit between your data center and OCI and using OCI Object Storage multipart upload tool to automate the migration of your data to OCI is not feasible given the time constraints. This option requires provisioning a FastConnect circuit, which can take several days or weeks depending on your network provider. It also requires using a public internet backup path, which can be unreliable due to the hurricane .

Option D is incorrect because setting up an OCI Storage Gateway to connect your data center and your VCN and uploading all data to OCI using OCI Storage Gateway Cloud Sync tool is not effective given the time constraints. This option requires using the public internet, which can be intermittent due to the damages caused by the hurricane.It also requires installing and configuring a software appliance on your premises, which can add complexity and overhead6.

Option E is incorrect because uploading the data to OCI using OCI Object Storage multipart upload tool is not effective given the time constraints. This option requires using the public internet, which can be slow, unreliable, and expensive due to the hurricane and the large amount of data involved


Question No. 5

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.


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