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 F

ILESTREAM feature.

You work as a Developer at ABC.com.

All databases are hosted on Windows Server 2012 servers running SQL Server 2012.

You are developing a custom CRM application named CorpCRM.

The application will store

usernames and passwords in a SQL Server 2012 database named CorpCRMDB1.

You need to ensure the usernames and passwords are secure.

Which of the following would be most suitable password storage solution?

A. One-way encryption

B. Reversible encryption

C.

Encrypting File System (EFS)

D. Secure Sockets Layer (SSL)