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

Oracle 1Z0-997-20 Online Questions & Answers

• Question 91:

  A global retailer is setting up the cloud architecture to be deployed in Oracle Cloud infrastructure (OCI) which will have thousands of users from two major geographical regions: North America and Asia Pacific. The requirements of the services are:

  *

  Service needs to be available 27/7 to avoid any business disruption

  *

  North American customers should be served by application running In North American regions

  *

  Asia Pacific customers should be served by applications running In Asia Pacific regions

  *

  Must be resilient enough to handle the outage of an entire OCI region

  A. OCl DNS, Traffic Management with Failover steering policy
  B. OCl DNS, Traffic Management with Geolocation steering policy. Health Checks
  C. OCl DNS, Traffic Management with Geolocation steering policy
  D. OCl DNS,' Traffic Management with Load Balancer steering policy, Health Checks
  B. OCl DNS, Traffic Management with Geolocation steering policy. Health Checks

  ---

  Explanation/Reference:

  GEOLOCATION STEERING Geolocation 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. Combine with Oracle Health Checks to fail over from one region to another

  

• Question 92:

  You are running a legacy application in a compute instance on Oracle Cloud Infrastructure (OCI). To provide enough space for it to store internal data, a block volume is attached to the instance in paravirtualized mode.

  Your application is not resilient to crash-consistent backup.

  What should you do to backup the block volume in a secure and cost effective way? (Choose the best answer.)

  A. Save your application data, detach the block volume and create a clone.
  B. Create a volume group, add the boot volume and then run the volume group backup.
  C. Create a backup, detach the block volume and save your application data.
  D. Save your application data, detach the block volume and create a backup.
  D. Save your application data, detach the block volume and create a backup.

• Question 93:

  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) database as 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 options are expensive or impractical ways to improve the application response times?

  A. Identify 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. Use the Machine Learning (ML) feature of the ATP-S database iteratively to tune the SQL queries used by the application.
  C. Scale up CPU core count and memory during peak times.
  D. Enable auto scaling for CPU cores on ATP-S database.
  E. Identify 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.
  C. Scale up CPU core count and memory during peak times.
  E. Identify 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.

• Question 94:

  Which of the below options for private access to services within Oracle Cloud Infrastructure (OCI) is NOT valid?

  A. You cannot use the private endpoint for hosts in the on-premises network.
  B. Traffic from an OCI compute instance going through a Service Gateway to Object Storage is routed without being sent over the internet.
  C. You can enable private access to certain services within OCI from your Virtual Cloud Network by using either a private endpoint or a service gateway.
  D. The private endpoint gives hosts within your Virtual Cloud Network access to a given service within Oracle Cloud Infrastructure.
  A. You cannot use the private endpoint for hosts in the on-premises network.

• Question 95:

  A cloud engineer needs to enable routing between two Virtual Cloud Networks (VCN) from his tenancy. The VCNs are in the same region but in different compartments. After reviewing the IPv4 CIDR prefixes of the two VCNs, he notices that there are no overlapping CIDR blocks.

  Which THREE are valid Oracle Cloud Infrastructure (OCI) options for connecting and routing between the two VCNs? (Choose three.)

  A. Create two DRGs in the tenancy. Attach one VCN to one of the DRGs; attach the other VCN to the second DRG. In each one of the DRGs, create a Virtual Circuit Attachment. Select FastConnect Partner as the FastConnect type. Select any vendor from the list and complete the circuit at the partner site. Once the FastConnect IPv4 BGP field is in the UP state in each one of the Virtual Circuits, add a route rule in each one of the VCNs' route table to the other VCN using the DRG as the next hop.
  B. Create two DRGs in the tenancy. Attach one VCN to one of the DRGs; attach the other VCN to the second DRG. In each one of the DRGs, create a Remote Peering Connection (RPC). Establish a connection from one RPC to the other. In each one of the VCNs' route table, add a route rule to the other VCN using the DRG as the next hop.
  C. Create a DRG in the tenancy; add one of the VCN as a VCN attachment. In the other VCN, create a Local Peering Gateway (LPG). Peer the DRG to the LPG. In the VCN attached to the DRG, add a route rule in the route table that points to the DRG as the next hop. In the other VCN, add a route rule in the route table that points to the LPG as the next hop.
  D. Add an LPG to each one of the VCNs. In one of the LPG, establish a Peering Connection to the other LPG. In each one of the VCN route table, add a route rule to the other VCN using the LPG as the next hop.
  E. Create a DRG in the tenancy; add one of the VCNs as a VCN attachment. In the other VCN, create a Local Peering Gateway (LPG). Peer the DRG to the LPG. In the VCN attached to the DRG, enable BGP routing for the route to propagate to the VCN. In the other VCN add a route rule in the route table that points to the LPG as the next hop.
  F. Create a Dynamic Routing Gateway (DRG) in the tenancy, add the two VCNs as VCN attachments and add routes in each one of the VCN route tables with the DRG as the next hop for the CIDR prefix of the other VCN.
  A. Create two DRGs in the tenancy. Attach one VCN to one of the DRGs; attach the other VCN to the second DRG. In each one of the DRGs, create a Virtual Circuit Attachment. Select FastConnect Partner as the FastConnect type. Select any vendor from the list and complete the circuit at the partner site. Once the FastConnect IPv4 BGP field is in the UP state in each one of the Virtual Circuits, add a route rule in each one of the VCNs' route table to the other VCN using the DRG as the next hop.
  C. Create a DRG in the tenancy; add one of the VCN as a VCN attachment. In the other VCN, create a Local Peering Gateway (LPG). Peer the DRG to the LPG. In the VCN attached to the DRG, add a route rule in the route table that points to the DRG as the next hop. In the other VCN, add a route rule in the route table that points to the LPG as the next hop.
  D. Add an LPG to each one of the VCNs. In one of the LPG, establish a Peering Connection to the other LPG. In each one of the VCN route table, add a route rule to the other VCN using the LPG as the next hop.

