Microsoft
70-473 · Question #77
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…
The correct answer is B. CREATE DATABASE CloudDataWarehouse (. EDITION specifies the service tier of the database. For SQL Data Warehouse use 'datawarehouse'. sql?view=sql-server-2017&tabs=sqldw
Design and implement data storage
Question
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?
Options
- ACREATE DATABASE CloudDataWarehouse (
- BCREATE DATABASE CloudDataWarehouse (
- CCREATE DATABASE CloudDataWarehouse (
- DCREATE DATABASE CloudDataWarehouse (
How the community answered
(46 responses)- A7% (3)
- B72% (33)
- C17% (8)
- D4% (2)
Explanation
EDITION specifies the service tier of the database. For SQL Data Warehouse use 'datawarehouse'. sql?view=sql-server-2017&tabs=sqldw
Topics
#Azure Synapse Analytics#SQL Data Warehouse#Cost optimization#Database provisioning
Community Discussion
No community discussion yet for this question.