ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 228 discussion

Actual exam question from Microsoft's 70-764
Question #: 228
Topic #: 1
[All 70-764 Questions]

You work as a Developer at ABC.com.
All databases are hosted on Windows Server 2012 servers running SQL Server 2012.
The company has a database named Products.
Tables in the Products database contain data including part numbers, product name, color, type and size.
Users in the Marketing department have created brochures for each product.
The brochures have been created in the XML Paper Specification (XPS) format.
You have been asked to add a table to the Products database to store the product brochures.
The brochures need to be stored in a folder structure.
Company users will also need to access the brochures from Windows applications using UNC paths. How can you meet these requirements?

  • A. By implementing the XMLNAMESPACES feature.
  • B. By implementing the FILEGROUP feature.
  • C. By implementing the FILETABLE feature.
  • D. By implementing the FILESTREAM feature.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by TheSwedishGuy at Feb. 19, 2020, 1:25 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
TheSwedishGuy
5 years, 3 months ago
Filetables use UNC paths to find the files in a specified share.
upvoted 1 times
...
TheSwedishGuy
5 years, 3 months ago
FileTable = you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago