Microsoft Exam 70-461 Topic 4 Question 2 Discussion

Actual exam question for Microsoft's 70-461 exam

Question #: 2
Topic #: 4

[All 70-461 Questions]

You administer a Microsoft SQL Server instance that will support several databases.

You need to ensure that every new database created has a data type named postalcode that contains the

same attributes.

What should you do?

ACreate a user-defined type on the model database.

BCreate a user-defined type on the master database.

CCreate a user-defined data type on the master database.

DCreate a user-defined data type on the model database.

Show Suggested Answer

Suggested Answer: D

One option is to create SQL Server user defined data types.

One trick with new databases is to create the objects in the model database, so as new databases are created the user defined data types will automatically be available.

References: https://www.mssqltips.com/sqlservertip/1628/sql-server-user-defined-data-types-rules-and-defaults/

by Adell at May 04, 2022, 09:48 PM

Limited Time Offer

25%

Off

Get Premium 70-461 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!