Oracle 1Z0-997-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-997-22 Online Questions & Answers

• Question 91:

  A2Z corporation is into e-commerce business and is the choice of millions for the best offers it launches. It has a rich set of intelligent applications that runs 24x7 and are very critical to their business.

  Continuous infrastructure management and maintenance, rise in customer base and workloads, have made them to think of migrating all workloads to cloud. They have selected Oracle Cloud Infrastructure for migrating both their application

  and database workload.

  You, as an oracle pre-sales consultant has been asked to provide complete migration strategy for their source database workloads which includes oracle and MSSQL. They are particularly concerned about their oracle databases which

  cannot afford any downtime. They would be establishing fast connect from their data center to oracle data center to avoid any network impact. Their oracle database is around 90TB and MSSQL is around 10TB.

  How would you propose the safe migration of customer database while meeting their availability requirement?

  A. Propose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle SQL Loader for MSSQL migration
  B. Propose the use of Oracle datapump for oracle databases and SQL Developer for MSSQL database
  C. Propose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle GoldenGate for MSSQL migration
  D. Propose the use of Oracle GoldenGate to perform zero downtime migration for both MSSQL and Oracle source databases
  C. Propose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle GoldenGate for MSSQL migration

• Question 92:

  A manufacturing company is planning to migrate their on-premises database to Oracle Cloud Infrastructure and has hired you for the migration. Customer has provided following information regarding their existing on-premises database:

  Database 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. On-Premises host operating system and version.
  B. Number of active connections.
  C. Data types used in the on-premises database.
  D. Elapsed time since database was last patched.
  E. Top 5 longest running queries.
  A. On-Premises host operating system and version.
  C. Data types used in the on-premises database.

