Microsoft 070-667 Value Pack (Frequently Bought Together)

The server farm contains several Microsoft InfoPath forms.
You need to ensure that all the InfoPath forms can use embedded SQL authentication.
What should you do from Central Administration?

• A. Modify the InfoPath Forms Services settings.
• B. Create a new target Application in the Secure Store Service.
• C. Create a new data connection file.
• D. Modify the InfoPath Forms Services Web service proxy settings.

DRAG DROP
You configure a SharePoint Server 2010 Service Pack 1 (SP1) farm that includes an http://www.contoso.com site collection. The site collection is based on a Team Site.
You need to ensure that the web content management functionality is available for the site collection.
What should you do? (To answer, drag the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Enable The User Profile Synchronization Service

• A. Go to Central Administration, in the System Settings click on Manage services on server. On Services on Server page, in the Server box, select the synchronization server. Find the row whose Services column value is User Profile Service. In the value in the Status column is Stopped, click Start in the Action column.
• B. Go to Central Administrator, click on System Settings. In Farm Management section, click Manage Farm Users, Click Enable Profile. Click Ok to finish
• C. Use PowerShell Cmdlet Install - SPUser - Identity MySharePointUser - LiteralPath -GacDeployment
• D. Go to Central Administrator, in System Settings click Manage Services on server. On Services, in the server box, select the synchronization server. Find the row whose Service column value is User Profile Synchronization Service. If the value in the Status column is Stopped, click Start in the Actions column. On the User Profile Synchronization Service page, in the Select the User Profile Application section, select the User Profile service application. In the Service Account Name and Password section, enter the passwork for the farm account and then confirm it again. Click Ok to finish

You have a site hosted on Microsoft SharePoint Online.
You have a solution that is packaged as a .wsp file. The .wsp file contains 15 Web Parts.
You need to ensure that the Web Parts are available to users.
What should you do?

• A. Upload the .wsp file to the Web Part Gallery,
• B. Upload the .wsp file to the Solution Gallery.
• C. Run the Add-SPUserSolution cmdlet.
• D. Run the Install-SPWebPartPack cmdlet.

Steps to enable Secure Store Service for Excel Using Unattended Accounts

• A. In SQL server expand Security, right click logins, and then click new login. In the login name box type the name of the active directory account. Next in Select a Page click user mapping, slec the map then under Database role membership selck db_datareader. Click Ok to finish
• B. In Central Administrator select Application Management, click Manage service applications. On Manage Services Application page, click Global settings. On the Excel services settings page in External Data section, thpe the target Application ID in the Application ID box. Click Ok to finish
• C. To configure you first Configure a data access account then Configure a secure store target application for the unattended service account then Configure Excel Services Global Setting and then Configure a workbook to use the unattended service account.
• D. In data-connected Excel workbook, on the data tab, click connections. Next, go to Workbook connections dialog box, select the data connection that you want to update, and then click properties. On the connections properties dialog box, on the definitions tab, click authentication settings. On the Excel services Authentication settings dialog box, select the Non lption and then click Ok to finish