Microsoft Azure

Microsoft Azure Data Fundamentals

DP-900

Start your data journey with the DP-900 exam covering Azure Data Fundamentals.

147 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 1–10 of 147

Q1

Which service provides data warehousing solutions in Azure?

  • A Azure SQL Data Warehouse
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure SQL Data Warehouse is specifically designed for analytics and data warehousing, while the others serve different purposes.
Q2

A company needs to stream real-time data from multiple sources. Which Azure service should they use?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Synapse Analytics
  • D Azure Data Factory
Explanation Azure Stream Analytics is designed for real-time data streaming, unlike the other services which focus on storage or batch processing.
Q3

What happens when you delete a resource in Azure?

  • A It is permanently removed.
  • B It enters a recovery state.
  • C It is moved to another subscription.
  • D It is archived automatically.
Explanation Deleting a resource in Azure permanently removes it unless a recovery option is configured, which is not typical.
Q4

Which service is primarily used for implementing a data lake in Azure?

  • A Azure Data Lake Storage
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Cosmos DB
Explanation Azure Data Lake Storage is optimized for big data analytics, while others serve different purposes.
Q5

A company needs to run real-time analytics on streaming data. Which Azure service should they use?

  • A Azure SQL Database
  • B Azure Stream Analytics
  • C Azure Logic Apps
  • D Azure Data Factory
Explanation Azure Stream Analytics is designed specifically for real-time data processing, unlike other listed services.
Q6

You are configuring a data warehouse in Azure. What will happen if you increase the number of data distribution nodes?

  • A Cost will decrease significantly
  • B Query response time will improve
  • C Data replication frequency will increase
  • D Execution of DML operations will fail
Explanation Increasing nodes enhances parallel processing capabilities, improving response times; other options do not correctly represent outcomes.
Q7

Which service is used for relational data in Azure?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Cosmos DB
Explanation Azure SQL Database is specifically designed for relational data, while the others serve different data types.
Q8

A company needs to analyze large volumes of streaming data in real-time. Which Azure service is best suited for this?

  • A Azure HDInsight
  • B Azure Data Factory
  • C Azure Stream Analytics
  • D Azure Databricks
Explanation Azure Stream Analytics is designed for real-time data analysis, while the others focus on batch processing or data orchestration.
Q9

You are configuring Azure Data Lake Storage. What happens if you set access permissions to ‘private’?

  • A Only the owner can access files
  • B Everyone can access files
  • C Access granted to applications only
  • D Everyone can edit files
Explanation Setting permissions to 'private' restricts access to only the owner, while the other options suggest broader accessibility.
Q10

Which service is primarily used for analytics in Azure?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure VPN Gateway
  • D Azure Functions
Explanation Azure Synapse Analytics is designed for data analytics, while the others serve different purposes.