CertKeen

Fabric Analytics Engineer (DP-600) · Free practice question 6 of 12

Warehouse replacements for unsupported types

You are migrating a SQL Server table to a Fabric warehouse. It contains a CustomerName nvarchar(100) column and a CreatedAt datetime column, neither of which is supported for warehouse tables. Which two data types should you use instead? (Select TWO.)

  1. A.varchar(100) for CustomerName
  2. B.ntext for CustomerName
  3. C.smalldatetime for CreatedAt
  4. D.datetime2(6) for CreatedAt
  5. E.datetimeoffset for CreatedAt
Show answer and explanation

Correct answers: A. varchar(100) for CustomerName · D. datetime2(6) for CreatedAt

Why: Fabric warehouse tables don't support nchar and nvarchar, so you use char and varchar, which store Unicode text with a UTF-8 collation. datetime and smalldatetime aren't supported for tables, and datetime2 is the replacement, with up to six digits of fractional-second precision. The varchar length is measured in bytes, so allow extra length if names include non-ASCII characters. ntext and datetimeoffset are also unsupported for persisted tables.

More free Fabric Analytics Engineer (DP-600) questions