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 131–140 of 147

Q131

A company needs to securely share data with partner organizations. Which service should they utilize?

  • A Azure Data Share
  • B Azure Event Hub
  • C Azure IoT Hub
  • D Azure SQL Managed Instance
Explanation Azure Data Share is specifically designed for sharing datasets securely, while the others focus on different data distribution or management tasks.
Q132

You are configuring Azure Data Factory for ETL processes. What happens when you set a pipeline to 'AutoResolveIntegrationRuntime'?

  • A Uses a self-hosted runtime
  • B Selects runtime based on activity
  • C Requires manual runtime assignment
  • D Stops at runtime errors
Explanation Setting 'AutoResolveIntegrationRuntime' allows Azure Data Factory to automatically select the integration runtime based on the activity's requirements, ensuring efficiency.
Q133

Which Azure service is used for real-time data ingestion?

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

A company needs to analyze their unstructured data in Azure. Which service should they use?

  • A Azure Data Lake Storage
  • B Azure Cosmos DB
  • C Azure SQL Database
  • D Azure Synapse Analytics
Explanation Azure Data Lake Storage is designed for unstructured data, while the others are more structured.
Q135

You are configuring Azure Logic Apps to automate workflows. What is the main benefit?

  • A Fast data processing
  • B Visual workflow design
  • C Complex AI integrations
  • D Real-time analytics
Explanation Azure Logic Apps focus on visual workflows for automation, not complex AI or analytics.
Q136

Which Azure service is optimally used for big data analytics?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Cosmos DB
Explanation Azure Synapse Analytics is designed for big data processing, while the others serve different purposes.
Q137

A company needs to perform real-time stream processing of data. Which Azure service is best suited for this task?

  • A Azure Stream Analytics
  • B Azure SQL Database
  • C Azure Data Lake Storage
  • D Azure App Service
Explanation Azure Stream Analytics specializes in real-time data processing, unlike the other services listed.
Q138

What happens when you increase the performance level of an Azure SQL Database?

  • A Increased storage capacity only
  • B Improved query performance
  • C Higher cost without benefits
  • D Reduced backup frequency
Explanation Increasing performance level enhances query performance, while the other options do not accurately represent the effects.
Q139

Which Azure service is designed for real-time analytics?

  • A Azure Synapse Analytics
  • B Azure Data Lake Storage
  • C Azure Stream Analytics
  • D Azure Blob Storage
Explanation Azure Stream Analytics enables real-time data processing, while the other options focus on storage or batch processing.
Q140

A company needs to ensure data redundancy across multiple regions. Which service should they choose?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Table Storage
  • D Azure Data Factory
Explanation Azure Blob Storage offers geo-redundant storage across regions, unlike the other services listed.