region. C. Deploy a 2-node Oracle RAC on VMs in the primary region and utilize Oracle GoldenGate for real- time data replication to a 2 -node Oracle RAC on VMs in a secondary region. D. Establish a 3-node Oracle RAC on bare metal instances in the primary region, manually configuring Oracle Data Guard for synchronous replication to a 3 -node Oracle RAC on bare metal instances in a secondary region. Explanation: Deploy a 2 -node Oracle RAC on VMs in the primary region and utilize Oracle GoldenGate for real -time data replication to a 2 -node Oracle RAC on VMs in a secondary region. -> Correct. Deploy a 2 -node Oracle RAC on VMs in the primary region and utilize Oracle GoldenGate for real -time data replication to a 2-node Oracle RAC on VMs in a secondary region. This approach efficiently meets the stringent RPO and RTO by leveraging Oracle GoldenGate's capabilities for real-time data replication and Oracle RAC's high availability features, ensuring operational continuity across regions. Implement a single -instance Oracle database on a VM in the primary region, with Oracle Active Data Guard for real-time data replication to a single -instance Oracle database on a VM in a secondary region. -> Incorrect. While Oracle Active Data Guard supports real-time replication, a single -instance database may not provide the high availability and fast failover capabilities required to meet the RTO and RPO targets. Set up a 2-node Oracle Real Application Clusters (RAC) on VMs within a single availability domain, and use Oracle Active Data Guard to replicate data to a 2-node Oracle RAC in a different availability domain in the same region. -> Incorrect. This setup offers high availability within the same region but may not sufficiently protect against regional outages, potentially compromising the platform's disaster recovery requirements. Establish a 3 -node Oracle RAC on bare metal instances in the primary region, manually configuring Oracle Data Guard for synchronous replication to a 3 -node Oracle RAC on bare metal instances in a secondary region. -> Incorrect. A 3-node Oracle RAC on bare metal provides excellent performance and availability but may exceed the cost -efficiency criteria due to the high resource and management overhead involved in such a deployment. You are tasked with ensuring the continuous operation and optimal performance of the company's database infrastructure in Oracle Cloud Infrastructure (OCI). The corporation's database landscape includes Oracle Autonomous Transaction Processing (ATP), Oracle Autonomous Data Warehouse (ADW), and MySQL Database Service. Recently, users have reported intermittent slow response times from applications using these databases, particularly during weekly financial reporting activities. Your preliminary analysis indicates that the issues are related to database performance. Which of the following steps would you prioritize to diagnose and resolve the performance bottlenecks?
Explanation: Utilize the OCI Monitoring and Oracle Performance Hub to identify specific SQL queries and operations causing performance issues, then optimize those queries. -> Correct. This approach directly targets the cause of performance issues by identifying inefficient queries or operations and optimizing them, which is more cost -effective and efficient than blindly increasing resources. Immediately increase the compute and storage resources for ATP, ADW, and MySQL Database Service instances to handle the increased load. -> Incorrect. While increasing resources may alleviate symptoms, it does not address the root cause of the performance bottlenecks and may lead to unnecessary costs. Convert all MySQL databases to ATP instances, assuming that the fully managed nature of ATP will automatically resolve any performance issues. -> Incorrect. Converting database types is a significant operation that may not address the specific performance bottlenecks and overlooks the strengths and purposes of using different database services. Implement read replicas for all databases and route read queries to these replicas to balance the load, assuming the issues are read -related. -> Incorrect. This solution assumes that the performance bottleneck is due to read operations without evidence and may not be applicable or efficient for ATP and ADW, which already offer scalable read and write operations. A multinational corporation is looking to expand its services globally, the company aims to deploy a complex application across multiple regions in the Oracle Cloud Infrastructure (OCI) to ensure high availability and low latency for its users worldwide. As part of the deployment, the company wishes to automate the provisioning and management of its infrastructure using Infrastructure -as-Code (IaC) to streamline operations and maintain consistency across environments. Given this scenario, which two of the following actions should be implemented to effectively automate infrastructure provisioning and ensure optimal application performance across multiple OCI regions?
single instance in only the home region does not address the requirement for high availability and low latency globally. Manually provision infrastructure in each region through the OCI Console to ensure precise control over resources. -> Incorrect. Manual provisioning contradicts the requirement for automation using Infrastructure -as-Code and can lead to inconsistencies and errors across regions. Implement OCI Functions for serverless execution of the application to automatically scale without provisioning infrastructure. -> Incorrect. Although OCI Functions provide scalability and serverless execution, they may not meet all requirements of complex applications that require specific infrastructure configurations. A multinational finance corporation is planning to deploy a secure, highly available application for real- time stock trading. This application needs to automatically scale based on the stock market activity, provide minimal latency for global users, and ensure data integrity and security for all transactions. Which combination of Oracle Cloud Infrastructure (OCI) services would best support these requirements?
for this situation?
Migration Service supports minimal downtime migrations, making it ideal for high-transactional databases. Implement the database on OCI Autonomous Database to automatically scale and manage performance. -> Correct. OCI Autonomous Database offers automatic scaling and self-managing capabilities, suitable for high -transactional workloads. Deploy the database on OCI Object Storage for improved scalability. -> Incorrect. OCI Object Storage is not suitable for high -transactional databases due to its design for unstructured data storage. Configure the database in a VM on OCI to manually manage scalability and performance. -> Incorrect. While this offers control over the environment, it requires significant manual effort to manage scalability and performance, which may not meet the business requirement for minimal downtime. Set up a Disaster Recovery (DR) site on OCI with manual replication. -> Incorrect. Manual replication for a high -transactional database could lead to significant downtime and data loss, not aligning with the company's requirements. You have set up a cloud infrastructure in Oracle Cloud Infrastructure (OCI) that includes a public -facing web application hosted on a Compute instance within a public subnet. You need to ensure the web application can securely access OCI Object Storage to retrieve static assets without exposing the Object Storage to the public internet. Which two steps should you take to establish this secure connectivity?
➢ TOTAL QUESTIONS:371 You are tasked with designing a highly available and resilient architecture for a critical application in Oracle Cloud Infrastructure (OCI). The application must be able to withstand the failure of an entire OCI region. Which of the following strategies would you employ to ensure the highest level of disaster recovery and data durability?
