Microsoft DP-900 Practice Exams
Last updated on Oct 22,2026- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Oct 22,2026
DRAG DROP
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box 1: Azure Storage account
Azure file shares are deployed into storage accounts, which are top-level objects that represent a shared pool of storage.
Box 2: File share
Reference: https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
HOTSPOT
Select the answer that correctly completes the sentence.
Explanation:
Hierarchical namespace
https://learn.microsoft.com/en-us/dynamics365/customer-insights/own-data-lake-storage
DRAG DROP
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Box 1: SELECT
Box 2: GROUP BY
Example:
When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as ‘Average bonus’, SUM(SalesYTD) as ‘YTD sales’
FROM Sales.SalesPerson
GROUP BY TerritoryID;
Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
DRAG DROP
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement on the right.
Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box 1: Azure Data Factory
Box 2: Azure Data Lake Storage
Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor and outputter for the popular Parquet file format
Box 3: Azure Synapse Analytics
Use Azure Synapse Analytics Workspaces.
Reference: https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use?
- A . Azure Data Studio
- B . sq1cmd
- C . Microsoft SQL Server Management Studio (SSMS)
- D . Azure Data Explorer
A
Explanation:
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
When you create an Azure SQL database, which account can always connect to the database?
- A . the Azure Active director/ (Azure AO) account that created the database
- B . the Azure Active Directly Azure AD) administrator account
- C . the sa account
- D . the server admin login account of the logical server
D
Explanation:
When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
HOTSPOT
For each of the following statements, select yes if the statement is true, Otherwise, select No. Note: Each correct selection is worth one point.