• Question 96:

  A large financial services company has used 2 types of Oracle DB Systems. In Oracle Cloud Infrastructure (OCI) to store user data. One is running on a VM.Standard2.8 shape and the other on a VM.Standard 2.4 shape.

  As business grows, data is growing rapidly on both the databases and performance is also degrading. The company wants to address this problem with a viable and economical solution.

  As the solution architect for that company you have suggested that they move their databases to Autonomous Transaction Processing Serverless (ATP-S) database.

  Which two factors should you consider before you arrived at that recommendation?

  A. You verified that ATP S supports the database features and options currently being used by the 2 databases.
  B. Validate that ATP-S will support the storage and processing requirements for the 2 databases over the life cycle of the business applications.
  C. Confirm that ATP-S allows customers to compress tablespaces to reduce storage costs
  D. Upon provisioning, ATP-S automatically scales up CPU to meet the application's processing requirements.
  A. You verified that ATP S supports the database features and options currently being used by the 2 databases.
  B. Validate that ATP-S will support the storage and processing requirements for the 2 databases over the life cycle of the business applications.

  ---

  Explanation/Reference:

  Not all features present in Oracle Database Enterprise Edition are available in ATP, and some some Oracle Database features are restricted, for example, database features designed for administration are not available. so you need to validate it first, You can find a complete list of the features that are not supported, https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/experienced-database- users.html#GUID-58EE6599-6DB4-4F8E-816D-0422377857E5 Also, you must specify the initial storage required for your database but ADB is elastic, so it is possible to grow or shrink your database as needed.

• Question 97:

  A retail company has several on-premise data centers which span multiple geographical locations. They plan to move many of their business critical applications to Oracle Cloud Infrastructure (OCI). These applications require highly available network connections between on-premises and OCI.

  Which option provides the highest level of redundancy?

  A. Set up both Site-to-Site VPN and Fast Connect connections from OCI to separate edge devices on-premises.
  B. Set up Site-to-Site VPN connection with two redundant tunnels from the on-premises edge device to OCI.
  C. Use either a Site-to-Site VPN or FastConnect connection to connect to an on-premises edge device, since OCI provides network redundancy by default.
  D. Set up Fast Connect with the colocation with Oracle option, and a compatible edge device on- premises.
  E. Use transit routing by deploying a hub Virtual Cloud Network (VCN) in OCI peered with application VCNs as spokes, and with an on-premises edge device with two redundant tunnels in Site-to-Site VPN.
  A. Set up both Site-to-Site VPN and Fast Connect connections from OCI to separate edge devices on-premises.

• Question 98:

  A digital marketing company is planning to host a website on Oracle Cloud Infrastructure (OCI) and leverage OCI Container Engine for Kubernetes (OKE). These web servers will make API calls to access OCI Object Storage to store all images uploaded by users.

  For security purposes, you must ensure that the credentials used by the web server to allow access to OCI Object Storage are not stored in the compute instance.

  What solution results in an implementation with the least-effort for this scenario?

  A. Configure the credentials to use Transparent Data Encryption (TDE) to automatically allow the web server to make API calls to the OCI Object Storage.
  B. Configure the credentials using OCI Registry (OCIR) to automatically connect with OKE allowing the web server to make API calls to the OCI Object Storage.
  C. Configure the credentials using OCI Vault to allow an instance to make API calls and grant access to OCI Object Storage.
  D. Configure the credentials using Instance Principals to allow the web server to make API calls to the OCI Object Storage.
  D. Configure the credentials using Instance Principals to allow the web server to make API calls to the OCI Object Storage.

• Question 99:

  An insurance company is storing critical financial data in the OCI block volume. This volume is currently encrypted using oracle managed keys. Due to regulatory compliance, the customer wants to encrypt the data using the keys that they

  can control and not the keys which are controlled by Oracle.

  What of the following series of tasks are required to encrypt the block volume using customer managed keys?

  A. Create a vault, import your master encryption key into the vault, generate data encryption key, assign data encryption key to the block volume
  B. Create a master encryption key, create a data encryption key, decrypt the block volume using existing oracle managed keys, encrypt the block volume using the data encryption key
  C. Create a vault, create a master encryption key in the vault, assign this master encryption key to the block volume
  D. Create a master encryption key, create a new version of the encryption key, decrypt the block volume using existing oracle managed keys and encrypt using new version of the encryption key
  C. Create a vault, create a master encryption key in the vault, assign this master encryption key to the block volume

  ---

  Explanation/Reference:

  Oracle Cloud Infrastructure Vault lets you centrally manage the encryption keys that protect your data and the secret credentials that you use to securely access resources. You can use the Vault service to create and manage the following resources: Vaults Keys Secrets Vaults securely store master encryption keys and secrets that you might otherwise store in configuration files or in code. The Vault service lets you create vaults in your tenancy as containers for encryption keys and secrets. If needed, a virtual private vault provides you with a dedicated partition in a hardware security module (HSM), offering a level of storage isolation for encryption keys that's effectively equivalent to a virtual independent HSM.

• Question 100:

  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