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 41–50 of 147

Q41

A company needs to manage access to its Azure resources. What should it use?

  • A Azure Log Analytics
  • B Azure Active Directory
  • C Azure Advisor
  • D Azure SQL Database
Explanation Azure Active Directory provides identity and access management, unlike the other services.
Q42

You are configuring a NoSQL database in Azure. What happens if you choose Azure Table Storage over Cosmos DB?

  • A Higher scalability and lower cost
  • B Automatic multi-region replication
  • C Limited querying capabilities
  • D Supports rich data types
Explanation Azure Table Storage offers basic querying compared to the rich querying of Cosmos DB, limiting functionality.
Q43

Which service can be used for real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Cosmos DB
Explanation Azure Stream Analytics processes real-time data, unlike the others.
Q44

A company needs to analyze data using SQL without managing infrastructure. Which service should they choose?

  • A Azure SQL Managed Instance
  • B Azure SQL Database
  • C Azure Cosmos DB
  • D Azure Data Lake Storage
Explanation Azure SQL Database offers serverless options to manage SQL database without infrastructure.
Q45

What happens when you enable soft delete on Azure Blob Storage?

  • A Blobs are permanently deleted instantly
  • B Blobs are recoverable for a period
  • C You cannot access deleted blobs
  • D Only admins can recover blobs
Explanation Soft delete allows recovery of deleted blobs for a specified period.
Q46

Which Azure service is designed for distributed data processing?

  • A Azure Data Lake
  • B Azure Cosmos DB
  • C Azure Synapse Analytics
  • D Azure Blob Storage
Explanation Azure Synapse Analytics is specifically built for large-scale data processing; the others serve different primary purposes.
Q47

A company needs a solution for real-time analytics on streaming data. Which service should they use?

  • A Azure Data Factory
  • B Azure Logic Apps
  • C Azure Stream Analytics
  • D Azure Table Storage
Explanation Azure Stream Analytics specializes in real-time data stream processing, while others lack this capability.
Q48

What happens when you assign a role to a user in Azure?

  • A User gains access to all resources
  • B User permissions are logged directly
  • C User receives specific resource permissions
  • D User is unable to log in
Explanation Assigning a role gives users specific permissions as defined by that role, others are not reflective of Azure's role-based access control.
Q49

Which service is used for real-time analytics on streaming data in Azure?

  • A Azure Stream Analytics
  • B Azure Storage
  • C Azure Data Lake
  • D Azure Blob Storage
Explanation Azure Stream Analytics is designed for real-time analytics, while the others are used for different storage and processing purposes.
Q50

A company needs to store semi-structured data like JSON. Which Azure service should they use?

  • A Azure SQL Database
  • B Azure Cosmos DB
  • C Azure Blob Storage
  • D Azure Table Storage
Explanation Azure Cosmos DB natively supports semi-structured data like JSON, while others are more suited for relational or unstructured data.