Which data types should you use?

You are a developer for a Microsoft SQL Server 2008 R2 database instance that hosts an application.
You are designing some new tables. You need to choose the most appropriate data types.
Which data types should you use? (To answer, drag the appropriate data type to the correct data in the answer area. Each data type may be used once, more than once, or not at all. Each data may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
1. XML
2. nvarchar(max)
3. varbinary(max) FILESTREAM
4. datetime2
5. timestamp none.gif
DataXML data validated by an XSD
DatetimeInternational text data longer than 5,000 characters
XML data that must be indexed and searched by using XPATH queries
XML data that must be preserved exactly as it was received
MP3 audio files
The date and time a row was last modified
HTML fragments
A.
B.
C.
D.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.