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

Questions 16–20

1. 16application · medium

   A data engineering team is designing a data lake for a healthcare organization. The data will include structured relational data, semi-structured JSON logs, and unstructured images. The team needs a storage solution that supports all these formats, provides hierarchical namespace for folder organization, and integrates with Azure Data Factory for pipelines. Which storage solution should they choose?

   • AAzure Data Lake Storage Gen2
   • BAzure Cosmos DB
   • CAzure SQL Database
   • DAzure Table Storage
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A database administrator notices that a critical reporting query is running slowly. The query joins two large tables and filters on a column that has a nonclustered index. The DBA suspects the index is not being used. Which action should the DBA take first to confirm the issue?

   • ADisable the query optimizer's automatic tuning.
   • BRebuild all indexes on both tables.
   • CIncrease the database's memory allocation.
   • DCapture and review the actual execution plan for the query.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A company is deploying a new SQL Server database in Azure. The database must be accessible only to the finance team, and the company requires automated backups with a 35-day retention period. Which combination of tasks should be assigned to the database administrator?

   • ADesign the data model and create the tables; then grant the finance team read access to the tables.
   • BCreate visualizations of finance data and publish them to a Power BI workspace for the finance team.
   • CBuild a pipeline to copy finance data into a data lake; then schedule a daily export to a CSV file.
   • DConfigure the firewall rules and create logins for finance users; set up automated backups with the required retention.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   How do data analysts generate business insights from data?

   • ABy interpreting patterns and trends to make recommendations
   • BBy writing application code
   • CBy installing database software
   • DBy managing network security
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A financial services company runs a mission-critical SQL Server database on an Azure VM. The DBA must ensure that the database can be recovered with minimal data loss in case of a regional outage, while also keeping costs low. Which backup strategy should the DBA implement?

   • AUse Azure Site Recovery to replicate the entire VM to another region.
   • BConfigure geo-redundant backups with a short recovery point objective (RPO) using Azure Backup.
   • CPerform daily full backups stored only in the same region as the VM.
   • DDisable backups and rely on the VM's managed disks for redundancy.
   Reveal Solution Discussion Select an answer first