Want to pass your Developing SQL Databases 70-762 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
You have the following stored procedure that is called by other stored procedures and applications:
You need to modify the stored procedure to meet the following requirements:
Always return a value to the caller.
Return 0 if @Status is NULL.
Callers must be able to use @Status as a variable.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Replace NULL values with 0. Add a PRINT statement to return @Status.
B. Add a RETURN statement.
C. Replace NULL values with 0. Add an output parameter to return @Status.
D. Replace NULL values with 0. Add a SELECT statement to return @Status.
E. Add a PRINT statement.
F. Add a SELECT statement to return @Status.
G. Add an output parameter to return @Status.
You have a Microsoft Azure SQL Database. You enable Query Store for the database and configure the store to use the following settings:
SIZE_BASED_CLEANUP_MODE = OFF
STALE_QUERY_THRESHOLD_DAYS = 60
MAX_STORAGE_SIZE_MB = 100
QUERY_CAPTURE_MODE = ALL
You use Azure Query Performance Insight to review queries. You observe that new queries are not displayed after 15 days and that the Query Store is set to read-only mode.
If the Query Store runs low on data space, the store must prioritize queries that run regularly or queries that consume applicant resources.
You must set the Query Store to read_write mode and determine the performance of queries from the past 60 days.
Which three actions should you perform? Each correct step presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Set the value of the CLEANUP_POLICY setting to (STALE_QUERY_THRESHOLD_DAYS = 75)
B. Set the value of the QUERY_CAPTURE_MODE setting to AUTO
C. Increase the value for the MAX_STORAGE_SIZE_MB setting
D. Set the value of the SIZE_BASED_CLEANUP_MODE setting to AUTO
E. In the Azure portal, navigate to Query Performance Insight. Use the Custom tab to select a period of 2 months.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You need to identify the indexes that are not being used so that you can remove them from the database.
Solution: You run the sys.dm_db_index_usage_stats dynamic management view.
Does the solution meet the goal?
A. Yes
B. No