Design Data Storage Solutions

A retail corporation plans to migrate an on-premises inventory management system to Microsoft Azure. The database tier has the following requirements:
- The system must run a specialized database monitoring agent directly on the database server's operating system, which requires local administrator privileges.
- The environment must support SQL Server Agent to run scheduled maintenance and data synchronization jobs.
- The administration team must minimize the operational overhead of manually managing operating system updates and SQL Server patches.
- The database storage must support high-performance transactions, with the ability to dynamically scale disk performance up to $80,000$ IOPS.

Which Azure SQL deployment option should you recommend?

You are designing an Azure migration strategy for several legacy databases. Match each workload scenario on the left with the correct Azure Cosmos DB API on the right to ensure the migration requires minimal application refactoring while meeting performance and architectural requirements.

A company is designing a storage solution for a document management application. The documents must be stored in Azure Blob Storage.

The solution must meet the following requirements:
- If an entire Azure region suffers a major outage, the storage solution must remain resilient and prevent data loss.
- Access to the files must be granted to external vendors using Shared Access Signatures (SAS) that can be invalidated immediately if a security compromise is suspected.

Which two storage configurations should you recommend to meet the requirements?

You are designing an Azure Blob Storage solution for storing virtual machine backups. The solution must meet the following requirements:
- Ensure the backups remain available if a single datacenter in the primary region fails.
- Ensure backups can be retrieved within seconds if a restore is initiated.
- Minimize storage costs.

Which storage configuration should you recommend?

A company is developing a fleet management application. The application will store real-time telemetry from 50,000 delivery vehicles. The workload has a read/write ratio of 80% writes and 20% reads. The data must be distributed across three Azure regions to support global users, and the solution must avoid partition throttling while maintaining high availability. Which configuration should you recommend for the Azure Cosmos DB container?

An organization is designing the storage infrastructure for a new containerized application workflow on Azure. The architecture must satisfy the following technical requirements:

- Provide a shared, POSIX-compliant file system for a cluster of Linux nodes that supports the NFS v4.1 protocol and can withstand the outage of a single Availability Zone within the primary Azure region.
- Provide block storage for a transaction-intensive database workload that requires consistent sub-millisecond disk write latencies.

Which two storage configurations should you recommend? (Select two.)

An international logistics company is designing the data tier for a new transport management platform. The platform consists of two distinct subsystems:

* The tracking subsystem requires a database that supports cross-database queries, SQL Server Agent for scheduling route calculation jobs, and Common Language Runtime (CLR) integration. The solution must minimize operational overhead.
* The invoicing subsystem requires a single database that experiences highly variable traffic patterns, including long periods of zero activity. The solution must minimize compute costs during idle periods.

Which two Azure SQL services should you recommend to support the subsystems? (Select TWO).

An organization is migrating a high-performance Linux-based application to Azure Virtual Machines. The application requires a shared file system that supports POSIX-compliant file locks and the NFS protocol. The design requires that the storage solution must survive a single zone outage within an Azure region while maintaining high performance. Which storage solution should you recommend?

A healthcare provider plans to allow external clinical researchers to upload trial datasets to a specific Azure Blob Storage container. You need to design an access solution that meets the following requirements:
- The researchers must have write access for a maximum of 48 hours.
- You must be able to revoke access immediately if a security compromise is detected.
- The solution must minimize administrative effort.

Which two actions should you include in the design? (Select TWO.)

An enterprise stores large volumes of raw sensor data in Parquet format within an Azure Data Lake Storage Gen2 container. Members of the data engineering team need to run occasional, exploratory SQL queries to analyze the schema and contents of new files. They do not want to load the data into a database or keep compute clusters running when no queries are active.

Which Azure Synapse Analytics component is the most appropriate option to satisfy these requirements?

