Oracle Oracle Certifications 1Z0-997 Questions & Answers

• Question 11:

  A cloud consultant is working on implementation 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. All objects with names starting with "doc" will be deleted after 5 days of object creation

  B. All the objects having file extension ".doc" will be archived for 5 days and will be deleted 10 days after object creation

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

  D. All the objects with names starting with "doc" will be archived 5 days after object creation and will be deleted 5 days after archival

  Correct Answer: A

  Object Lifecycle Management works by defining rules that instruct Object Storage to archive or delete objects on your behalf within a given bucket. A bucket's lifecycle rules are collectively known as an object lifecycle policy. You can use a rule to either archive or delete objects and specify the number of days until the A rule that deletes an object always takes priority over a rule that would archive that same object.

• Question 12:

  A manufacturing company is planning to migrate their on-premises database to OCI and has hired you for

  the migration. Customer has provided following information regarding their existing onpremises database:

  Database version, host operating system and version, database character set, storage for data staging,

  acceptable length of system outage.

  What additional information do you need from customer in order to recommend a suitable migration

  method? Choose two

  A. Elapsed time since database was last patched

  B. On-premises host operating system and version

  C. Number of active connections

  D. Data types used in the on-premises database

  E. Top 5 longest running queries

  Correct Answer: BD

  Not all migration methods apply to all migration scenarios. Many of the migration methods apply only if specific characteristics of the source and destination databases match or are compatible. Moreover, additional factors can affect which method you choose for your migration from among the methods that are technically applicable to your migration scenario. Some of the characteristics and factors to consider when choosing a migration method are: On-premises database version Database service database version On-premises host operating system and version On-premises database character set Quantity of data, including indexes Data types used in the on-premises database Storage for data staging Acceptable length of system outage Network bandwidth

• Question 13:

  An OCI Architect is working on a solution consisting of analysis of data from clinical trials of a pharmaceutical company. The data is being stored in OCI Autonomous Data Warehouse (ADW) having 8 CPU Cores and 70 TB of storage. The architect is planning to setup autoscaling to respond to dynamic changes in the workload. Which of the following needs to be considered while configuring auto scaling? Choose two

  A. Enabling auto scaling does not change the concurrency and parallelism settings

  B. Auto scaling also scales IO throughput linearly along with CPU

  C. The database memory SGA and PGA will not get affected by the changes in the number of CPUs during auto scaling

  D. The maximum CPU cores that will be automatically allocated for this database is 16 CPUs

  Correct Answer: AB

  Auto scaling is enabled by default when you create an Autonomous Database instance or you can use Scale Up/Down on the Oracle Cloud Infrastructure console to enable or disable auto scaling. With auto scaling enabled the database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required. Enabling auto scaling does not change the concurrency and parallelism settings for the predefined services IO throughput depends on the number of CPUs you provision and scales linearly with the number of CPUs.

• Question 14:

  A startup company is looking for a solution for processing of data transmitted by the IOT devices fitted to transport vehicles that carry frozen foods. The data should be consumed and processed in real time. The processed data should be archived to OCI Object Storage bucket. and use Autonomous Data warehouse (ADW) to handle analytics. Which architecture will help you meet this requirement?

  A. Use OCI Streaming Service to collect the incoming biometric data. Use an open source Hadoop cluster to analyze the data horn streaming service. Store the results to OCI Autonomous Data warehouse (ADW) to handle complex analytics

  B. Use OCI Streaming Service to collect the incoming biometric data. Use Oracle Functions to process the date and show the results on a real-time dashboard and store the results lo OCI Object Storage Store the data In OCI Autonomous Data warehouse (ADW) to handle analytics.

  C. Create an OCI Object Storage bucket to collect the incoming biometric data from the smart pet collar Fetch the data horn OC\ Object storage to OCI Autonomous Data Warehouse (ADW) every day and run analytics Jobs with it

  D. Launch an open source Hadoop cluster to collect the Incoming biometrics data Use an Open source Fluentd cluster to analyze the- data me results to OCI Autonomous Transaction Processing (ADW)to handle complex analytics

  Correct Answer: B

  Real-time processing of high-volume streams of data

  - OCI Streaming service provides a fully managed, scalable, durable storage option for continuous, highvolume streams of data that you can consume and process in real-time

  -Use cases Log and Event data collection Web/Mobile activity data ingestion IoT Data streaming for processing and alerts Messaging: use streaming to decouple components of large systems

  - Oracle managed service with REST APIs (Create, Put, Get, Delete)

  -Integrated Monitoring

