You are designing a SharePoint 2010 application that stores information about each
machine in a factory. This information includes an inventory of parts, the machine’s
maintenance history, and a document library of repair manuals for each machine in
Microsoft Word format. The application must: ·Establish links between the factory machine
data, the machine part inventory, the maintenance history, and the repair manuals to allow
the display of additional fields from the other lists. .Enforce relational integrity between the
data to create custom views for various business users. .Allow nontechnical users to update
the individual list data and views, as well as to update the manuals. .Enforce relationships
that allow cascade deletes of items from the machine parts list when items are deleted from
the machine list, but prevent data in the machine parts list from being orphaned. You need
to design a data access plan that meets all these requirements and allows all data to be
managed within the SharePoint 2010 system. Which plan should you recommend?

A.
Use SharePoint 2010 lists and document libraries to store data. Create a custom
workflow to update information in the lists and document libraries

B.
Use SharePoint 2010 lists and document libraries to store data. Create relationships
using lookup fields and relationship joins between the lists and document libraries.

C.
Create tables in Microsoft SQL Server for each set of inventories. Create relationships
with primary and foreign keys linking the tables. Store machine part manuals in a
SharePoint document library and use event receivers to synchronize data in the lists and
libraries

D.
Create tables in Microsoft SQL Server for each set of inventories. Create relationships
with primary and foreign keys linking the tables. Use Business Connectivity Services (BCS)
to connect SharePoint 2010 lists to these tables to manage the data