LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

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.

Exam-Like
Quiz related visual




Powered ByGPT-5