
Ultimate access to all questions.
In your Fabric data warehouse, there is a table named Sales.Orders which includes the columns: OrderID, CustomerID, OrderDate, and TotalAmount. You are required to write a T-SQL query to fetch all these columns, while ensuring that any null values are replaced with suitable default values. How would you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
A
Use the COALESCE function for handling null values.
B
Use the ISNULL function for handling null values.
C
Use the LEAST function for determining the smallest value.
D
Use the CASE statement for handling null values.