How should you complete the Transact-SQL statement?

HOTSPOT

You have a Microsoft SQL server that manages all of your databases.

You must create a database named Marketing Data. The database will initially consume 400 megabytes (MB) of storage and will grow by one percent per year.

The database file must be stored on the Marketing share of the Lon-SVR1 server. The file must not automatically increase in size. Log files must be stored on the L drive of the SQL Server machine in a folder named Logs.

You need to create the MarketingData database.

How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.

NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: \LON-SRV1MarketingMarketingdata.mdf

The database file must be stored on the Marketing share of the Lon-SVR1 server.

Box 2: 500 MB

Initial size is 400 MB, with an annual 1% increase in size.

Box 3: Filegrowth=0

The file must not automatically increase in size.

Box 4: L:LogsMarketingMarketingdata.ldf

Log files must be stored on the L drive of the SQL Server machine in a folder named Logs.

Box 5: Filegrowth = 10%

The log file must be able to grow.

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