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

Questions 36–40

1. 36expert · hard

   A data engineering team is designing a data storage solution for a multi-tenant SaaS application. Each tenant's data must be isolated and the solution must support both relational queries and semi-structured JSON documents. The team also needs to ensure that the solution can scale horizontally to handle varying tenant loads. Which Azure data store should they choose?

   • AAzure SQL Database with elastic pools
   • BAzure Cosmos DB
   • CAzure Data Lake Storage Gen2
   • DAzure Table Storage
   Reveal Solution Discussion Select an answer first
2. 37application · medium

   A database administrator notices that a frequently executed query in an Azure SQL Database is running slowly. The query joins two large tables and filters on a column that is not indexed. The DBA must improve query performance without changing the application code. What should the DBA do first?

   • AEnable automatic tuning to force a plan that uses a different join order.
   • BIncrease the service tier of the database to provide more DTUs or vCores.
   • CCreate an index on the filter column used in the WHERE clause.
   • DRewrite the query to use a different join type.
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   What does the recovery process in database administration involve?

   • AReindexing all tables to improve performance
   • BRestoring data from backups to return the database to a consistent state
   • CDeleting old records to free up space
   • DChanging the database administrator password
   Reveal Solution Discussion Select an answer first
5. 39expert · hard

   A healthcare organization is migrating its patient records database to Azure SQL Database. Compliance requires that only authorized clinical staff can access the data, and that all access is audited. The DBA must also ensure the database can be restored to a point in time within the last 72 hours. Which combination of actions should the DBA take?

   • ACreate a data pipeline to copy patient data to a data lake for analytics.
   • BGrant all users in the organization db_owner role and rely on the default 7-day backup retention.
   • CEnable Azure AD authentication, create database roles for clinical staff, and configure point-in-time restore with a 72-hour retention.
   • DConfigure a private endpoint and disable public network access, but skip backup configuration.
   Reveal Solution Discussion Select an answer first
6. 40application · medium

   A database administrator needs to restore a database to a specific point in time from two days ago. The database is configured with automated backups and point-in-time restore. What is the first step the administrator should take?

   • ADelete the current database to avoid conflicts.
   • BStop the application to prevent data changes during the restore.
   • CTake a manual full backup before restoring.
   • DRestore the database to the desired point in time using the Azure portal or T-SQL.
   Reveal Solution Discussion Select an answer first