Exam 70-461 topic 1 question 240 discussion

Actual exam question from Microsoft's 70-461

Question #: 240
Topic #: 1

You administer a Microsoft SQL Server instance that will support several databases.
You need to ensure that the organization serial numbers can be stored in every new database created. You also need to ensure that the serial numbers are six alphanumeric characters and have the same structure across every database.
What should you do?

A. Create a user-defined data type on the master database.
B. Create a user-defined type on the master database.
C. Create a user-defined data type on the model database.
D. Create a user-defined type on the model database.

Show Suggested Answer

Suggested Answer: D 🗳️
A user defined data type in SQL Server is only accessible in a single database, but 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, rules, defaults, etc. will automatically be available.
References:
https://www.mssqltips.com/sqlservertip/1628/sql-server-user-defined-data-types-rules-and-defaults/

by lilupv at Sept. 4, 2020, 7:03 a.m.

Comments

Submit Cancel

MOS

4 years, 5 months ago

it is C . I AGREE WITH YOU

upvoted 1 times

...

lilupv

4 years, 8 months ago

The answer does not correspond to explanation. It is C.

upvoted 1 times

...

Exam 70-461 All Questions

View all questions & answers for the 70-461 exam

Exam 70-461 topic 1 question 240 discussion

Comments

MOS

lilupv

SY0-701