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 data 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’ )
