Explanation:
fn_StripCharacter every 15 minutesOption A: Create an index on the avg_f column
Option B: Convert the avg_c column into a calculated column
Option C: Create an index on the sensorid column
Option D: Enable result set caching
Option E: Change the table distribution to replicate
D (Enable result set caching) is the primary optimization because:
Since the question requires two answers and only one option (D) provides actual performance benefits for this specific scenario, the second selection would be based on eliminating clearly incorrect options rather than finding another optimal solution.
Ultimate access to all questions.
No comments yet.
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that receives new data once every 24 hours. You have the following function and query.
Function:
CREATE FUNCTION [dbo].[fn_StripCharacter](@String VARCHAR(8000), @StripCharacter VARCHAR(1))
RETURNS TABLE
AS
RETURN
(
SELECT String = REPLACE(@String, @StripCharacter, '')
);
CREATE FUNCTION [dbo].[fn_StripCharacter](@String VARCHAR(8000), @StripCharacter VARCHAR(1))
RETURNS TABLE
AS
RETURN
(
SELECT String = REPLACE(@String, @StripCharacter, '')
);
Query:
SELECT *
FROM [dbo].[fn_StripCharacter]('123-456-789', '-');
SELECT *
FROM [dbo].[fn_StripCharacter]('123-456-789', '-');
This query is executed once every 15 minutes, and the @parameter value is set to the current date. You need to minimize the time it takes for the query to return results.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A
Create an index on the avg_f column.
B
Convert the avg_c column into a calculated column.
C
Create an index on the sensorid column.
D
Enable result set caching.
E
Change the table distribution to replicate.