Identify Roles and Responsibilities for Data Workloads DP-900 Practice Questions (Page 2)

Questions 6–10

1. 6expert · hard

   A data analyst is asked to determine whether a new marketing campaign increased sales. The analyst has access to daily sales data for the campaign period and the same period last year. Which analysis technique should the analyst use to isolate the campaign's impact?

   • ACalculate the total sales during the campaign period and compare to the total sales last year.
   • BCreate a line chart of daily sales and visually inspect for a spike.
   • CCompare the year-over-year sales growth during the campaign period to the growth rate in the months before the campaign.
   • DBuild a machine learning model to predict sales without the campaign.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the main goal of database performance tuning?

   • ATo improve query response times and overall system efficiency
   • BTo reduce the need for database backups
   • CTo increase the number of database users
   • DTo simplify the database schema
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A database administrator is troubleshooting a performance issue in an Azure SQL Database. The administrator notices that a specific query is causing high CPU usage and blocking other queries. The administrator needs to identify the root cause and resolve it with minimal disruption. What should the administrator do first?

   • AUse Query Performance Insight to review the query's execution plan and wait statistics.
   • BIncrease the database's service tier.
   • CRestart the database service.
   • DKill the blocking query immediately.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A retail company's order database is experiencing slow query performance during peak hours. The database administrator has already verified that indexes are properly maintained. Which action should the DBA take next to address the performance issue?

   • AReconfigure the database to use a lower performance tier to reduce costs.
   • BIncrease the database's maximum size to allow more data to be stored.
   • CDisable the database's automatic tuning features to reduce overhead.
   • DReview the query execution plans to identify missing or ineffective indexes.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A manufacturing company receives sensor data in JSON format from factory equipment and also has historical data in CSV files stored in Azure Blob Storage. The data engineering team needs to combine these into a single Parquet dataset for analysis. Which approach should the data engineer take?

   • AUse Power BI to import both files and export the combined data as Parquet.
   • BUse Azure Data Factory to create a pipeline that reads the JSON and CSV files, transforms them, and writes the combined output as Parquet.
   • CAsk the database administrator to write a stored procedure to merge the files.
   • DManually convert the CSV files to JSON and then upload them to a SQL database.
   Reveal Solution Discussion Select an answer first