• Question 15:

  You are working as a security consultant with a global insurance organization which is using Microsoft Azure Active Directory (AD) as identity provided to manager user login/passwords. When a user logs in to Oracle Cloud infrastructure (OCI) console, it should get authenticated by Azure AD. Which set of steps are required to configure at OCI side in order to get it enabled

  A. Setup Azure AD as an Enterprise Application, map Azure AD users and groups and policies to OCI groups and users

  B. Setup Azure AD as an Identity Provider, Import users and groups from Azure AD to OCI, set up IAM policies to govern access to Azure AD groups

  C. Setup Azure AD as an Enterprise Application, configure OCI for single sign-on, map Azure AD groups to OCI groups, set up the IAM policies to govern access to Azure AD groups

  D. Setup Azure AD as an Identity Provider, map Azure AD groups to OCI groups, set up the IAM policies to govern access to Azure AD groups

  Correct Answer: D

  Federating with Microsoft Azure Active Directory To federate with Azure AD, you set up Oracle Cloud Infrastructure as a basic SAML single sign-on application in Azure AD. To set up this application, you perform some steps in the Oracle Cloud Infrastructure Console and some steps in Azure AD. Following is the general process an administrator goes through to set up the federation. Details for In Oracle Cloud Infrastructure, download the federation metadata document. In Azure AD, set up Oracle Cloud Infrastructure Console as an enterprise application. In Azure AD, configure the Oracle Cloud

  Infrastructure enterprise application for single sign-on.

  In Azure AD, set up the user attributes and claims.

  In Azure AD, download the Azure AD SAML metadata document.

  In Azure AD, assign user groups to the application.

  In Oracle Cloud Infrastructure, set up Azure AD as an identity provider. In Oracle Cloud Infrastructure, map

  your Azure AD groups to Oracle Cloud Infrastructure groups. In Oracle Cloud Infrastructure, set up the IAM

  policies to govern access for your Azure AD groups. Share the Oracle Cloud Infrastructure sign-in URL

  with your user

• Question 16:

  You want to automate the processing of new Image files to generate thumbnails. the expected rate is 10

  new files every hour.

  Which of the following is the most cost effective option to meet this requirement in Oracle Cloud

  Infrastructure (OCI)?

  A. Upload files to an OCI Object storage bucket. Every time a file is uploaded, an event is emitted. Write a rule to filter these events with an action to trigger a function in Oracle Functions. The function processes the image in the file and stores the thumbnails back in an Object storage bucket.

  B. Upload files to an OCI Object storage bucket. Every time a file is uploaded, trigger an event with an action to provision a compute instance with a cloud-init script to access the file, process it and store it back in an Object storage bucket. Terminate the instance using Autoscaling policy after the processing is finished.

  C. Build a web application to ingest the files and save them to a NoSQL Database. Configure OCI Events service to trigger a notification using Oracle Notification Service (ONS). ONS invokes a custom application to process the image files to generate thumbnails. Store thumbnails in a NoSQL Database table.

  D. Upload all files to an Oracle Streaming Service (OSS) stream. Set up a cron job to invoke a function in Oracle Functions to fetch data from the stream. Invoke another function to process the image files and generate thumbnails. Store thumbnails in another OSS stream.

  Correct Answer: A

  You can invoke a function that you've deployed to Oracle Functions by triggered by an event in the Events service when update the Object storage to fetch the data then the function can process the File and store back to Object storage

  

• Question 17:

  An upcoming e-commerce company has deployed their online shopping application on OCI. The application was deployed on compute instances with autoscaling configuration for application servers fronted by a load balancer and OCI Autonomous Transaction Processing (ATP) in the backend. In order to promote their e-commerce platform 50% discount was announced on all the products for a limited period. During the day 1 of promotional period it was observed that the application is running slow and company's hotline is flooded with complaints. What could be two possible reasons for this situation?

  A. The health check on some of the backend servers has failed and the load balancer has taken those servers temporarily out of rotation

  B. As part of autoscaling, the load balancer shape has dynamically changed to a larger shape to handle more incoming traffic and the system was slow for a short time during this change

  C. The health check on some of the backend servers has failed and the load balancer was rebooting these servers.

  D. The autoscaling has already scaled to the maximum number of instances specified in the configuration and there is no room of scaling

  Correct Answer: AD

