Which plan should you recommend?

Correct Answer for the following Question is given below

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 non-technical 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?Create list relationships by using unique and lookup columns – http://office.microsoft.com/en-us/sharepoint-server-help/create-list-relationships-by-using- unique-and-lookup-columns-HA101729901.aspx

Question:

Which plan should you recommend?

Options:

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.

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.

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

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

The Correct Answer for this Question is

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

Explanation

The Question – Which plan should you recommend? has been answered correctly and answers for the question is Use SharePoint 2010 lists and document libraries to store data. Create relationships using lookup fields and relationship joins between the lists and document libraries.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment