Microsoft Azure Data Fundamentals practice questions

Try 25 supported questions from the 165-question bank. Check each answer when you are ready and keep this preview’s progress privately in your browser.

Back to the DP-900 exam guide Switch to a timed mock

Free preview

25 of 165 questions are open

This sample includes answers, available explanations, official references and curated community discussion. An Exam Pass unlocks the private complete bank for this exam.

See Exam Pass pricing

Answer support

What is available on this page

2 contested answers

Questions: 25
Explanations: 25
Candidate context: 25
Question citations: 25

25 questions in this bank

Question 1 of 25
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
Show answer
Correct answer: D
How others answered
D76%
C16%
Explanation
Key/Value is not correct: The records habe multiple attributes, in Key/Value store you can just store one attribute. Most appropiate aswer would be Document, because attributes are not consistent in records. Since Document is not a choice, another alternative is table storage (allowing NULL values for selected columns)
Adapted from community discussion by cmohl2013 · 2022-11-24 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 1 Report an issue
Candidate context
Question 1 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
B
blablablax
2021-02-28
55 upvotes
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview#column-family-databases
Z
zxmaz01
2022-11-30
19 upvotes
Am I the only one, who is confused by the first three students having the same number? :-D
C
cmohl2013
2022-11-24
Selected D9 upvotes
Key/Value is not correct: The records habe multiple attributes, in Key/Value store you can just store one attribute. Most appropiate aswer would be Document, because attributes are not consistent in records. Since Document is not a choice, another alternative is table storage (allowing NULL values for selected columns)
W
wklambert
2022-02-23
10 upvotes
Key/Value would not be appropriate because of the duplicate keys.
Question 2 of 25
Which storage solution supports role-based access control (RBAC) at the file and folder level?
Show answer
Correct answer: B
How others answered
B100%
Explanation
Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs). This article summarizes the basics of the access control model for Data Lake Storage Gen2. ACLs are applied on the file and folder level. The key thing to remember is that you are always going to need RBAC Control Plane permissions in combination with ACLs. Best practice is to assign your security principals RBAC Reader role on the Storage Account/Container level and continue with more restrictive ACLs on the file and folder level. There are two types of ACLs: Access ACLs: They control access to an object. An object can be a file or a folder. Default ACLs: These are ACLs assigned on the folder level only which get inherited as Access ACLs by the child file or folder.
Adapted from community discussion by GetulioJr · 2021-12-11 · 31 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
azure.microsoft.com documentation
Microsoft Learn
Permanent link to question 2 Report an issue
Candidate context
Question 2 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
G
GetulioJr
2021-12-11
31 upvotes
Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs). This article summarizes the basics of the access control model for Data Lake Storage Gen2. ACLs are applied on the file and folder level. The key thing to remember is that you are always going to need RBAC Control Plane permissions in combination with ACLs. Best practice is to assign your security principals RBAC Reader role on the Storage Account/Container level and continue with more restrictive ACLs on the file and folder level. There are two types of ACLs: Access ACLs: They control access to an object. An object can be a file or a folder. Default ACLs: These are ACLs assigned on the folder level only which get inherited as Access ACLs by the child file or folder.
N
ntdocs19
2021-09-14
2 upvotes
B ADSL is correct. Azure Disk Storage is designed to be used with Azure Virtual Machines, Azure Disk Storage offers high-performance, highly durable block storage for your mission- and business-critical applications. Confidently migrate to Azure Infrastructure with four disk storage options for the cloud—Ultra Disk Storage, Premium SSD, Standard SSD, and Standard HDD—to optimize costs and performance for your workload needs. Achieve high performance with sub-millisecond latency for throughput and transaction-intensive workloads such as SAP HANA, SQL Server, and Oracle. https://azure.microsoft.com/en-in/services/storage/disks/
G
Galstonian
2021-07-05
1 upvote
ADLS2 supports RBAC but not at the file and folder level, it is the container level From https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control-model#role-based-access-control-azure-rbac Azure RBAC uses role assignments to apply sets of permissions to security principals. A security principal is an object that represents a user, group, service principal, or managed identity that is defined in Azure Active Directory (AD). A permission set can give a security principal a "coarse-grain" level of access such as read or write access to all of the data in a storage account or all of the data in a container.
J
Joanna0
2023-08-19
Selected B2 upvotes
https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control-model#role-based-access-control-azure-rbac
Question 3 of 25
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
Show answer
Correct answer: D
How others answered
D100%
Explanation
To all of you who wonder what multi-master support actually is: 'Till now, all the distributed system architecture works like one Write data server and multiple Read data servers. Data are replicated to all data servers from Write data server. With the multi-master feature, we can choose all data servers to act as Write server data will be replicated with other data servers. The big challenge of multi-master, avoid the data duplication in data replication.' https://www.c-sharpcorner.com/article/utilize-multi-master-support-in-azure-cosmos-db/
Adapted from community discussion by [Removed] · 2023-12-11 · 19 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
azure.microsoft.com documentation
Microsoft Learn
azure.microsoft.com documentation
Microsoft Learn
Permanent link to question 3 Report an issue
Candidate context
Question 3 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
K
keySEE
2022-07-01
90 upvotes
Just passed the exam with a 1000 score. The multi-master is the correst answer
[
[Removed]
2023-12-11
19 upvotes
To all of you who wonder what multi-master support actually is: 'Till now, all the distributed system architecture works like one Write data server and multiple Read data servers. Data are replicated to all data servers from Write data server. With the multi-master feature, we can choose all data servers to act as Write server data will be replicated with other data servers. The big challenge of multi-master, avoid the data duplication in data replication.' https://www.c-sharpcorner.com/article/utilize-multi-master-support-in-azure-cosmos-db/
F
fflyin2k
2022-04-08
8 upvotes
A should be correct answer. (Agree with hmAZtime) According to following link, - 'master' , 'model' are not mentioned at all. - Global distribution is mentioned. https://docs.microsoft.com/en-us/azure/cosmos-db/table-support
J
JayRee
2022-04-13
4 upvotes
An overview of Azure Cosmos DB multi-master capabilities https://azure.microsoft.com/en-us/resources/videos/ignite-2018-multi-master-at-global-scale-with-azure-cosmos-db/
Question 4 of 25
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. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: Yes - Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in scalable storage. Box 2: No - Box 3: No - Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing
Adapted from community discussion by Armandoo · 2024-09-21 · 70 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 4 Report an issue
Candidate context
Question 4 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
A
Armandoo
2024-09-21
70 upvotes
YES, YES, YES Batch processing can have output to SQL Database, Hive, HBase, Spark SQL. Look at the link and the diagram there https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing
R
ravinperera
2023-11-28
5 upvotes
Statement 1: Batch processing can output data to a file store. Yes. Batch processing can indeed output data to a file store. This is a common use case where processed data is stored in file systems like Azure Blob Storage or other similar cloud-based or on-premises file storage systems. Statement 2: Batch processing can output data to a relational database. Yes. Batch processing can output data to relational databases. After processing, the data can be structured and stored in relational database systems like Azure SQL Database, MySQL, PostgreSQL, or other relational databases. Statement 3: Batch processing can output data to a NoSQL database. Yes. Batch processing can also output data to NoSQL databases. This is particularly useful for unstructured or semi-structured data. NoSQL databases like Azure Cosmos DB, MongoDB, or others can be used for storing the results of batch processing tasks.
L
LarsLarsgren
2022-08-01
5 upvotes
I am pro Yes, Yes, Yes...but... :-) There is one example about Batch services and they describe output to file store (only!) So, in that area it would be Yes, No, No..... just thinking. BTW, passed the exam today. 41 questions, 45 min, 700 points for passing. Many questions were same like here in forum. Tq guys, you are gorgeous!
J
Jeevi0905
2024-07-27
3 upvotes
Batch processing can output data to a file store: Correct Answer: Yes Explanation: Batch processing can indeed output data to a file store. This is commonly used for storing large volumes of data in files, such as logs, reports, or backups. Batch processing can output data to a relational database: Correct Answer: Yes Explanation: Batch processing can also output data to a relational database. This is useful for scenarios where structured data needs to be stored and queried efficiently. Batch processing can output data to a NoSQL database: Correct Answer: Yes Explanation: Yes, batch processing can also output data to a NoSQL database. NoSQL databases are designed to handle unstructured or semi-structured data, making them suitable for various use cases.
Question 5 of 25
You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?
Show answer
Correct answer: C
How others answered
C100%
Explanation
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used. Reference: https://azure.microsoft.com/en-us/services/storage/files/
Adapted from community discussion by sumitkela1 · 2021-06-12 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 5 Report an issue
Candidate context
Question 5 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
D
Dhiva_
2021-03-10
6 upvotes
The answer should be C, the same kinda question was asked in AZ-900 and the answer was C.
P
pandik
2021-05-30
5 upvotes
B is right answer because of they stored the files in shared folder. The question is to move the shared folder data to which solution? so ans is B. they didn't say the file should be shared for others or need SMB like that....
B
Brouhaha
2021-09-10
3 upvotes
As many notice here, C is the correct answer : "You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage" . Your App stores data in a shared folder, on WIndows server, that uses SMB protocol for that. The only Azure store service that allows SMB sharing is file . You can not share a Blob with SMB. The app will stop working if you doing so. While with file share your app will continue to runs at it was on your prem. site.
L
Lakshmana_Babu
2021-06-04
4 upvotes
The Answer is B . Because the Application can store any type of data,i.e audio,video,log files but Azure file storage only allows standard File extensions like *.docx, *.png and *.bak while blob storage doesn't need any specific file extension
Question 6 of 25
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?
Show answer
Correct answer: C
How others answered
C45%
A45%
Only 45% agreed on this answer — treat it as contested rather than settled.
Explanation
Column-family database is the low latency store type. Examples • Recommendations • Personalization • Sensor data • Telemetry • Messaging • Social media analytics • Web analytics • Activity monitoring • Weather and other time-series data
Adapted from community discussion by jasu · 2020-09-09 · 83 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 6 Report an issue
Candidate context
Question 6 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
J
jasu
2020-09-09
83 upvotes
Column-family database is the low latency store type. Examples • Recommendations • Personalization • Sensor data • Telemetry • Messaging • Social media analytics • Web analytics • Activity monitoring • Weather and other time-series data
T
tataiermail
2020-10-05
60 upvotes
Answer may be A. Key/Value stores have fast response time, i.e. low latency. Columnar is good for Analytical. Here question is for Low Latency of a Web User's session data. Not analytical.
M
maggiemhanna
2021-08-16
16 upvotes
Columnar is good for Analytical not transactional data. https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview Examples of key/value applications: Data caching Session management User preference and profile management Product recommendation and ad serving Answer is A
T
tataiermail
2020-10-05
11 upvotes
(correcting my old answer) Answer is C. Because in session data, there are clearly 3 types of attributes being stored: notification, cart info, personalization. these 3 are 3 column-families, which is beter than generic key/value store.
Question 7 of 25
Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema. Which type of data store should you use?
Show answer
Correct answer: C
How others answered
C70%
B30%
Only 70% agreed on this answer — treat it as contested rather than settled.
Explanation
Not only Document databases can store JSON files. From link https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview Document - "Each document type can use its own schema." Key/Value - "Any schema information must be provided by the application." So a document store is a document defined schema, while the question specifically refers to an application defined schema which makes the answer key/value.
Adapted from community discussion by user54321 · 2021-04-21 · 26 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 7 Report an issue
Candidate context
Question 7 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
U
user54321
2021-04-21
26 upvotes
Not only Document databases can store JSON files. From link https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview Document - "Each document type can use its own schema." Key/Value - "Any schema information must be provided by the application." So a document store is a document defined schema, while the question specifically refers to an application defined schema which makes the answer key/value.
S
SnakePlissken
2021-04-04
11 upvotes
B. Key/Value store. You can't use a Document database in this case, because of the conditions: - High volume, so Quick storage is needed - Application defined schema, so the value (containing JSON fields) is opaque to the DBMS References: https://en.wikipedia.org/wiki/Document-oriented_database https://medium.com/bb-tutorials-and-thoughts/200-practice-questions-for-azure-data-dp-900-fundamentals-exam-ea2446ee3a0
M
mamahani
2023-04-12
11 upvotes
I took the exam 12.04.2023; this question appeared, correct answer: document
S
SnottyPudding
2021-08-19
7 upvotes
It has to be key/value. With key/value, the schema is provided by the application. But with a document db, it's not: "Each document type can use its own schema. Document data is semi-structured, meaning that data types of each field are not strictly defined." Therefore, the answer is correct: key/value. https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Question 8 of 25
Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?
Show answer
Correct answer: B
How others answered
B100%
Explanation
Link for time series https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores Telemetry and time series databases are an append-only collection of objects. Telemetry databases efficiently index data in a variety of column stores and in-memory structures, making them the optimal choice for storing and analyzing vast quantities of telemetry and time series data.
Adapted from community discussion by [Removed] · 2022-01-28 · 11 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 8 Report an issue
Candidate context
Question 8 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
[
[Removed]
2022-01-28
11 upvotes
Link for time series https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores Telemetry and time series databases are an append-only collection of objects. Telemetry databases efficiently index data in a variety of column stores and in-memory structures, making them the optimal choice for storing and analyzing vast quantities of telemetry and time series data.
S
Stuurwiel1
2023-07-25
Selected B2 upvotes
A time series database such as InfluxDB, TimescaleDB or OpenTSDB would be a good choice for storing and analyzing temperature data from internet-connected temperature sensors. Time series databases are designed to handle high-frequency, time-stamped data, and they are optimized for storing and querying large amounts of time-series data. They provide built-in support for time-based queries and aggregations, which can be useful for analyzing temperature trends over time. These databases also provide efficient compression and data retention policies that allow the data to be stored for long periods of time with minimal storage overhead, making it a good fit for IoT scenarios where data is generated over time.
S
Sandy1998
2022-04-13
3 upvotes
No - Time-series is a datastore only. Time series databases typically collect large amounts of data in real time from a large number of sources. https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
S
StudyChimp
2023-01-13
2 upvotes
Answer: D - columnar Column-family databases: Examples: Weather and other time-series data https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Question 9 of 25
DRAG DROP - Match the types of activities to the appropriate Azure Data Factory activities. To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: Data movement - Box 2: Data transformation - A pipeline could contain a set of activities that ingest and clean log data, and then kick off a mapping data flow to analyze the log data. Box 3: Control - Lookup Activity is a control flow activity. Lookup Activity can be used to read or look up a record/ table name/ value from any external source. This output can further be referenced by succeeding activities. Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities
Adapted from community discussion by OrangeSG · 2023-06-11 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 9 Report an issue
Candidate context
Question 9 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
M
Mjwc
2022-04-20
18 upvotes
Correct: Movement Transformation Control https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
O
OrangeSG
2023-06-11
10 upvotes
Box 1: Movement Data movement activities: Copy Activity in Data Factory copies data from a source data store to a sink data store. Data from any source can be written to any sink. Box 2: Transformation Mapping data flows are visually designed data transformations in Azure Data Factory. Data flows allow data engineers to develop data transformation logic without writing code. The resulting data flows are executed as activities within Azure Data Factory pipelines that use scaled-out Apache Spark clusters. Box 3: Control Lookup Activity is a control flow activity. Lookup Activity can be used to read or look up a record/ table name/ value from any external source. This output can further be referenced by succeeding activities. Reference Pipelines and activities in Azure Data Factory and Azure Synapse Analytics https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities Mapping data flows in Azure Data Factory https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-overview
[
[Removed]
2023-06-16
6 upvotes
For those who are interested, an easy explanation why 'mapping data flows' is 'transformation': "In October 2018 Microsoft launched mapping data flows which allows ADF to also perform code-free transformations such as joining, splitting or aggregating the data. "
W
wellingtonluis
2022-04-27
2 upvotes
Lookup also is Transformation. This question require many atention. https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity
Question 10 of 25
Select 3
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer
Correct answer: A, C, E
How others answered
ACE100%
Explanation
I took the exam 12.04.2023; this question appeared,correct answer a report page / a visualization from a report / a text box
Adapted from community discussion by mamahani · 2023-10-12 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 10 Report an issue
Candidate context
Question 10 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
B
bfan95
2022-10-25
8 upvotes
A,C,E https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget
M
mamahani
2023-10-12
4 upvotes
I took the exam 12.04.2023; this question appeared,correct answer a report page / a visualization from a report / a text box
J
JA2018
2023-04-07
Selected A, C, E3 upvotes
as explained https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget
E
EstbanFTP
2024-04-30
3 upvotes
A Dashboard can only contain one page. How do you add a report page unless the one report page is a dashboard?
Question 11 of 25
What is the primary purpose of a data warehouse?
Show answer
Correct answer: A
How others answered
A82%
C18%
Explanation
The ans should be A. In the textbook DP-900T00-A-Microsoft Azure Data Fundamentals Module 4 Describe modern data warehousing: ''A data warehouse gathers data from many different sources within an organization...The focus of a data warehouse is to provide answers to complex queries...''
Adapted from community discussion by xavier41 · 2022-01-05 · 32 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
azure.microsoft.com documentation
Microsoft Learn
azure.microsoft.com documentation
Microsoft Learn
Permanent link to question 11 Report an issue
Candidate context
Question 11 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
X
xavier41
2022-01-05
32 upvotes
The ans should be A. In the textbook DP-900T00-A-Microsoft Azure Data Fundamentals Module 4 Describe modern data warehousing: ''A data warehouse gathers data from many different sources within an organization...The focus of a data warehouse is to provide answers to complex queries...''
S
Stuurwiel1
2023-01-25
Selected A4 upvotes
The primary purpose of a data warehouse is to provide answers to complex queries that rely on data from multiple sources. A data warehouse is a large, centralized repository of data that is specifically designed for reporting and analysis. The primary purpose of a data warehouse is to store historical data from multiple sources in a single location, in a format that makes it easy to query and analyze. This data is typically read-only, meaning that it is not intended for transactional use. Instead, it is used for reporting and analysis, such as generating business intelligence reports, performing data mining and modeling, and supporting decision-making processes. Data warehousing also includes transforming data from various sources into a consistent format, making it easy for users to query and analyze data from multiple systems.
O
OrangeSG
2022-12-13
Selected A2 upvotes
Answer C is not correct. From Microsoft AZure web site: A data warehouse is relational in nature. This means that the structure or schema of the data is determined by predefined business and product requirements that are curated, conformed, and optimized for SQL query operations. As a result, data warehouses are best used for storing data that has been treated with a specific purpose in mind, such as data mining for BI analysis, or for sourcing a business use case that has already been identified. Reference What is a data warehouse? https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-data-warehouse/
C
cert_spartan
2022-01-29
Selected A4 upvotes
If you wanted to do C, you could simply create read-only replicas. So A is more logical
Question 12 of 25
What is a function of a modern data warehouse?
Show answer
Correct answer: B
How others answered
B79%
C21%
Explanation
Personal preferrence goes to B. Key phrase is 'modern' data warehouse. From Microsoft learn: Large-scale data warehousing solutions combine conventional data warehousing used to support business intelligence (BI) with techniques used for so-called "big data" analytics. A conventional data warehousing solution typically involves copying data from transactional data stores into a relational database with a schema that's optimized for querying and building multidimensional models. Big Data processing solutions on the other hand, are used with large volumes of data in multiple formats, which is batch loaded or captured in real-time streams and stored in a data lake from which distributed processing engines like Apache Spark are used to process it. Answer C is functional of conventional data warehouse. Reference https://learn.microsoft.com/bs-latn-ba/training/modules/examine-components-of-modern-data-warehouse/1-introduction
Adapted from community discussion by OrangeSG · 2022-12-13 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 12 Report an issue
Candidate context
Question 12 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
D
Dhaval_Azure
2023-02-01
25 upvotes
when its not clear here what to consider as correct answer? paying for dump is not worth in this type of question.
O
OrangeSG
2022-12-13
Selected B15 upvotes
Personal preferrence goes to B. Key phrase is 'modern' data warehouse. From Microsoft learn: Large-scale data warehousing solutions combine conventional data warehousing used to support business intelligence (BI) with techniques used for so-called "big data" analytics. A conventional data warehousing solution typically involves copying data from transactional data stores into a relational database with a schema that's optimized for querying and building multidimensional models. Big Data processing solutions on the other hand, are used with large volumes of data in multiple formats, which is batch loaded or captured in real-time streams and stored in a data lake from which distributed processing engines like Apache Spark are used to process it. Answer C is functional of conventional data warehouse. Reference https://learn.microsoft.com/bs-latn-ba/training/modules/examine-components-of-modern-data-warehouse/1-introduction
M
memzo10
2022-10-05
Selected B3 upvotes
Data warehousing : 1...Data ingestion includes both batch processing of static data and real-time processing of streaming data. https://learn.microsoft.com/en-us/training/modules/examine-components-of-modern-data-warehouse/2-describe-warehousing
R
rmeng
2023-09-05
Selected B1 upvote
B. supports real-time and batch processing A modern data warehouse is designed to support both real-time and batch processing. It allows organizations to ingest, process, and analyze data in real-time as it's generated, while also supporting traditional batch processing for historical analysis. This flexibility enables businesses to gain insights from their data in a timely manner and make informed decisions based on both current and historical data.
Question 13 of 25
What can be used with native notebook support to query and visualize data by using a web-based interface?
Show answer
Correct answer: A
How others answered
A100%
Explanation
Notebooks are a common tool in data science and machine learning for developing code and presenting results. In Azure Databricks, notebooks are the primary tool for creating data science and machine learning workflows and collaborating with colleagues. Databricks notebooks provide real-time coauthoring in multiple languages, automatic versioning, and built-in data visualizations. Reference Introduction to Databricks notebooks https://learn.microsoft.com/en-us/azure/databricks/notebooks/
Adapted from community discussion by OrangeSG · 2023-12-13 · 8 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 13 Report an issue
Candidate context
Question 13 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
O
OrangeSG
2023-12-13
8 upvotes
Notebooks are a common tool in data science and machine learning for developing code and presenting results. In Azure Databricks, notebooks are the primary tool for creating data science and machine learning workflows and collaborating with colleagues. Databricks notebooks provide real-time coauthoring in multiple languages, automatic versioning, and built-in data visualizations. Reference Introduction to Databricks notebooks https://learn.microsoft.com/en-us/azure/databricks/notebooks/
P
Pranava_GCP
2024-04-11
Selected A3 upvotes
Azure Databricks has built-in support for charts and visualizations in both Databricks SQL and in Databricks Runtime. This page describes how to work with visualizations in a Databricks notebook.
P
pallmall
2023-09-06
4 upvotes
A Azure Databricks https://docs.microsoft.com/en-us/azure/databricks/notebooks/visualizations/
J
james2033
2024-10-26
Selected A1 upvote
'Visualizations in Databricks notebooks' - https://learn.microsoft.com/en-us/azure/databricks/visualizations/#------create-a-new-visualization
Question 14 of 25
DRAG DROP - Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: Image files - Azure Blob storage is suitable for image files. Box 2:Key/value pairs - Azure CosmosDB table API is a key-value storage hosted in the cloud. Box 3: Relationship between employees One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service. Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
Adapted from community discussion by tibi1233 · 2021-04-01 · 819 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 14 Report an issue
Candidate context
Question 14 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
T
tibi1233
2021-04-01
819 upvotes
1. Image files = Azure Blob storage 2. Relationship between employyes = Azure Cosmos DB Gremlin API 3. Key/value pairs = Azure Table Storage
N
no121251
2021-08-18
88 upvotes
Did the person who prepared these answers even pass the test themselves? This isn't even an accidental swap, just a clear misunderstanding from the person who wrote the answer. The Azure Table storage module on MS Learn EXPLICITLY STATES that a weakness of Table storage is its inability to document relationships between rows/entities in the table.
P
pepix74
2021-04-02
12 upvotes
I agree, the relationship between employees is one of the first examples of a graph database (and therefore Gremlin API).
C
cp2323
2022-04-23
11 upvotes
EXAMTopics - Guys if you are reading this discussion, you should seriously check your answers before publishing them. Giving us wrong answer means that I have to doubt all of the answers you have given which is not why I paid you money!!
Question 15 of 25
DRAG DROP - Match the Azure Data Lake Storage Gen2 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. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
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
Adapted from community discussion by seantb · 2021-04-03 · 293 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 15 Report an issue
Candidate context
Question 15 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
S
seantb
2021-04-03
293 upvotes
The question says this is an ADL, in which case you would create a container not a file share... you can have folders and files in the container
M
mamahani
2023-04-12
25 upvotes
I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: Azure Storage account - Container
E
Emmanski08
2022-06-30
12 upvotes
Should be container, if you have doubts please refer in this link. https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-non-relational-data-services-azure/3-azure-data-lake-gen2
A
aleexoo
2022-01-06
10 upvotes
right answers are -Azure Storage Account -Container if you have some doubts perform the following exercice: https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-non-relational-data-services-azure/7-exercise-provision-non-relational-azure in section "Create an Azure Storage account for Data Lake Storage", there's no File share creation
Question 16 of 25
DRAG DROP - Match the Azure Data Factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: Dataset - Datasets must be created from paths in Azure datastores or public web URLs, for the data to be accessible by Azure Machine Learning. Box 2: Linked service - Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources. Box 3: Pipeline - A pipeline is a logical grouping of activities that together perform a task. Reference: https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/ https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
Adapted from community discussion by Meyti · 2021-11-25 · 13 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 16 Report an issue
Candidate context
Question 16 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
M
Meyti
2021-11-25
13 upvotes
Correct. Azure Data Factory and Azure Synapse Analytics: A Data Factory or Synapse Workspace can have one or more pipeline. Pipeline: A pipeline is a logical grouping of activities that together perform a task and can be scheduled. The activities in a pipeline define actions to perform on your data. a Dataset is a named view of data that simply points or references the data you want to use in your activities as inputs and outputs. Datasets identify data within different data stores, such as tables, files, folders, and documents. Before you create a dataset, you must create a linked service to link your data store to the service. Linked services are much like connection strings, which define the connection information needed for the service to connect to external resources. Think of it this way; the dataset represents the structure of the data within the linked data stores, and the linked service defines the connection to the data source. https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services#overview
C
Crazy_Angel
2021-06-27
5 upvotes
Dataset: A data set (or dataset) is a collection of data. In the case of tabular data, a data set corresponds to one or more database tables, where every column of a table represents a particular variable, and each row corresponds to a given record of the data set in question. Linked service: the information used to connect to external resources Pipeline: A logical grouping of activities that performs a unit of work and can be scheduled.
Y
yeanlingmedal71
2021-05-21
5 upvotes
https://docs.microsoft.com/en-us/azure/data-factory/concepts-datasets-linked-services
M
man5484
2024-11-18
2 upvotes
A dataset in Azure Data Factory represents the structure of the data within a data store, such as a table in a database or a file in storage. A linked service is a configuration that defines the connection information to external resources, such as databases or storage accounts. A pipeline in Azure Data Factory is a logical grouping of activities that define the workflow to perform data movement and transformation, and it can be scheduled for execution.
Question 17 of 25
You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
Show answer
Correct answer: B
How others answered
B89%
Explanation
Ans is B for me. Due to no az storage table create in the selection. The best answer is B create storage account (first)
Adapted from community discussion by PanP · 2021-10-28 · 84 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 17 Report an issue
Candidate context
Question 17 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
P
PanP
2021-10-28
84 upvotes
Ans is B for me. Due to no az storage table create in the selection. The best answer is B create storage account (first)
W
walkwolf3
2021-10-25
16 upvotes
It could be "az storage table create" https://docs.microsoft.com/en-us/cli/azure/storage/table?view=azure-cli-latest
A
amraneze
2022-02-06
10 upvotes
Normally, they should write table but if it's not mentionned then account because you can't have a table in azure table without an azure storage account
M
man5484
2024-11-18
5 upvotes
B. az storage account create (Correct answer) Azure Table Storage is part of Azure Storage, and before you can use Table storage, you need to create an Azure Storage account. The az storage account create command is used to create an Azure Storage account. A. az storage share create Incorrect. This command is used to create a file share in Azure File Storage, not Table Storage. C. az cosmosdb create Incorrect. This command is used to create an Azure Cosmos DB account, which is a separate service for NoSQL databases. D. az storage container create Incorrect. This command is used to create a blob container for storing unstructured data (e.g., files, images), not Table Storage.
Question 18 of 25
HOTSPOT - You plan to deploy a PostgreSQL database to Azure. Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Reference: https://azure.microsoft.com/en-us/overview/what-is-saas/ https://azure.microsoft.com/en-us/overview/what-is-paas/
Adapted from community discussion by SameerL · 2022-06-23 · 14 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 18 Report an issue
Candidate context
Question 18 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
K
Kardec
2021-10-24
387 upvotes
The correct answer is iaas and paas. https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options
J
jellybiscuit
2022-09-02
39 upvotes
It sure would be great if the site updated their wrong answers. 10 months later, and it's still wrong.
S
SameerL
2022-06-23
14 upvotes
>>> PostgreSQL on Azure VMs option falls into the industry category of IaaS per below post...... https://docs.microsoft.com/en-us/azure/postgresql/single-server/overview-postgres-choose-server-options So the correct answer is iaas and paas.
B
blueCrystal
2022-01-28
12 upvotes
true as you can see in the document, under Postgres on Azure VMs, everything is customer managed that means Postgres on Azure VMs is an IAAS
Question 19 of 25
What is a characteristic of batch processing?
Show answer
Correct answer: C
How others answered
C99%
Explanation
I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: there is a noticeable time delay between ingesting data and obtaining the data processing results
Adapted from community discussion by mamahani · 2023-04-12 · 16 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 19 Report an issue
Candidate context
Question 19 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
M
mamahani
2023-04-12
16 upvotes
I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: there is a noticeable time delay between ingesting data and obtaining the data processing results
P
pads98
2022-04-21
Selected C5 upvotes
Answer is C according to documentation - Unlike real-time processing, batch processing is expected to have latencies (the time between data ingestion and computing a result) that measure in minutes to hours. https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing
H
heobanten04
2024-03-30
6 upvotes
I took the exam 30.03.2024 and got 936; this question appeared, correct answer: C
F
fross
2022-07-27
Selected C4 upvotes
Absolutely makes no sense that batch processing can only process strucutred data! How does (big) unstructured data get processed into structured in the first place?! It is *BATCH*
Question 20 of 25
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
Show answer
Correct answer: B
How others answered
B100%
Explanation
SQL Database - https://azure.microsoft.com/en-us/products/azure-sql/database/#features Fully managed SQL database automates updates, provisioning, and backups so you can focus on application development
Adapted from community discussion by yeanlingmedal71 · 2021-06-03 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
azure.microsoft.com documentation
Microsoft Learn
azure.microsoft.com documentation
Permanent link to question 20 Report an issue
Candidate context
Question 20 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
A
Armandoo
2021-06-10
73 upvotes
Correct Answer: B Minimize maintenance: so it should a PaaS + Relational Database = Azure SQL Database
M
mamahani
2023-04-12
8 upvotes
I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: Azure SQL Database
Y
yeanlingmedal71
2021-06-03
5 upvotes
SQL Database - https://azure.microsoft.com/en-us/products/azure-sql/database/#features Fully managed SQL database automates updates, provisioning, and backups so you can focus on application development
E
edurakhan
2022-11-14
Selected B4 upvotes
B is the correct answer. Minimize maintenance is the key phrase
Question 21 of 25
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?
Show answer
Correct answer: B
How others answered
B100%
Explanation
B. Azure Data Studio is a cross-platform database tool that allows you to embed documents and query results into a SQL notebook. It supports Azure SQL databases, SQL Server, and other databases. It also has built-in support for SQL Notebooks, which allows you to mix markdown, code, and results in a single notebook. This makes it a great tool for creating documentation and troubleshooting guides for administrators to use when working with Azure SQL databases.
Adapted from community discussion by Pinha · 2023-07-24 · 16 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 21 Report an issue
Candidate context
Question 21 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
F
Fellipo
2021-05-02
74 upvotes
B its OK , https://docs.microsoft.com/en-us/sql/azure-data-studio/notebooks/notebooks-sql-kernel?view=sql-server-ver15
P
Pinha
2023-07-24
16 upvotes
B. Azure Data Studio is a cross-platform database tool that allows you to embed documents and query results into a SQL notebook. It supports Azure SQL databases, SQL Server, and other databases. It also has built-in support for SQL Notebooks, which allows you to mix markdown, code, and results in a single notebook. This makes it a great tool for creating documentation and troubleshooting guides for administrators to use when working with Azure SQL databases.
F
fdlsys
2021-07-06
10 upvotes
SSMS does not support embedding of documents nor creation of "notebooks". So the answer is "B".
J
jasu
2021-03-09
8 upvotes
SSMS remains the primary tool for SQL Server specialists. Azure Data Studio is a terrific, complementary tool, with strong use cases for cross-platform experiences and SQL Notebooks. ADS is used for SQL Notebooks. Reference: https://www.red-gate.com/simple-talk/opinion/editorials/sql-server-management-studio-is-as-relevant-as-ever/
Question 22 of 25
Which command-line tool can you use to query Azure SQL databases?
Show answer
Correct answer: A
How others answered
A100%
Explanation
I think 90% the answer is A https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-use-the-utility?view=sql-server-ver15 Az cli is perfect to create and manage the DB but to query sqlcmd is the tool
Adapted from community discussion by Sc2 · 2021-03-06 · 113 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 22 Report an issue
Candidate context
Question 22 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
S
Sc2
2021-03-06
113 upvotes
I think 90% the answer is A https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-use-the-utility?view=sql-server-ver15 Az cli is perfect to create and manage the DB but to query sqlcmd is the tool
E
ExamPwnr
2021-03-06
35 upvotes
Correct answer: A Azure CLI page: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=single-database "You can configure Azure SQL Database and SQL Managed Instance by using the Azure CLI." You cannot execute queries though. sqlcmd: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15 It is clearly mentioned that Azure SQL is supported, and Query examples are provided in the link above.
H
Haidardba
2021-05-27
7 upvotes
Yes, Use the [sqlcmd][sqlcmd] command-line utility to connect to and query a SQL pool. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-connect-sqlcmd
J
jasu
2021-03-09
7 upvotes
Correct Answer is A. SQLCMD can be used for all SQL type including Azure SQL DB. https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=azuresqldb-current
Question 23 of 25
HOTSPOT - You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: star schema - In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries. Example: Incorrect Answers: The data in the question is not normalized. The snowflake schema is a variation of the star schema, featuring normalization of dimension tables. Example: Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.[citation needed]. "Snowflaking" is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle. Box 2: dimension - The star schema consists of one or more fact tables referencing any number of dimension tables. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview https://en.wikipedia.org/wiki/Star_schema https://en.wikipedia.org/wiki/Snowflake_schema https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/
Adapted from community discussion by yeanlingmedal71 · 2021-11-21 · 23 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 23 Report an issue
Candidate context
Question 23 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
C
chaudha4
2021-10-09
28 upvotes
Seems like this question is outside the scope of DP-900 exam. It is not covered in Azure training for DP-900 exam.
Y
yeanlingmedal71
2021-11-21
23 upvotes
Star Schema in data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. It is known as star schema as its structure resembles a star. Dimension tables describe business entities—the things you model. Entities can include products, people, places, and concepts including time itself. Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc. A fact table contains dimension key columns that relate to dimension tables, and numeric measure columns. https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
X
xRiot007
2023-01-11
7 upvotes
Star schema - you have multiple dimension tables linked by a fact table. Customer is one of the dimension tables.
D
DrCloud
2021-12-20
6 upvotes
Correct Answer. https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview#column-family-databases Under "Data analytics" section: Data type Usually denormalized in a "star" or "snowflake" schema, consisting of fact and dimension tables.
Question 24 of 25
You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?
Show answer
Correct answer: A
How others answered
A100%
Explanation
SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project
Adapted from community discussion by nicolase · 2022-08-17 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 24 Report an issue
Candidate context
Question 24 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
N
nicolase
2022-08-17
Selected A10 upvotes
SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project
T
theLazyGuy
2022-04-29
6 upvotes
...Using SSDT, you can create an offline database project... (https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15)
A
Armandoo
2021-12-10
5 upvotes
Correct Answer: SSDT SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
P
p6wruv
2022-02-20
6 upvotes
Both A and B can do this Offline. Install the Management Studio and you will see that you can use visual tools and work offline.
Question 25 of 25
DRAG DROP - Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match its worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer
Explanation
Box 1: Azure SQL Database single database Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. Scenarios well suited for serverless compute Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time. Single databases in the provisioned compute tier that are frequently rescaled and customers who prefer to delegate compute rescaling to the service. New single databases without usage history where compute sizing is difficult or not possible to estimate prior to deployment in SQL Database. Box 2: Azure SQL Managed Instance Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. Box 3: Azure SQL Database elastic pool Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
Adapted from community discussion by brainiacATH · 2022-09-22 · 18 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.
Supporting references
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Answer figure
Permanent link to question 25 Report an issue
Candidate context
Question 25 discussion
These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-900 or CertExamHQ.
B
brainiacATH
2022-09-22
18 upvotes
Correct answer should be single, MI, single. Elastic Pool uses a server, and is thus not serverless, and the third point refers to 'a database' while Elastic Pool is for scaling multiple databases.
A
aadil111
2023-03-22
5 upvotes
1. Azure SQL Database Elastic Pool: C. A low-cost, low-maintenance database. • An Azure SQL Database Elastic Pool allows you to manage and scale multiple databases with a shared set of resources. It is a cost-effective option for managing databases with varying and unpredictable usage patterns. 2. Azure SQL Database Single Database: B. A database that has the highest compatibility with on-premises Microsoft SQL Server. • Azure SQL Database Single Database is a fully managed, highly available, and scalable relational database service. It provides the highest compatibility with on-premises Microsoft SQL Server and supports most of the features available in SQL Server. 3. Azure SQL Managed Instance: A. A serverless config. • Azure SQL Managed Instance is a fully managed platform-as-a-service (PaaS) solution that provides SQL Server compatibility. It offers a serverless configuration that automatically scales compute and storage resources based on the workload demands.
P
PatYeo
2022-10-03
7 upvotes
The model answer appears to be correct based on the supporting statements and links : 1) Single Instance 2) Managed Instance 3) Elastic Pool
O
OldSchool
2022-10-21
5 upvotes
1. Single Instance "Serverless is a compute tier for single databases in Azure SQL Database..." https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql 2. Managed Instance 3. Elastic Pool "Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands." https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

About this question bank

Community-contributed

Compiled from exam discussions posted publicly by other people on ExamTopics. Copyright in each contribution rests with its original author; it is reproduced here for study. Not verified by us — most items carry no explanation. To request removal, see our content policy.

Compiled from ExamTopics community discussions

Compiled from publicly posted community exam discussions. Contributed by third parties rather than written here, so accuracy varies and most items carry no explanation.

Across the private full bank: 126 explanations, 161 questions with candidate context and 100 questions with direct citations.

Version 1.0.0 · bank updated 2026-08-29. How we source questions