Get 1z0-997-22 Products Practice Material for 1z0-997-22 Exam Question Preparation
Most Reliable Oracle 1z0-997-22 Training Materials
NEW QUESTION # 47
A civil engineering company is running an online portal In which engineers can upload there constructions photos, videos, and other digital files.
There is a new requirement for you to implement: the online portal must offload the digital content to an Object Storage bucket for a period of 72 hours. After the provided time limit has elapsed, the portal will hold all the digital content locally and wait for the next offload period.
Which option fulfills this requirement?
- A. Create a pre authenticated URL lot each object that Is uploaded to the Object Storage bucket with an expiration of 72 hours.
- B. Create a pre authenticated URL for the entire Object Storage bucket to write content with an expiration of 72 hours.
- C. Create a pre-authenticated URL for the entire Object Storage bucket to read and list the content with an expiration of 72 hours.
- D. Create a Dynamic Group with matching rule for the portal compute Instance and grant access to the Object Storage bucket for 72 hours.
Answer: B
Explanation:
Pre-authenticated requests provide a way to let users access a bucket or an object without having their own credentials, as long as the request creator has permission to access those objects.
For example, you can create a request that lets operations support user upload backups to a bucket without owning API keys. Or, you can create a request that lets a business partner update shared data in a bucket without owning API keys.
When creating a pre-authenticated request, you have the following options:
You can specify the name of a bucket that a pre-authenticated request user has write access to and can upload one or more objects to.
You can specify the name of an object that a pre-authenticated request user can read from, write to, or read from and write to.
Scope and Constraints
Understand the following scope and constraints regarding pre-authenticated requests:
Users can't list bucket contents.
You can create an unlimited number of pre-authenticated requests.
There is no time limit to the expiration date that you can set.
You can't edit a pre-authenticated request. If you want to change user access options in response to changing requirements, you must create a new pre-authenticated request.
The target and actions for a pre-authenticated request are based on the creator's permissions. The request is not, however, bound to the creator's account login credentials. If the creator's login credentials change, a pre-authenticated request is not affected.
You cannot delete a bucket that has a pre-authenticated request associated with that bucket or with an object in that bucket.
NEW QUESTION # 48
Your customer has gone through a recent departmental re structure. As part of this change, they are organizing their Oracle Cloud Infrastructure (OCI) compartment structure to align with the company's new organizational structure.
They have made the following change:
Compartment x Is moved, and its parent compartment is now compartment c.
Policy defined in compartment A: Allow group networkadmins to manage subnets in compartment X Policy defined in root compartment: Allow group admins to read subnets in compartment Finance:A:X After you move the compartment, which two IAM policies would be required to ensure both groups retain the same permissions to compartment X that they had before? (Choose two.)
- A. Define a policy in the root compartment as follows: Allow group admins to read subnets in compartment HR:C:X
- B. Define a policy in compartment HR as follows: Allow group networkadmins to manage subnets in compartment C:X.
- C. Define a policy in compartment C as follows: Allow group networkadmins to read subnets in compartment X
- D. Define a policy in the root compartment as follows: Allow group admins to manage subnets in compartment Finance:A:X
Answer: A,B
NEW QUESTION # 49
You are developing a Serverless function for your company's IoT project. This function should access Oracle Cloud Infrastructure (OCI) Object Storage to store some files. You choose Oracle Functions to deploy this function on OCI. However, your security team doesn't allow you to carry any API Token or RSA Key to authenticate the function against the OCI API to access the Object Storage.
What should you do to get this function to access OCI Object Storage without carrying any static authentication files? (Choose the best answer.)
- A. Option B
- B. Option A
- C. Option D
- D. Option C
Answer: B
Explanation:
https://blogs.oracle.com/cloud-infrastructure/getting-started-with-oracle-functions-and-object-storage
NEW QUESTION # 50
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 Oracle datapump for oracle databases and SQL Developer for MSSQL database
- B. Propose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle SQL Loader for MSSQL migration
- C. Propose the use of Oracle GoldenGate to perform zero downtime migration for both MSSQL and Oracle source databases
- D. Propose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle GoldenGate for MSSQL migration
Answer: D
NEW QUESTION # 51
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 compliant with 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 time However, 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. Route 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. Create an OCI Command Line Interface (CLI) script to automatically reserve public IP address for the compute instances. On the third-party services, whitelist the Reserved public IP.
- C. Route payment request from the compute instances through the OCI Load Balancer, which will then be routed to the third party service.
- D. Whitelist the Internet Gateway Public IP on the third party service and route all payment requests through the Internet Gateway.
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Balance/Concepts/balanceoverview.htm
NEW QUESTION # 52
You are responsible for a web application deployed on a set of compute VM instances in Oracle Cloud Infrastructure (OCI). Your application stores data on block volumes.
In production, the business requirement is a Recovery Point Objective (RPO) of two hours and that data should be recoverable in case of a regional failure.
How would you meet the RPO requirement in the event of a failure?
- A. Store hourly block volume backups to an NVMe device attached to a compute instance in a different Availability Domain (AD).
- B. Set up cross-region volume replication to replicate the block volumes to a different OCI region.
- C. Create a user-defined storage backup policy and attach a schedule of type "Hourly" and automatically copy to another region. Apply this policy to a volume group containing the block volumes.
- D. Configure your application to use synchronous primary-secondary data replication between ADs.
Answer: D
NEW QUESTION # 53
Which of the below options is true regarding Oracle Cloud Infrastructure's load balancing service?
- A. When you create a private load balancer, the service requires 2 or more subnets to host both the primary and standby load balancers.
- B. A public load balancer is Availability Domain specific in scope.
- C. The public load balancer applies a floating public IP address to the primary load balancer.
- D. You can dynamically change the load balancer shape to handle more incoming traffic.
Answer: C
NEW QUESTION # 54
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. Elapsed time since database was last patched.
- C. Number of active connections.
- D. Top 5 longest running queries.
- E. Data types used in the on-premises database.
Answer: A,E
NEW QUESTION # 55
You have an Oracle database system in a virtual cloud network (VCN) that needs to be accessible on port 1521 from your on-premises network CIDR 172.17.0.0/24.
You have the following configuration currently.
Virtual cloud network (VCD) is associated with a Dynamic Routing Gateway (DRG), and DRG has an active IPSec connection with your on-premises data center.
Oracle database system is hosted in a private subnet
The private subnet route table has the following configuration
The private subnet route table has following configuration.
However, you are still unable to connect to the Oracle Database system.
Which action will resolve this issue?
A)
Add an EGRESS rule in network security group as following.
B)
Add a route rule in the private subnet route table as following.
C)
Add an EGRESS rule in private subnet scurity list as following.
D)
Add an EGRESS rule in private subnet security list as following.
- A. Option B
- B. Option C
- C. Option D
- D. Option A
Answer: B
NEW QUESTION # 56
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. The database memory SGA and PGA will not get affected by the changes in the number of CPUs during auto scaling
- B. Auto scaling also scales IO throughput linearly along with CPU
- C. Enabling auto scaling does not change the concurrency and parallelism settings
- D. The maximum CPU cores that will be automatically allocated for this database is 16 CPUs
Answer: B,C
Explanation:
Explanation
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.
NEW QUESTION # 57
Your Oracle database is deployed on-premises and has produced 100 TB database backup locally. You have a disaster recovery plan that requires you to create redundant database backups in Oracle Cloud Infrastructure (OCI).
Once the initial backup is completed, the backup must be available for retrieval in less than 30 minutes to support the Recovery Time Objective (RTO) of your solution.
Which is the most cost effective option to meet these requirements?
- A. Use OCI Storage Gateway to transfer the backup files to OCI Object Storage Standard tier as the final destination.
- B. Use OCI Storage Gateway to transfer the backup files to OCI Object Storage Archive tier as the final destination.
- C. Setup a FastConnect connection between on-premises data center and OCI. Then to use OCI CLI command to upload database backups to OCI Object Storage Standard tier as the final destination.
- D. Setup an IPsec VPNConnect between on-premises data center and OCI. Then to use OCI CLI command to upload database backups to OCI Object Storage Archive tier as the final destination.
Answer: A
NEW QUESTION # 58
Your customer has gone through a recent departmental re structure. As part of this change, they are organizing their Oracle Cloud Infrastructure (OCI) compartment structure to align with the company's new organizational structure.
They have made the following change:
Compartment x Is moved, and its parent compartment is now compartment c.
Policy defined in compartment A: Allow group networkadmins to manage subnets in compartment X Policy defined in root compartment: Allow group admins to read subnets in compartment Finance:A:X After you move the compartment, which two IAM policies would be required to ensure both groups retain the same permissions to compartment X that they had before? (Choose two.)
- A. Define a policy in the root compartment as follows: Allow group admins to read subnets in compartment HR:C:X
- B. Define a policy in compartment HR as follows: Allow group networkadmins to manage subnets in compartment C:X.
- C. Define a policy in compartment C as follows: Allow group networkadmins to read subnets in compartment X
- D. Define a policy in the root compartment as follows: Allow group admins to manage subnets in compartment Finance:A:X
Answer: A,B
NEW QUESTION # 59
An automobile company wants to deploy their CRM application for Oracle Database on Oracle Cloud Infrastructure (OC1) DB Systems for one of major clients. In compliance with the Business Continuity Program of the client, they need to provide a Recovery Point objective (RPO) of 24 hours and a Recovery time objective (RTO) of 24 hours and Recovery Time Objective (RTO) of 1 hour.
The CRM application should be available oven in me event that an entire on Region is down.
Which approach Is the most suitable and cost effective configuration for this scenario?
- A. Deploy an Autonomous Transaction Processing (Serverless) database in one region and replicate it to an Autonomous Transaction Processing (Serverless) database in another region Oracle GoldenGate.
- B. Deploy a 1 node VM Oracle database in one region and replicate the database to a 1 node VM Oracle database in another region using a manual setup and configuration of Oracle Data Guard.
- C. Deploy a 2 node Virtual Machine (VM) Oracle RAC database in one region and replicate the database to a 2 node VM Oracle RAC database in another region using a manual setup and configuration of Oracle Data Guard.
- D. Deploy a 1 node VM Oracle database in one region. Manual Configure a Recovery Manager (RMAN) database backup schedule to take hourly database backups. Asynchronously copy the database backups to object storage in another OCI region, If the primary OCI region is unavailable launch a new 1 new VM Database in the other OCI region restore the production database from the backup.
Answer: B
Explanation:
You can configure the Autonomous Database instance as a target database for Oracle GoldenGate. But You can't set up Oracle Autonomous Database as a source database for Oracle GoldenGate.
Recovery Point objective (RPO) of 24 hours and Recovery Time Objective (RTO) of 1 hour
- To provision new VM and restore the production database from the backup on object storage, will exceed the RTO 1 hour
- You can create the standby DB system in a different availability domain from the primary DB system for availability and disaster recovery purposes. With Data Guard and switchover/failover can meet RTO
1 hour.
- RAC Database is not required in this solution. Standalone will be most suitable and cost effective
NEW QUESTION # 60
Your customer has gone through a recent reorganization. As part of this change, they are organizing their Oracle Cloud Infrastructure (OCI) compartment structure to align with the company's new organizational structure. (Refer to the exhibit)
They have made the following change:
Compartment A is moved, and its new parent compartment is compartment Dev.
Policy defined in compartment A: Allow group G1 to manage instance-family in compartment A Policy defined in root compartment: Allow group admins to manage instance-family in compartment Ops: Test: A After the compartment move, which action will provide users of group G1 and admins with similar privileges as before the move?
- A. Define the following policy in compartment Dev:
Allow group G1 to manage instance-family in compartment A - B. Mo change in any policy statement is required as all the policies associated with a compartment being moved is automatically updated
- C. Define the following policies in compartment Dev:
Allow group G1 to manage instance-family in compartment A
Allow group admins to manage instance-family in compartment Ops: Dev: A - D. Define the following policy in compartment: Dev:
Allow group admins to manage instance-family in compartment Ops: Dev: A
Answer: A
NEW QUESTION # 61
You are running a mission-critical database application in Oracle Cloud Infrastructure (OCI). You take regular backups of your DB system to OCI Object Storage. Recently, you notice a failed database backup status in the console.
What troubleshooting action can you perform to determine the cause of the backup failure?
- A. Ensure that your database host can connect to OCI Object Storage.
- B. Ensure that the database is not active and running while the backup is in progress.
- C. Ensure the database archiving mode is set to NOARCHIVELOG.
- D. Ensure that the dcsagent program is not restarted in case of a stop/waiting status.
Answer: A
NEW QUESTION # 62
A fast growing E-commerce company has deployed their online shopping application on Oracle Cloud Infrastructure. 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. Autoscaling has already scaled to the maximum number of instances specified in the configuration and there is no room for scaling further.
- B. The health check on some of the backend servers has failed and the load balancer has taken those servers temporarily out of rotation.
- C. The health check on some of the backend servers has failed and the load balancer was rebooting these servers.
- D. 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.
Answer: A,B
NEW QUESTION # 63
You are working as a cloud engineer for an IoT startup company which is developing a health monitoring pet collar for dogs and cats. The company collects biometric Information of the pet every second and then sends it to Oracle Cloud Infrastructure (OCI) Your task is to come up with an architecture which will accept and process the monitoring data as well as provide complete trends and health reports to the pet owners. The portal should be highly available, durable, and scalable with an additional feature for showing real time biometric data analytics.
which architecture will help you meet this requirement?
- A. 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.
- B. 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
- 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. 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.
Answer: A
NEW QUESTION # 64
A large financial services company has used 2 types of Oracle DB Systems. In Oracle Cloud Infrastructure (OCI) to store user dat a. 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. Confirm that ATP-S allows customers to compress tablespaces to reduce storage costs
- C. Validate that ATP-S will support the storage and processing requirements for the 2 databases over the life cycle of the business applications.
- D. Upon provisioning, ATP-S automatically scales up CPU to meet the application's processing requirements.
Answer: A,C
Explanation:
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.
NEW QUESTION # 65
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 three 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. Retain all legacy structures and unsupported features (e.g. legacy LOBs) in the on-premises databases for migration.
- D. Launch Autonomous Transaction Processing - Dedicated database in OCI.
- E. Convert on-premises databases to PDB, upgrade to 19c, and encrypt.
- F. Use Oracle GoldenGate replication to keep on-premises database online during migration.
Answer: D,E,F
NEW QUESTION # 66
Which of the following is NOT a good use case for using the functionality available in the Oracle Cloud Infrastructure (OCI) Events service?
- A. Publish all events in a specific compartment to Oracle Streaming service for later analysis.
- B. Triggers Function using Oracle Functions when new files are uploaded in an OCI Object Storage bucket.
- C. Trigger a notification when a function completes its execution.
- D. Capture Monitoring Alarms and invoke Autoscaling of compute instances.
- E. Publish a notification when long lived tasks complete, such as OCI Autonomous Database backup completion.
Answer: D
NEW QUESTION # 67
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 Fast Connect with the colocation with Oracle option, and a compatible edge device on- premises.
- B. 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.
- C. Set up both Site-to-Site VPN and Fast Connect connections from OCI to separate edge devices on-premises.
- D. 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.
- E. Set up Site-to-Site VPN connection with two redundant tunnels from the on-premises edge device to OCI.
Answer: C
NEW QUESTION # 68
As part of planning the network design on Oracle Cloud Infrastructure, you have been asked to create an Oracle Cloud Infrastructure Virtual Cloud Network (VCN) with 3 subnets, one in each Availability Domain. Each subnet needs to have a minimum of 64 usable IP addresses.
What is the smallest subnet and VCN size you should use to implement this design? The requirements are static, so no growth is expected.
- A. /22 for the VCN; /25 for the subnets
- B. 122 for the VCN; 124 for the subnets
- C. /24 for the VCN; /24 for the subnets
- D. /23 for the VCN; /25 for the subnets
Answer: D
NEW QUESTION # 69
Multiple departments In your company use a shared Oracle Cloud Infrastructure (OCI) tenancy to Implement their projects. You are in charge of managing the cost of OCI resources in the tenancy and need to obtain better Insights Into department's usage.
Which three options can you implement together to accomplish this?
- A. Set up a consolidated budget tracking lags to analyze costs in ,1 granular manner
- B. Create a budget that matches your commitment amount and an alert at 100 percent of the forecast
- C. Set up different compartments for each department then track and analyze cost per compartment
- D. Set up a tag default that automatically applies tags to all specified resources created In a compartment then use these tags for cost analysis.
- E. Use the billing cost tracking report to analyze costs
Answer: B,C,D
Explanation:
budgets
You can use budgets to track costs in your tenancy. After creating a budget for a compartment, you can set up alerts that will notify you if a budget is forecast to be exceeded or if spending surpasses a certain amount.
OCI Cost Analysis
* Visualization tools Help understand spending patterns at a glance
* Filter costs by Date, Tags and Compartments
* Trend lines show how spending patterns are changing
* To use Cost Analysis you must be a member of the Administrators group
NEW QUESTION # 70
Multiple departments In your company use a shared Oracle Cloud Infrastructure (OCI) tenancy to Implement their projects. You are in charge of managing the cost of OCI resources in the tenancy and need to obtain better Insights Into department's usage.
Which three options can you implement together to accomplish this?
- A. Set up a consolidated budget tracking lags to analyze costs in ,1 granular manner
- B. Create a budget that matches your commitment amount and an alert at 100 percent of the forecast
- C. Set up different compartments for each department then track and analyze cost per compartment
- D. Set up a tag default that automatically applies tags to all specified resources created In a compartment then use these tags for cost analysis.
- E. Use the billing cost tracking report to analyze costs
Answer: B,C,D
Explanation:
budgets
You can use budgets to track costs in your tenancy. After creating a budget for a compartment, you can set up alerts that will notify you if a budget is forecast to be exceeded or if spending surpasses a certain amount.
OCI Cost Analysis
* Visualization tools Help understand spending patterns at a glance
* Filter costs by Date, Tags and Compartments
* Trend lines show how spending patterns are changing
* To use Cost Analysis you must be a member of the Administrators group
NEW QUESTION # 71
......
LATEST 1z0-997-22 Exam Practice Material: https://actualtests.crampdf.com/1z0-997-22-exam-prep-dumps.html