70-576 Free Dumps Study Materials
Question 10: 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 m a i n t enance h i s t o ry , 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. 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.
B. 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 Share Point document library and use
event receivers to synchronize data in the lists and libraries.
C. Use SharePoint 2010 lists and document libraries to store data. Create relationships using lookup
fields and relationship joins between the lists and document libraries.
D. Use SharePoint 2010 lists and document libraries to store data. Create a custom workflow to update
information in the lists and document libraries.
Correct Answer: C