Ultimate access to all questions.
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, '')
);
Query:
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.