• Question 93:

  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.
  C. tag...value - the tag namespace and tag key.
  D. instance.compartment.id - the OCID of the compartment where the instance resides.

  ---

  Explanation/Reference:

  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 94:

  You are the security architect for a medium sized e-commerce company that runs all of their applications in Oracle Cloud Infrastructure (OCI). Currently, there are 14 unique applications, each deployed and secured in their own compartment. The Operations team has procured a new monitoring tool that will be deployed throughout the OCI ecosystem. Their requirement is to deploy one management node into each compartment.

  Currently, the Operations team Identity and Access Management (IAM) group has the following policy: allow group OpsTeam to READ all-resources in tenancy

  Once the new monitoring nodes are deployed, the Operations team may need to stop, start, or reboot them occasionally.

  What is the most efficient solution to allow the Operations team to fully manage the monitoring nodes, without allowing them to alter other resources across the tenancy?

  A. In each of the 14 compartments, create a new policy with the following statement: allow group OpsTeam to manage instance-family in compartment XXX where XXX is the name of the compartment where you are creating the policy.
  B. Create a new policy in the root compartment with the following policy statement: allow group OpsTeam to manage instance-family in tenancy where ANY (request.operation ?`UpdateInstance', request.operation ?`InstanceAction')
  C. Tag all the monitoring nodes with the defined tag AllPolicy:AllowAccess:OpsTeam and write the following IAM policy: allow group OpsTeam to manage instance-family in tenancy where target.resource.tag.AllPolicy.AllowAccess ? `OpsTeam'
  D. Tag all the monitoring nodes with the free-form tag AllowAccess:OpsTeam and write the following IAM policy: allow group OpsTeam to manage instance-family in tenancy where target.resource.tag.AllowAccess = `OpsTeam'
  A. In each of the 14 compartments, create a new policy with the following statement: allow group OpsTeam to manage instance-family in compartment XXX where XXX is the name of the compartment where you are creating the policy.

• Question 95:

  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
  A. The health check on some of the backend servers has failed and the load balancer has taken those servers temporarily out of rotation
  D. The autoscaling has already scaled to the maximum number of instances specified in the configuration and there is no room of scaling

• Question 96:

  An organization has its IT infrastructure in a hybrid setup with an on-premises environment and an Oracle Cloud Infrastructure (OCI) Virtual Cloud Network (VCN) in the us-phonix-1 region. The on-premise applications communications with compute instances inside the VPN over a hardware VPN connection. They are looking to implement an Intrusion detected and Prevention (IDS/IPS) system for their OCI environment. This platform should have the ability to scale to thousands of compute of instances running inside the VCN. How should they architect their solution on OCI to achieve this goal?

  A. Set up an OCI Private Load Balance! and configure IDS/IPS related health checks at TCP and/or HTTP level to inspect traffic
  B. Configure each host with an agent that collects all network traffic and sends that traffic to the IDS/IPS platform to inspection
  C. There Is no need to implement an IPS/IDS system as traffic coming over IPSec VPN tunnels Is already encrypt
  D. Configure autoscaling on a compute Instance pool and set vNIC to promiscuous mode to called traffic across the vcn and send it IDS/IPS platform for inspection.
  B. Configure each host with an agent that collects all network traffic and sends that traffic to the IDS/IPS platform to inspection

  ---

  Explanation/Reference:

  in Transit routing through a private IP in the VCN you set up an instance in the VCN to act as a firewall or intrusion detection system to filter or inspect the traffic between the on- premises network and Oracle Services Network.

  The Networking service lets you implement network security functions such as intrusion detection,

  application-level firewalls In fact, the IDS model can be host-based IDS (HIDS) or network- based IDS (NIDS). HIDS is installed at a host to periodically monitor specific system logs for patterns of intrusions. In contrast, an NIDS sniffs the

  traffic to analyze suspicious behaviors. A signature-based NIDS (SNIDS) examines the traffic for patterns of known intrusions. SNIDS can quickly and reliably diagnose the attacking techniques and security holes without generating an overwhelming number of false alarms because SNIDS relies on known signatures.

  However, anomaly-based NIDS (ANIDS) detects unusual behaviors based on statistical methods. ANIDS

  could detect symptoms of attacks without specific knowledge of details. However, if the training data of the

  normal traffic are inadequate, ANIDS may generate a large number of false alarms.

• Question 97:

  You are responsible for migrating your on premises legacy databases on 11.2.0.4 version to Autonomous Transaction Processing Dedicated (ATP-D) In Oracle Cloud Infrastructure (OCI). As a solution architect, you need to plan your migration approach.

  Which two options do you need to implement together to migrate your on premises databases to OCI?

  A. Use Oracle Data Guard to keep on premises database always active during migration
  B. Retain changes to Oracle shipped privileges, stored procedures or views In the on- premises databases.
  C. Use Oracle GoldenGate replication to keep on premises database online during migration.
  D. Convert on-premises databases to PDB, upgrade to 19c, and encrypt Migration.
  E. Retain all legacy structures and unsupported features (e.g. taw U>Bs) In the onuses databases for migration.
  C. Use Oracle GoldenGate replication to keep on premises database online during migration.
  D. Convert on-premises databases to PDB, upgrade to 19c, and encrypt Migration.

  ---

  Explanation/Reference:

  Autonomous Database is an Oracle Managed and Secure environment. A physical database can't simply be migrated to autonomous because:

  -

  Database must be converted to PDB, upgraded to 19c, and encrypted

  -

  Any changes to Oracle shipped privileges, stored procedures or views must be removed

  -

  All legacy structures and unsupported features must be removed (e.g. legacy LOBs) GoldenGate replication can be used to keep database online during migration

• Question 98:

  A company has an application that processes confidential data. The data is currently stored in an on-premises data center. A solution architect needs to move this data to Oracle Cloud Infrastructure (OCI) Object Storage and ensure data is encrypted in-transit to OCI.

  Which two steps should the solution architect perform to set up the most cost-effective connection between on-premises data center and OCI?

  A. Set up private end point for accessing Object Storage.
  B. Attach an Internet Gateway to Virtual Cloud network(VCN).
  C. Configure a service gateway accessing Object Storage.
  D. Set up an IPsec tunnel between the customer equipment and software VPN on an oci instance
  E. Configure a private peering connection on the Oracle FastConnect
  F. Set up VPN Connect between the customer equipment and the Dynamic Routing Gateway.
  C. Configure a service gateway accessing Object Storage.
  F. Set up VPN Connect between the customer equipment and the Dynamic Routing Gateway.

• Question 99:

  You are trying to troubleshoot the configuration of your Oracle Cloud Infrastructure (OCI) Load Balancing service. You have a backend HTTP service for which you have created a backend set in the load balancer. You have configured health checks for the backend set. Although the health checks appear good, customers sometimes experience transaction failures.

  Which of the following options will definitely lead to this problem?

  A. You are NOT using regional subnets in your Virtual Cloud Network. With Availability Domain (AD) specific subnet. the compute instances of the backend service running in the subnet have issues when the AD is down.
  B. You are using OCI Domain Name System. You have misconfigured the 'A' record with the wrong IP address leading to requests not getting routed correctly.
  C. You are using iSCI for block volume attachment to the compute instances in your backed HTTP service. TCP/IP configuration of your block volume attachment is not configured correctly, leading to issues in your backend service.
  D. You are running a TCP-level health check against your HTTP service. The TCP handshake can succeed and indicate that the service is up even when the HTTP service has issues.
  D. You are running a TCP-level health check against your HTTP service. The TCP handshake can succeed and indicate that the service is up even when the HTTP service has issues.

• Question 100:

  A developer is using Oracle Functions to deploy her code as part of an event-driven solution in Oracle Cloud Infrastructure (OCI). When she invokes her function, Oracle Functions returns a FunctionlnvokelmageNotAvailable message and a 502 error:

  

  Which of the following options is NOT a plausible reason for this error?

  A. Missing or invalid IAM policy to give Oracle Functions read access to images stored for functions in repositories in OCI Registry.
  B. The function does not exist in the specified location in OCI Registry.
  C. The VCN being used does not have an internet gateway or a service gateway configured for Oracle Functions to be able to access OCI Registry.
  D. OCI Events service rule is not configured with the correct location of the function in OCI Registry.
  D. OCI Events service rule is not configured with the correct location of the function in OCI Registry.