Free Microsoft DP-800 Exam Questions

You have a SQL database in Microsoft Fabric that contains a table named dbo.Orders, dbo.Orders has a clustered index, contains three years of data, and is partitioned by a column named OrderDate by month. You need to remove all the rows for the oldest month. The solution must minimize the impact on other queries that access the data in dbo.orders. Solution; Identify the partition scheme (or the oldest month, and then run the following Transact-SQL statement. ALTER TABLE dbo.Orders DROP PARTITION SCHEME (partition_scheme_name); Does this meet the goal?

You need to recommend a solution to lesolve the slow dashboard query issue. What should you recommend? 

You have a GitHub Actions workflow that builds and deploys an Azure SQL database. The schema is stored in a GitHub repository as an SDK-style SQL database project. Following a code review, you discover that you need to generate a report that shows whether the production schema has diverged from the model in source control. Which action should you add to the pipeline? 

You have an SDK-style SQL database project stored in a Git repository. The project targets an Azure SQL database. The CI build fails with unresolved reference errors when the project leferences system objects. You need to update the SQL database project to ensure that dotnet build validates successfully by including the correct system objects in the database model for Azure SQL Database. Solution: Add an artifact reference to the Azure SQL Database master.dacpac file.Does this meet the goal?

You have a SQL database in Microsoft Fabric that contains the following functions: • A multi-statement table-valued function (TVF) named sales.mstvf_orderStatus() that returns order status information • A scalar user-defined function (UOF) named dbo.ufn_GetlaxMultiplier(^rax/Wt money, gStateCode char (2)) that returns a numeric multiplier used in tax calculations Reporting queries frequently join Sales.«istvf_OrderStatus() to a table named Sales.SalesOrderHeader and return large result sets. A performance review shows that the queries produce inconsistent execution plans. During a code review, a developer discovers that the following Transact-SQL statement produced an error.