Medium DP-900 practice questions

A media company must retain original video masters for regulatory compliance for at least seven years. These files are almost never accessed, but when they are needed, a retrieval delay of several hours is acceptable. The company wants the lowest possible storage cost in Azure Blob storage. Which access tier should they choose?

A marketing team has built a single-page web application composed of static HTML, CSS, JavaScript, and image files. They want to host these files publicly at low cost without provisioning or managing any web server infrastructure. Which Azure storage feature should they use?

A DevOps team needs to continuously write incremental log entries from many application servers into a single object in Azure Blob storage. New data must always be added to the end of the object without rewriting existing content, and the solution must be optimized for frequent append operations. Which type of blob should they use?

A media company stores customer video files in Azure Blob storage. Analysis shows that most files are accessed frequently in their first month, then are rarely accessed but must remain available for on-demand playback within milliseconds when a request does arrive. The company wants to minimize storage costs for these older files without moving them offline. Which Blob storage access tier should be applied to the older files?

A data science team needs an Apache Spark-based analytics platform on Azure where engineers can prepare large datasets and data scientists can collaboratively train machine learning models in shared workspaces. Which Azure service best fits this requirement?

A data science team needs a cloud analytics platform where they can write collaborative Apache Spark notebooks in Python and Scala, run large-scale data transformations on distributed clusters, and train machine learning models. The team specifically wants an optimized, managed Spark environment. Which Azure service best meets these requirements?

A company runs several Linux virtual machines that need to mount a shared, fully managed cloud file share using their native file-sharing protocol without deploying and maintaining a file server. Which Azure storage option and protocol combination should they use?

A company runs several Windows and Linux virtual machines in Azure. The application team needs a fully managed, cloud-based file share that all of these VMs can mount concurrently using standard file-system protocols, without deploying and maintaining a dedicated file server. Which Azure storage option should they choose?

A company is migrating an on-premises application to Azure. The application relies on a shared network drive that legacy Windows servers currently access using standard SMB file paths. The team wants to move this shared drive to Azure with minimal code changes so the migrated servers can mount it using the same file-sharing protocol. Which Azure storage service should they use?

A company runs a legacy accounting application on an on-premises Windows server. The application reads and writes files to a mapped network drive using a UNC path. The company wants to migrate the application to an Azure virtual machine without changing the application's file-access code. Which Azure storage service should host the shared files?

A retail company wants a single Azure service that lets data engineers ingest data, run large-scale distributed queries using both provisioned SQL pools and Apache Spark, and query data directly in the data lake — all within one integrated workspace. Which Azure service best fits this requirement?

A development team stores customer preference records in Azure Table storage. A new lightweight mobile app, written in a language without an official Azure SDK, needs to read and write these entities directly. Which approach lets the app interact with the Table storage service?

A startup needs to store millions of customer profile records where each record is retrieved by a unique customer ID. The data has a simple structure of properties, requires no complex queries or joins, and the company wants the lowest-cost Azure storage option that still supports fast key-based lookups. Which Azure storage service should they choose?

A developer is designing an Azure Table storage solution to store customer session records. Each record must be retrievable with the fastest possible point lookup. Which combination of values does the developer need to supply to perform this most efficient single-entity retrieval?

A development team currently uses Azure Table storage to store user profile data for a mobile app. The app is expanding globally and now requires single-digit millisecond read latency for users in multiple regions, along with guaranteed throughput that can scale automatically as demand grows. The team wants to keep using a table-style key/value data model with minimal application code changes. Which Azure service should they migrate to?

A development team is building an application that stores customer profile records. Each customer entity may have a different set of optional attributes (for example, some have a loyalty number, others have a referral source), and the team wants a low-cost NoSQL store where entities in the same table are not required to share identical columns. Which Azure storage service best fits this requirement?

A data analyst has written two SELECT queries that each return customer names from different regional tables, and both queries produce columns with identical data types. The analyst wants a single result set that stacks the rows from both queries into one list, automatically removing any duplicate customer names that appear in both regions. Which SQL keyword should the analyst use?

A sales analyst needs a query that returns the total order amount for each customer from an Orders table. Each customer has many rows, and the analyst wants one summary row per customer showing the sum of the order amounts. Which SQL clause is required to produce this per-customer aggregation?

A sales analyst runs a query against an Azure SQL Database and only wants to see the 10 highest-value orders. They combine an ORDER BY clause that sorts the results in descending order by order amount. Which additional clause should they use to restrict the query so that only the first 10 rows are returned?

A retail analyst needs to export daily sales figures from a spreadsheet so they can be shared with a partner company and easily imported into many different tools. The data is purely tabular, with rows and columns, and the partner has requested a lightweight, plain-text format with no proprietary software required to open it. Which data file format best meets these requirements?

A developer wants to automatically write a record into an audit table every time a row is updated in the Orders table, without changing any of the application code that performs the updates. Which database object should be used to achieve this?

A retail company wants to consolidate several years of sales history from multiple operational systems into a single repository. Business analysts will run large aggregation queries across billions of rows to identify seasonal trends and regional performance. Which type of Azure data store is most appropriate for this workload?

A media company needs to store millions of large raw video and audio files that are uploaded by content creators. The files are unstructured, vary greatly in size, and must be stored cost-effectively while remaining accessible over HTTP for later processing. Which Azure data store is the most appropriate choice?

A retail company stores product listings, each containing a variable set of attributes such as color, size, weight, and warranty details. Some products have many optional fields while others have only a few. The development team wants to store each listing as a self-describing document that can be retrieved and updated by its unique product ID without requiring schema migrations when new attributes are added. Which type of data store best fits this requirement?

A company runs several Azure virtual machines that all need to read and write to the same set of files using standard SMB protocol, so applications can access a shared network drive without code changes. Which Azure storage option best meets this requirement?