A healthcare organization is designing a cloud-based clinical trial platform. Patient health records are stored in an Azure Blob Storage container named `trials`. A third-party auditing firm requires read-only access to this container for a period of $120$ days. The security architecture must ensure that the access can be immediately revoked at any time without rotating the storage account access keys or impacting other applications. Additionally, all access requests must originate from the auditing firm's public IP range of $198.51.100.0/24$.

Which access control strategy should you recommend to meet these requirements?

A healthcare organization is migrating an on-premises Electronic Health Record (EHR) system to Azure. The design requires configuring secure access to an Azure Storage account named ehrdata that contains sensitive patient medical images in a blob container.

The solution must meet the following security requirements:
- External partner radiologists must be granted temporary read-only access to the blob container for 7 days. This access must be immediately revocable at any time before the 7 days expire.
- Internal compliance auditors require access to review the data, and the configuration must enforce scalable access control using identity best practices.
- Security administrators must be able to rotate storage keys, but only during scheduled audit windows, requiring manager approval before they can perform this action.

Which three actions should you include in the storage security and access control design? (Select three.)

An organization is designing a relational data storage solution for a new patient scheduling portal. The database tier must support the following requirements:

* Run on a single database using a serverless compute model that automatically scales compute resources based on workload demand.
* Automatically pause the database during periods of inactivity to minimize costs.
* Ensure that database backups are resilient against a primary datacenter outage.

Which deployment option should you recommend?

A company is planning the storage architecture for a new application. The business requirements state that the data must be replicated synchronously across three separate availability zones within the primary region to ensure high availability. Which two Azure Storage replication options should you recommend to meet this requirement? (Select two.)

You are an Azure Solutions Architect designing a data storage solution for a global media streaming platform. The platform must store real-time user playback progress and watch history. The workload has a read-to-write ratio of approximately $40:60$. The solution must be distributed across three regions (East US, West Europe, and East Asia) to achieve sub-10ms write latency at the 99th percentile and support an active-active setup. The platform requires a 99.999% availability SLA for both reads and writes. High availability and regional disaster resilience must be guaranteed for all data, including database backups.

Which two configuration options should you include in the architectural design to meet these requirements? (Select TWO)

A company plans to migrate an on-premises SQL Server database to Azure. The database requires the use of SQL Server Agent to run scheduled maintenance jobs, and cross-database queries are heavily utilized. The database administration team wants to minimize administrative overhead for managing the underlying operating system. Which Azure SQL deployment option should you recommend?

A company is deploying a new retail application in Azure that requires a relational database backend. The database design must satisfy the following requirements:
- Cost-effectively manage resource allocation for 20 databases that experience short, unpredictable spikes in usage.
- Ensure that database backups remain available even if a single datacenter within the primary region suffers a complete outage.

Which two options should you include in the design? (Select two.)

A company is designing a new relational database solution in Azure. The database has the following requirements:

* Must support SQL Server Agent for scheduling internal database maintenance tasks.
* Must be deployed with a private IP address within an Azure Virtual Network (VNet).

Which two Azure SQL deployment options meet these requirements?

A company is planning to migrate a legacy on-premises electronic health record (EHR) application to Azure. The relational database for the application has the following requirements:
- Must support SQL Server Agent to run nightly maintenance jobs.
- Must support Database Mail to send automated notifications to administrators.
- Must be deployed into a private, delegated subnet within an Azure Virtual Network.
- In the event of a regional disaster, all database backups must remain available.
- The administrative overhead for managing operating system patching and hardware updates must be minimized.

Which Azure SQL deployment option should you recommend?

An organization is planning to migrate an on-premises payroll application to Azure. The application database relies on SQL Server Agent for scheduled data reconciliation and executes cross-database queries. The database must be deployed in a secure environment with native Azure Virtual Network (VNet) integration. To meet disaster recovery requirements, all backups must survive a regional outage, and the database administration team must minimize administrative effort for operating system and database engine patching. Which Azure SQL deployment option should you recommend?