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 21–30 of 147

Q21

You are configuring data access in Azure Data Lake Storage. What happens if you set an ACL with full access for a user?

  • A User can read and write data
  • B User can only read data
  • C User cannot access data
  • D User can delete data only
Explanation Full access includes permissions to read and write, while other options limit access.
Q22

Which service provides real-time analytics on streaming data?

  • A Azure Data Lake Storage
  • B Azure Stream Analytics
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics is designed specifically for real-time data analysis, while the others serve different purposes.
Q23

A company needs to securely share data with partners while maintaining control. Which Azure service should they use?

  • A Azure Data Factory
  • B Azure Data Share
  • C Azure SQL Database
  • D Azure Event Hubs
Explanation Azure Data Share allows controlled data sharing, unlike the other options.
Q24

What happens when you enable Azure Data Encryption at Rest?

  • A Only certain data is encrypted
  • B All data is encrypted automatically
  • C Data can only be accessed in the cloud
  • D Encryption sends data to another region
Explanation Enabling encryption at rest ensures that all stored data is encrypted automatically.
Q25

Which service provides managed data lake solutions in Azure?

  • A Azure Data Lake Storage
  • B Azure Blob Storage
  • C Azure Database for MySQL
  • D Azure Function Apps
Explanation Azure Data Lake Storage is specifically designed for data lakes, while others serve different purposes.
Q26

A company needs to analyze large sets of structured and semi-structured data in real-time. Which Azure service would be best suited for this scenario?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Data Factory
  • D Azure SQL Database
Explanation Azure Synapse Analytics provides analytics capabilities for large data sets, unlike the others which serve different data processing needs.
Q27

You are configuring a data solution that requires integration with both Azure and on-premises databases. What should you consider for effective data movement?

  • A Use Azure Data Factory with Hybrid Integration
  • B Deploy Azure Functions for data transfer
  • C Utilize Azure Logic Apps exclusively
  • D Only use Azure Logic Apps without integration tools
Explanation Azure Data Factory offers hybrid integration capabilities, while others do not fully support this use case.
Q28

Which service provides a fully managed data warehouse solution?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Cosmos DB
  • D Azure Data Lake Storage
Explanation Azure Synapse Analytics is designed for enterprise data warehousing, while the others serve different purposes.
Q29

A company needs to gather metrics and logs from all Azure resources. Which service should they use?

  • A Azure Monitor
  • B Azure Storage
  • C Azure Functions
  • D Azure SQL Database
Explanation Azure Monitor is specifically built for collecting metrics and logs, while the others do not provide this functionality.
Q30

You are configuring Azure Data Factory. What happens if you set an activity to 'Retry' multiple times?

  • A It skips the activity
  • B It fails the pipeline immediately
  • C It attempts the activity again
  • D It stops all subsequent activities
Explanation Setting 'Retry' means the activity will be attempted again upon failure, unlike the other options which are incorrect actions in this context.