You plan to create a data warehouse in Microsoft Azure for development purposes.

The data warehouse must not exceed 10 terabytes (TB) in size. You must minimize costs for the environment.

You need to create the dat

a warehouse.

Which Transact-SQL statement should you run?

A. CREATE DATABASE CloudDataWarehouse (

EDITION = -premium-,

SERVICE_OBJECTIVE= -P1-

)

B. CREATE DATABASE CloudDataWarehouse (

EDITION= -datawarehouse-,

SERVICE_OBJECTIVE= -DW200-

)

C. CREATE DATABASE CloudDataWarehouse (

EDITION= -basic-

SERVICE_OBJECTIVE = -basic-

)

D. CREATE DATABASE CloudDataWarehouse (

EDITION = -standard-,

SERVICE_OBJECTIVE

= -53-

)

Explanation:

EDITION specifies the service tier of the database. For SQL Data Warehouse use datawarehouse.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=sql-server-2017&tabs=

sqldw