Free DP-900 Exam Practice Questions
Practice for DP-900: Microsoft Azure Data Fundamentals exam - disclaimer
-
Exam Code: DP-900
Exam Title: Microsoft Azure Data Fundamentals - Exam Provider: Microsoft
- Total Exam Questions: 123
- Last Updated On: 27 May 2024
Exercise : Exam DP 900 Microsoft Azure Data Fundamentals MCQ Questions and Answers
Question 1
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. document
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Which three objects can be added to a Microsoft Power BI dashboard? Each Answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.
A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. ACE
Description :
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/createreports/service-dashboard-add-widget
Question 3
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Microsoft SQL Server Data Tools (SSDT)
Description :
Reference:
https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15
Question 4
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Azure Active Directory (Azure AD) authentication
Description :
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
Question 5
Which statement is an example of Data Definition Language (DDL)?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. CREATE
Description :
Reference:
https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
Question 6
You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict
various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. a report
Description :
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/powerbi/
visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Question 7
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:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Yes, Yes, Yes
Description :
Box 1: Yes -
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output
data sinks for Apache
Spark jobs.
Box 2: Yes -
You can stream data into Azure Databricks using Event Hubs.
Box 3: Yes -
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and
stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/enus/azure/databricks/scenarios/databricks-stream-from-eventhubs
Question 8
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:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Yes, Yes, No
Description :
Box 1: Yes -
Compute is separate from storage, which enables you to scale compute independently of the data in your system.
Box 2: Yes -
You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.
Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute
during that hour.
Box 3: No -
Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.
Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/
Question 9
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 per 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.
Select and Place:
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. SELECT, GROUP BY
Description :
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
Question 10
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. latency is expected.
Description :
Answer:
Reference:
https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/