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 51–60 of 147

Q51

What happens when you use Azure Data Factory with a copy activity?

  • A Data is transformed only
  • B Data is duplicated in storage
  • C Data is moved without changes
  • D Data is deleted post-migration
Explanation A copy activity moves data without transformation or deletion, while the others incorrectly suggest different behaviors.
Q52

Which service is primarily used for stream processing in Azure?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics is specifically designed for real-time stream processing, whereas the other options serve different functionalities.
Q53

A company needs to analyze interaction data in real-time while minimizing latency. Which Azure service should they implement?

  • A Azure Data Factory
  • B Azure Synapse Analytics
  • C Azure Cosmos DB
  • D Azure Data Lake Storage
Explanation Azure Cosmos DB is designed for low-latency operations, making it suitable for real-time analytics.
Q54

What happens when you set up an Azure SQL Database with no pricing tier specified?

  • A It defaults to Basic tier
  • B It will fail to create
  • C It defaults to Standard tier
  • D It will use premium features
Explanation Azure SQL Database defaults to the Basic pricing tier if none is specified.
Q55

Which service is designed for real-time analytics in Azure?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Virtual Machines
Explanation Azure Stream Analytics allows for real-time data analysis, while others serve different purposes.
Q56

A company needs to migrate a SQL database to Azure. What should they use?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Cosmos DB
  • D Azure Data Lake
Explanation Azure SQL Database is optimized for SQL workloads, unlike the other options.
Q57

You are configuring data redundancy in Azure; what happens if you choose RA-GRS?

  • A Data is lost during outages.
  • B Data is replicated in one regional pair.
  • C Data is available in a secondary region.
  • D Data incurs higher storage costs.
Explanation RA-GRS ensures availability by replicating data to a secondary region, while others are incorrect implications.
Q58

Which service is primarily used for real-time analytics in Azure?

  • A Azure Stream Analytics
  • B Azure Functions
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics processes real-time data, while the others serve different functions.
Q59

A company needs to ensure high availability for its Azure SQL Database. What should they do?

  • A Use Active Geo-Replication
  • B Select Basic Tier
  • C Enable Auto-Scaling
  • D Use Data Lake Storage
Explanation Active Geo-Replication allows for high availability by creating readable secondary databases.
Q60

You are configuring security for Azure Data Lake Storage. What happens when you set access policies to 'Deny'?

  • A Permissions are removed completely
  • B Previous permissions remain active
  • C Data can still be read
  • D Users have no access rights
Explanation Setting 'Deny' removes all permissions for the specified users or groups.