🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate13 / 150
Question 13 of 150
You are preparing data in a Fabric warehouse. A staging table named stg_Sales has a column UnitPrice defined as VARCHAR(20) because it was ingested from a CSV file. Some rows contain valid decimal values like '19.99', but a small number contain the literal text 'N/A'. You need to load a clean DECIMAL(10,2) column into the curated fact table and ensure the load does not fail when it encounters 'N/A' values, converting those to NULL instead. Which T-SQL expression should you use in the SELECT that populates the fact table?
Reviewed for accuracy · Report an issueNext question