• Question 18:

  You are creating an Oracle Cloud Infrastructure Dynamic Group. To determine the members of this group

  you are defining a set of matching rules.

  Which of the following are the supported variables to define conditions in the matching rules? (Choose

  Two)

  A. iam.policy.id - the OCID of the IAM policy to apply to the group.

  B. instance.tenancy.id - the OCID of the tenancy where the instance resides.

  C. tag...value - the tag namespace and tag key.

  D. instance.compartment.id - the OCID of the compartment where the instance resides.

  Correct Answer: CD

  You can define the members of the dynamic group based on the following:

  -compartment ID

  -instance ID

  -

  tag namespace and tag key

  -

  tag namespace, tag key, and tag value

  Supported variables are:

  instance.compartment.id - the OCID of the compartment where the instance resides instance.id - the OCID

  of the instance

  tag...value - the tag namespace and tag key. For example,

  tag.department.operations.value .

  tag...value='' - the tag namespace, tag key, and tag value. For

  example, tag.department.operations.value='45'

• Question 19:

  A customer is in a process of shifting their web based Sales application from their own data center located in US West to OCI India West (Mumbai) region. They want to do it in a controlled manner and initially only 1% of the traffic will be steered to the servers in OCI. After verification of everything is working as expected, the company is gradually planning to increase the ratio until they are comfortable with fully migrating all traffic to OCI. Which of the following solution can be used in this situation?

  A. OCI DNS and Traffic Management with Geolocation Steering policy

  B. OCI DNS and Traffic Management with Failover Steering policy

  C. OCI DNS and Traffic Management with Load Balancer Steering policy

  D. OCI DNS and OCI Load Balancer Service

  Correct Answer: C

  STEERING POLICIES is A framework to define the traffic management behavior for your zones. Steering

  policies contain rules that help to intelligently serve DNS answers.

  FAILOVER

  Failover policies allow you to prioritize the order in which you want answers served in a policy (for

  example, Primary and Secondary). Oracle Cloud Infrastructure Health Checks are leveraged to determine

  the health of answers in the policy. If the Primary Answer is determined to be unhealthy, DNS traffic will

  automatically

  be steered to the Secondary Answer.

  LOAD_BALANCE

  Load Balancer policies allow distribution of traffic across multiple endpoints. Endpoints can be assigned

  equal weights to distribute traffic evenly across the endpoints or custom weights may be assigned for ratio

  load balancing. Oracle Cloud Infrastructure Health Checks are leveraged to determine the health of the

  endpoint. DNS traffic will be automatically distributed to the other endpoints, if an endpoint is determined to

  be unhealthy.

  ROUTE_BY_GEO

  Geolocation-based steering policies distribute DNS traffic to different endpoints based on the location of

  the end user. Customers can define geographic regions composed of originating continent, countries or

  states/provinces (North America) and define a separate endpoint or set of endpoints for each region.

  ROUTE_BY_ASN

  ASN-based steering policies enable you to steer DNS traffic based on Autonomous System Numbers

  (ASN).

  DNS queries originating from a specific ASN or set of ASNs can be steered to a specified endpoint.

  ROUTE_BY_IP

  IP Prefix-based steering policies enable customers to steer DNS traffic based on the IP Prefix of the

  originating query.

• Question 20:

  You are helping a customer troubleshoot a problem. The customer has several Oracle Linux servers in

  Based on cost considerations, which option will fix this Issue?

  A. Create a Public Load Balancer In front of the servers and add the servers to the Backend Set of the Public Load Balancer.

  B. Create another Internet Gateway and configure it as route target for the private subnet.

  C. Implement a NAT instance In the public subnet of the VCN and configure the NAT instance as the route target for the private subnet.

  D. Create a NAT gateway in the VCN and configure the NAT gateway as the route target for the private subnet.

  Correct Answer: A