Free Oracle 1Z0-997-24 Exam Questions

Question 1

You have been asked to create a mobile application which will be used for submitting orders by users of a

popular E-Commerce site. The application is built to work with Autonomous Transaction Processing -

Serverless (ATP-S) databaseas the backend and HTML5 on Oracle Application Express as the front end.

During the peak usage of the application you notice that the application response time is very slow. ATP-S

database is deployed with 3 CPU cores and 1 TB of memory.

Which two optionsare expensive or impractical ways to improve the application response times?

A : entify the maximum memory capacity needed for peak times and scale the memory for the ATP-S database to that number. ATP-S will scale the memory down when not needed.

B : ethe Machine Learning (ML) feature of the ATP-S database iteratively to tune the SQL queries used by the application

C : ale up CPU core count and memory during peak times.

D : able auto scaling for CPU cores on ATP-S database.

E : entify the maximum CPU capacity needed for peak times and scale the CPU core count for the ATP-S database to that number. ATP-S will scale the CPU core count down when not needed.

Answer: A,C

Question 2

Your company has recently deployed a new web application that uses Oracle functions Your manager

Instructed you to Implement major manage your systems more effectively. You know that Oracle functions

automatically monitors functions on your behalf reports metrics through Service Metrics.

Which two metrics are collected and made available by this feature?

A : ngth of time a function runs

B : mber of times a function is removed

C : mber of times a function isinvoked

D : ount of CPU used by a function

E : mber of concurrent connections

Answer: A,C

Question 3

You are working as a solution architect for an online retail store to create a portal to allow the users to pay for

their groceries using credit cards. Since the application is not fully compliantwith the Payment Card Industry

Data Security Standard (PCI DSS), your company is looking to use a third party payment service to process

credit card payments.

The third party service allows a maximum of Spelunk IP addresses 5 public IP addresses at a timeHowever,

your website is using Oracle Cloud Infrastructure (OCI) Instance Pool Auto Scaling policy to create up to

create up to 15 Instances during peak traffic demand, which are launched In VCN private in VCN private

subnets and attached to an OCI public Load Balancer. Upon user payment, the portal connects to the payment

service over the Interne! to complete the transaction

What solution can you implement to make sure that all compute Instances can connect to the third party

system to process the payments aw peak traffic demand?

A : ute credit card payment request from the compute instances through the NAT Gateway. On the third-party services, whitelist the public IP associated with the NAT Gateway

B : eate an OCI Command Line Interface (CLI) scriptto automatically reserve public IP address for the compute instances. On the third-party services, whitelist the Reserved public IP

C : itelist the Internet Gateway Public IP on the third party service and route all payment requests through the InternetGateway

D : ute payment request from the compute instances through the OCI Load Balancer, which will then be routed to the third party service

Answer: A

Question 4

A cloud consultant is working onimplementation project on OCI. As part of the compliance requirements, the

objects placed in object storage should be automatically archived first and then deleted. He is testing a

Lifecycle Policy on Object Storage and created a policy as below:

[ { "name": "Archive_doc", "action": "ARCHIVE", "objectNameFilter": { "inclusionPrefixes": "doc"] },

"timeAmount": 5, "timeunit": "DAYS", "isEnabled": true },

{ "name": "Delete_doc", "action": "DELETE", "objectNameFilter": "inclusionPrefixes": [ "doc"]

1."timeAmount": 5, "timeunit": "DAYS", "isEnabled": true }

What will happen after this policy is applied?

A : l objects with names starting with "doc" will be deleted after 5 days of object creation

B : l the objects having file extension ".doc" will be archivedfor 5 days and will be deleted 10 days after object creation

C : l the objects having file extension ".doc" will be archived 5 days after object creation

D : l the objects with names starting with "doc" will be archived 5 days after object creation andwill be deleted 5 days after archival

Answer: A

Question 5

A large financialcompany has a web application hosted in their on-premises data center. They are migrating

their application to Oracle Cloud Infrastructure (OCI) and require no downtime while the migration is

on-going. In order to achieve this, they have decided to divertonly 30% of the application works fine, they

divert all traffic to OCI.

As a solution architect working with this customer, which suggestion should you provide them?

A : OCI Traffic management with failover steering policy and distribute the trafficbetween OC1 and on premises infrastructure.

B : OCI Traffic management with Load Balancing steering policy and distribute the traffic between OCI and on premises infrastructure.

C : an OCI load Balancer and distribute the traffic between OCI and on premises infrastructure.

D : VPN connectivity between on premises Infrastructure and OCI, and create routing tables to distribute the traffic between them

Answer: B