dp-900 Practice Question 1815

Exam: dp-900
Domain: Describe core data concepts
Topic: Describe data analytics core concepts
Difficulty: medium
Contoso Ltd is experiencing slow data ingestion into their Azure Synapse Analytics environment. They suspect that the issue might be related to the data source or the ingestion method. Which of the following actions should they take to diagnose and potentially resolve the issue?

Answer Options

A
Change the data source from SQL Server to Cosmos DB
B
Use Azure Monitor Logs to monitor data ingestion performance
C
Optimize the storage account by reducing cold access tiers
D
Increase the number of compute nodes in the Azure Synapse Analytics environment

Correct Answer

B: Use Azure Monitor Logs to monitor data ingestion performance

Explanation

The correct answer is to use the Azure Monitor Logs to monitor the performance of the data ingestion process. This will help identify if the issue is with the data source or the ingestion method. Option A is incorrect because it involves changing the data source type, which may not address the current performance issue. Option C is incorrect as it focuses on optimizing the storage account, which is not directly related to the ingestion speed. Option D is incorrect because it suggests increasing the compute resources, which might not solve the ingestion performance issue.