| Recommend a solution for storing relational data |
- Questions present a migration scenario with a set of requirements. such as supporting user-initiated backups, automatic geo-replication across regions, and minimal administrative overhead. and ask which of three SQL deployment options best satisfies all requirements. You need to understand which features are native to each option and which require manual configuration, so you can eliminate options that introduce unnecessary administrative effort or fail to satisfy a specific requirement.
- Questions present a HA requirement for SQL Server running on Azure VMs and ask you to choose between several combinations of availability technology and listener type. You need to understand what each combination implies for failover speed, cost, and dependency on shared infrastructure.
- Questions present an application with databases referenced by three-part naming (server.database.table) and ask which Azure SQL services support this naming pattern and can therefore receive the migration without code changes. You need to know which services support three-part naming natively and which require application code changes to remove server-name references.
- Questions present a scenario where 100 SQL Server instances host databases with specific characteristics such as CLR stored procedures and database sizes up to 4 TB, and ask which Azure service to recommend that minimises management overhead while supporting Entra ID authentication and requiring the fewest database changes. You need to evaluate how well each service supports these specific SQL Server features and match the option that provides PaaS benefits while preserving the most on-premises compatibility.
- Questions present a scenario where many databases must be deployed together with requirements for automatic scaling and minimizing SQL Server licensing costs, and the customer uses License Mobility through Software Assurance. The scenario is split into two questions: one asking which purchase model to use and another asking which deployment option. You need to know which purchase model allows Azure Hybrid Benefit to apply an existing SQL Server license, and which deployment option consolidates many databases while supporting per-database automatic scaling.
- Questions present an application that uses two on-premises SQL Server databases and requires server-side transactions that span both databases after migration to Azure. The requirement must be met while minimizing administrative overhead. You need to know which deployment option preserves support for distributed transactions between databases hosted on the same instance.
|
| Recommend a database service tier and compute tier |
- Questions present a case study with stated resiliency requirements and ask which service tier to configure for a database being migrated to Azure. You need to understand what each tier provides in terms of availability architecture, replica configuration, and storage characteristics to match the tier to the stated resiliency level.
- Questions present a database design requirement that includes a maximum database size well beyond the standard tier limit, and ask which service tier supports that scale. You need to know the storage capacity boundaries of each Azure SQL Database service tier.
- Questions present a database that will only be used on a predictable schedule. such as the first day of each month. and ask which service tier ensures the database is available during that period while minimising cost when it is idle. You need to know which tier supports automatic pausing when the database is inactive and automatic resumption on connection, and which tiers charge continuously regardless of usage.
- Questions present a series of Yes/No statements about SQL Server database auditing in an Azure environment. Each statement proposes storing audit data from a specific SQL database to a specific storage account, and asks whether this is valid. The tables show SQL servers, storage accounts, and databases with different properties such as region and subscription. You need to know which attributes of a storage account determine whether it is an eligible audit destination for a given Azure SQL database.
- Questions present a multi-requirement database design scenario specifying zero data loss on failover, availability during a zone outage, and minimum cost, then ask which Azure SQL Database deployment option satisfies all three. You need to know which tier supports synchronous replication across availability zones with no data loss on failover, and which tiers are lower cost but do not provide zone redundancy.
- Questions present a web application that stores PII data in Azure SQL Database and must maintain availability during a single datacenter outage, encrypt specific PII columns, automatically scale during high-demand periods such as payroll processing, and minimize cost. The scenario is split into two questions: one asking which service tier and compute tier to use, and another asking which encryption method to use. You need to know which service tier provides zone-redundant availability without requiring the highest tier, which compute tier enables automatic scaling with automatic pause, and which encryption method protects specific columns so that non-privileged application layers cannot read the plaintext values.
- Questions present a migration of a SQL Server database to Azure SQL Managed Instance with a requirement to enable customer-managed Transparent Data Encryption, and ask which encryption algorithm and key length to use for maximum encryption strength. You need to know which algorithm and key length represents the strongest option supported for TDE protectors in Azure Key Vault.
- Questions present an on-premises SQL Server database that must be migrated to an Azure service supporting multiple secondary read-only replicas, automatic replication, and failover within a 15-minute RTO. The scenario is split into two questions: one asking which Azure service or tier to recommend, and another asking which replication mechanism to use. You need to know which service tier supports multiple named secondary replicas beyond what standard geo-replication supports, and which replication mechanism provides automatic failover with an RTO measured in minutes rather than requiring manual intervention.
- Questions present an Azure SQL Database requirement to automatically scale compute resources based on workload demand and bill at per-second granularity. The scenario asks separately which Azure SQL product and which service tier to recommend. You need to know which product and tier combination supports automatic compute scaling, automatic pause when idle, and per-second billing rather than fixed hourly rates.
|
| Recommend a solution for database scalability |
- Questions present a multi-requirement scenario. such as needing SQL command support alongside multi-master write capability and guaranteed low latency reads. and ask which database service to recommend from a list that includes both relational and NoSQL Azure services. You need to understand which services support multi-master writes, which support standard SQL syntax, and how the combination of requirements narrows the choice to a specific service or API variant.
|
| Recommend a solution for data protection (relational) |
- Questions present a scenario where an Azure SQL database contains sensitive data, and the requirement is to ensure that only privileged users can view it. You need to distinguish between features that restrict what data users can read in query results, features that encrypt data at rest, and features that classify or label sensitive columns, and identify which feature directly limits the visibility of sensitive field values to non-privileged users.
- Questions present a resiliency requirement for SQL databases specifying cross-region automatic failover with minimal connection string impact. You need to understand what each option automates, what it requires from the application layer during failover, and which failure scenarios each one protects against.
- Questions present a managed instance with two columns containing different categories of sensitive data, where each column must be protected differently — one so that even privileged administrators cannot see the plaintext, and another so that non-privileged users see only a truncated version. The scenario asks separately which SQL security feature to enable for each column. You need to know which feature encrypts data so that only authorized client-side applications can decrypt it, making it unreadable even to database administrators, and which feature applies obfuscation rules at query time without changing the underlying stored data.
|
| Recommend a solution for storing semi-structured data |
- Questions present a high-throughput IoT scenario with a real-time visualization requirement, and ask which two services can together store and query the data at the required scale. You need to understand the functional boundaries of each service and identify which two can both store the data volume and support real-time querying.
- Questions present a mission-critical storage requirement that includes a formal SLA covering write latency and throughput, and ask which Azure service to recommend. You need to know which service provides guaranteed SLAs for both of these dimensions and why the alternatives do not.
- Questions present a case study where a multi-zone application deployment requires a data storage solution that supports writes from instances in multiple availability zones simultaneously, and ask what to deploy in each zone. You need to know which Azure data service supports concurrent writes from multiple active regions or zones without write conflicts, and why storage-level redundancy options do not provide active-active write capability.
- Questions present a Cosmos DB instance storing continuously updated operational data, alongside an Azure Synapse Analytics workspace that must analyse that data daily without affecting the performance of the operational database. You need to understand which option enables analytical queries against Cosmos DB data using a separate analytical store that does not generate read load on the transactional store.
- Questions present an application using Azure Cosmos DB to aggregate sales data from multiple countries, and ask which Cosmos DB API to recommend. Requirements include SQL query support, geo-replication, and relational data access. You need to know which API provides a SQL-like query surface with native geo-replication support in Cosmos DB, and how each API differs in terms of data model and query capability.
|
| Recommend a solution for storing unstructured data |
- Questions present a storage requirement that combines a minimum transaction rate with support for large binary objects. You need to know which account kind and performance tier can satisfy both the throughput requirement and the large object use case, and eliminate options designed for a different access pattern.
- Questions present an internet-facing application hosting large media files requiring the fastest read performance at minimum cost. You need to know which option is optimized for large binary object hosting over HTTP and why the others are designed for different use cases.
- Questions present a data ingestion pipeline where JSON events arrive via Azure Event Hubs and must be stored in a way that organizes data by date and time, allows direct querying and transformation into a data warehouse, and ensures the warehouse supports 50 TB and high concurrency. The scenario is split into two questions: one asking which storage service to use for the ingested raw data, and another asking which service to use for the data warehouse. You need to know which storage service supports hierarchical directory structures with date-based paths and is compatible with the analytics stack, and which warehouse service can handle petabyte-scale relational data with hundreds of concurrent readers.
- Questions present an on-premises storage migration where the solution must support the Hadoop Distributed File System protocol. You need to know which Azure storage service provides HDFS-compatible access and is used as the standard landing zone for Hadoop-based analytics workloads.
- Questions present a scenario where events are streamed to an Azure event hub and Event Hubs Capture is used to implement cold path processing. The scenario is split into two questions: one asking which Azure storage type must be provisioned to support Event Hubs Capture output, and another asking which data format the downstream reporting system must be able to ingest. You need to know which storage types are compatible with Event Hubs Capture as output destinations and which serialization format Event Hubs Capture uses to write events.
- Questions present a multi-requirement storage scenario for an image management application being migrated to Azure. The image storage must encrypt at rest, support files up to 50 MB, and integrate with Azure Web Application Firewall via Azure Front Door. The customer account storage must scale automatically, remain available if a datacenter fails, and support reads and writes from multiple Azure regions. Each requirement is asked separately. You need to match the characteristics of each service to the two distinct requirement sets: binary file hosting with WAF integration on one side, and globally distributed structured data with multi-region write support on the other.
- Questions present a data storage requirement that combines immutable storage support, disabled anonymous access, and ACL-based Microsoft Entra permissions at the file and directory level. You need to know which Azure storage service natively supports fine-grained ACL-based Entra permissions rather than RBAC-only access control, and how this differs from other Azure storage options.
|
| Recommend a data storage solution to balance features, performance, and costs |
- Questions present two applications with conflicting storage requirements in a series. one question asks what to recommend for Application1 (highest transaction rates, lowest latency, availability during datacenter failure) and the next asks for Application2 (lowest cost per GB, same availability requirement). You need to evaluate each combination against all stated requirements simultaneously and eliminate options that fail even one constraint.
- Questions present a table of existing storage accounts with varying kinds and replication configurations, and a set of application requirements, then ask which accounts are eligible for each application. You need to evaluate each account's properties against the feature prerequisites and identify which qualify.
- Questions present a transaction-intensive file share scenario and ask, in two separate questions, which storage tier and which redundancy option to recommend. with the added constraint that the redundancy must be the highest level available for the selected storage tier. You need to know which tiers are available for file shares, which redundancy options each tier supports, and which combination satisfies both the performance and resiliency constraints simultaneously.
|
| Recommend a data solution for protection and durability |
- Questions present a multi-requirement scenario. prevent new data from being modified for a defined period, maximize resiliency, and minimize read latency. and ask which combination of storage account type and redundancy setting satisfies all three. You need to know which storage account types support immutability policies, what each replication option provides in terms of geographic protection, and how latency is affected by each replication tier.
- Questions present a deployment with two types of storage accounts — some storing block blobs, others hosting SMB file shares — with requirements to maximize security, prevent use of shared keys, and use time-limited access wherever possible. The scenario asks separately what access solution to use for blob access and what to use for file share access. You need to know which SAS variant does not rely on the storage account key and which combination of SAS and stored access policy provides the strongest revocation control, and why SAS tokens are not applicable to SMB file shares and which identity-based mechanism is used instead.
- Questions present a requirement to store data for multiple users where each user's data must be encrypted with a separate key using customer-managed keys. You need to know which account kind and service type supports encryption scopes, and how scopes enable per-container key isolation within a single storage account.
- Questions present a sensitive data storage scenario with a five-year retention requirement, daily access, a requirement that data can be read but not modified or deleted during the retention period, and a requirement to minimise access charges. The question is split across two sub-questions: one asking for the correct storage account type and access tier, and another asking which configuration prevents modifications and deletions. You need to know which access tier is appropriate for daily access at minimum cost without the rehydration constraint of Archive, and which mechanism enforces WORM-like immutability on blob data rather than just controlling public access or SAS permissions.
- Questions present a storage requirement for frequently accessed data that must maximize throughput, prevent modification for one year, and minimize both read and write latency. The scenario is split into two questions: one asking which storage account type to use, and another asking which storage service within that account to use. You need to know which account type provides the highest performance for blob workloads and supports immutability policies, and which service type within that account is used for block blob data.
- Questions present a new application storing business-critical data with requirements to prevent modification for one year, maximize data resiliency, and minimize read latency. The scenario is split into two questions: one asking which redundancy option to choose and another asking which storage account type. You need to know which redundancy option provides the highest resiliency available for the chosen account type that also supports low latency, and which account type provides premium performance while still supporting immutability policies.
- Questions present a storage account design for point-in-time restore of blob data, where versioning and soft delete are already enabled. The scenario is split into two questions: one asking which blob type to create and another asking which additional feature to enable. You need to know which blob type supports point-in-time restore and versioning, and which feature must be enabled to track the create, update, and delete events that the restore capability requires.
- Questions present a blob that is overwritten once per hour and must be restorable to any previous day's version for up to 30 days after being overwritten, with the solution minimizing storage space. You need to know which feature automatically preserves previous versions of a blob when it is overwritten without requiring any additional action, and which options either keep only soft-deleted blobs rather than previous versions, operate at the container level, or accumulate all intermediate changes rather than only the last version per period.
- Questions present a storage account configuration task with two requirements: standardizing retention policies across a subscription and enabling deletion of data if it is found at an unauthorized location. You need to identify which two settings together address both the governance requirement for standardized retention and the data security requirement for the ability to permanently remove data.
- Questions present a storage account disaster recovery plan that must allow app access after failover, support failing back to the original location, and minimize downtime. The question asks which three actions to perform in what sequence from a provided list. You need to know what replication configuration must be in place before a failover can be initiated, which action triggers the failover itself, and what must be reconfigured after failover to restore geo-redundancy so that the account can later fail back.
|
| Recommend a solution for data integration and analysis |
- Questions present a scenario where data is continuously written to one Azure service and must be continually copied to another for analysis. You need to distinguish between tools designed for ongoing data movement pipelines, tools for one-time database migration assessments, and tools for physical offline data transfer.
- Questions present a storage account requirement for an application that uses Azure Data Lake Storage Gen2 analytics capabilities, and ask which specific storage account configuration must be enabled. You need to know which configuration unlocks ADLS Gen2 capabilities and what each of the other options is used for.
- Questions present a requirement to transform data files in Azure Blob Storage and move them to Azure Data Lake Storage using a mapping data flow, and ask which Azure service to use. You need to know which service provides built-in mapping data flow capability for visually designing transformation logic without writing code.
- Questions present a pipeline where an on-premises Oracle database must have its data made available to Azure Databricks for transformation before loading into Azure Synapse Analytics, and ask which two Azure services to include. You need to identify which service moves data from on-premises into Azure and which storage service acts as the staging layer accessible by Databricks.
- Questions present an Azure Databricks deployment where data engineers need access to only those ADLS Gen2 folders to which they have been granted direct permissions, and ask two separate questions about the design. One asks which Databricks SKU to recommend, offering Premium or Standard. The other asks which cluster configuration option enforces per-user folder-level access control from within the cluster. You need to know which SKU unlocks the credential passthrough feature, and what credential passthrough enables in terms of how a cluster authenticates data access on behalf of individual users.
- Questions present a scenario where web access log data stored in Azure Blob Storage must be uploaded automatically to Azure SQL Database on a monthly schedule, and ask which service to include in the recommendation. You need to distinguish between tools for automated recurring data movement pipelines, tools for one-time database schema assessment and migration, and tools for command-line file transfer.
- Questions present a VM running Windows Server that contains data files, connected to Azure Data Factory, where the pipeline must transform and load the files to Azure Data Lake Storage. The question asks what to deploy on the VM to enable the Data Factory pipeline to access the local files. You need to know which component enables Azure Data Factory to connect to and move data from compute resources and data stores that are not natively accessible from the Azure cloud.
- Questions present 100 existing SSIS packages that currently target on-premises SQL Server databases, and ask which Azure service should be included when migrating those packages to run against Azure SQL Database as their new destinations. You need to know which service hosts and executes SSIS packages in Azure and enables them to be retargeted to Azure SQL Database endpoints.
- Questions present a data pipeline that integrates data from multiple on-premises SQL Server databases into an Azure analytics platform using staged Blob storage, a parallelized cleanse-and-transform process, and a data warehouse with a managed OLAP serving layer for thousands of users. The scenario is split into two questions: one asking what to use for the data warehouse and one asking what to use for the serving layer. You need to distinguish between the service optimized for SQL-based structured warehousing versus the service that hosts OLAP models and semantic layers for large user populations querying pre-aggregated data.
- Questions present a petabyte-scale storage and analytics solution for mixed structured, semi-structured, and unstructured text data, with offload to ADLS Gen2 for long-term retention. The solution must provide interactive analytics and support manual, built-in, and custom autoscaling. The scenario is split into two questions: one asking which service to use for storage and interactive analytics, and another asking which query language is used. You need to know which service is purpose-built for storing and querying large volumes of time-series and log-type data with native autoscaling, and which query language it uses for interactive exploration.
- Questions present 12 heterogeneous on-premises data sources including SQL Server, MySQL, and Oracle databases, with a requirement to automatically copy new data into Azure Data Lake Storage for analysis, using ETL and minimizing administrative effort. You need to know which service provides built-in connectors for diverse source types, supports scheduled pipelines for incremental data copy, and handles the ETL process with minimal manual configuration, versus tools that are designed for data analysis, ad-hoc query, or data sharing.
- Questions present a scenario where an Azure Synapse workspace must connect to an Azure Cosmos DB account entirely over the Microsoft backbone without any internet routing, with minimum implementation effort. The scenario is split into two questions: one asking what to configure when provisioning the Synapse workspace, and another asking what to enable on the Cosmos DB account. You need to know which Synapse workspace network configuration creates a managed VNet that allows the workspace to create private endpoint connections to other Azure services, and which Cosmos DB configuration creates the corresponding private endpoint within that managed network.
- Questions present a Synapse Analytics solution using ADLS Gen2 and ask which pool type satisfies two different requirements presented separately — ingesting data from the data lake into hash-distributed tables, and implementing, querying, and updating data in Delta Lake format. You need to know which pool type supports hash-distributed table distribution for structured data warehousing, and which pool type natively supports Delta Lake operations including transactional writes.
- Questions present a Cosmos DB for NoSQL account with the analytical store enabled, integrated with a Synapse Analytics workspace. The requirement is to process the analytical store data in near-real-time using a runtime engine within the workspace and output results to a data warehouse, minimizing data movement. You need to know which pool in Synapse Analytics can directly query the analytical store via Synapse Link without first copying data to another location, and why other pool types require data movement.
- Questions present a cross-organization data integration scenario where a partner's SQL Server data must be ingested into the first organization's data lake with format transformation during upload, and separately the partner must receive access to snapshots of the first organization's analytics workspace data. The scenario asks which Azure service satisfies each requirement. You need to know which service provides an ETL pipeline that can pull and transform data from an external SQL Server source, and which service allows controlled sharing of dataset snapshots with an external organization without replicating data to their own infrastructure.
|
Flash sale is here! Get Extra 25% off on ALL COURSES! Use coupon code FLASH25. Ends today.
This website uses cookies for proper functioning. Learn More