dp-900 Practice Question 1840
Exam: dp-900
Domain: Describe an analytics workload on Azure
Topic: Describe data analytics workloads
Difficulty: medium
Contoso Ltd is experiencing slow query performance in their data warehouse environment. They suspect that the issue might be related to the type of workload being processed. Which of the following should they investigate first to determine if it's an OLTP or OLAP workload issue?
Answer Options
A
Check the network latency between the data warehouse and the application servers.
B
Analyze the query patterns to determine if they are OLTP or OLAP.
C
Verify the storage space available in the data warehouse.
D
Increase the number of compute nodes in the data warehouse cluster.
Correct Answer
B: Analyze the query patterns to determine if they are OLTP or OLAP.
Explanation
The correct answer is B. To determine if the issue is related to OLTP or OLAP, one should first check the nature of the queries being executed. OLTP workloads involve frequent, short transactions, while OLAP workloads involve complex, analytical queries.