You need to configure the BCS model to access data.
What should you do?

• A. Create an external content type and choose the Connect with user's identity option.
• B. Create an external content type and choose the Connect with impersonated custom identity option. Enter the target application friendly name of the Secure Store target application.
• C. Create an external content type and enter the target application friendly name in the Secure Store Application ID
  field.
• D. Create an external content type and enter the target application ID in the Secure Store Application ID field.

You are implementing a claims-based authentication solution for a SharePoint farm in an Active Directory Domain
Services domain. You install and configure Active Directory Federation Services (AD FS).
You need to ensure that all web applications in the farm support SAML-based claims authentication.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A. Configure web applications to use forms-based authentication and AD FS as the trusted identity provider.
• B. Configure AD FS with the web application as a relying party.
• C. Configure SharePoint to trust AD FS as an identity provider.
• D. Configure web applications to use classic mode authentication and AD FS as the trusted identity provider.
• E. Configure web applications to use claims-based authentication and AD FS as the trusted identity provider

HOTSPOT
You are a SharePoint architect for Contoso, Ltd. The environment has the following servers:

You must support a streamlined topology.
You need to design the distribution of services and other components in the farm.
Use the drop-down menus to select the answer choice that answers each question.

You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging Service (ULS) log
contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database "WSS_Content_Portal_Content_Database" requested by
the login. The login failed. Login failed for user 'LITWARE\svcExcelService'.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can
open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?

• A. $sa = Get-SPServiceApplication | where {$_.TypeName -eq "Excel Services Application Web Service Application"}
  and $sa.GrantContentDatabasePermissions("WSS_Content_Portal_Content_Database")
• B. Add SPShellAdmin -UserName LITWARE\svcExcelService -database WSS_Content_Portal_Content_Database
• C. Add SPShellAdmin -UserName LITWARE\svcExcelService
• D. $wa Get-SPWebApplication https://portal.litware.com and $wa.GrantToProcessIdentity("LITWARE =
  \svcExcelService")

You are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections.
Each site collection has its own content database. Contoso is upgrading the SharePoint 2010 farm to SharePoint 2013.
You create a SharePoint 2013 test farm to test the upgrade process.
The SharePoint migration team reports the content database upgrade failed with the following errors:
ERROR Database [ContentDatabase] contains a site (Id = [identifier], url = [http://sitecolIectiona]) that is not found in
the site map.
Feature upgrade incomplete for Feature 'ContosoCustomSite' (Id: 'Feature GUID') in site 'http://sitecollectionb'.
Exception: A duplicate content type name "Customer" was found.
ERROR Found a missing feature Id = [Feature Identifier]
You need to resolve the issues.
Which three actions should you perform? Each correct answer presents part of the solution.

• A. Extract the solution packages from the SharePoint 2010 farm by using the Get-SPSolution Windows PowerShell
  cmdlet and install to the SharePoint 2013 farm. Run the Test-SPContentDatabase Windows PowerShell cmdlet to
  confirm if the upgrade errors are fixed.
• B. Use the SharePoint Designer to delete the Customer content type from the site collection named
  http://sitecollectionb, and then restart the upgrade process.
• C. In the SharePoint 2010 farm, remove orphan objects from the content database and restart the upgrade process.
• D. Delete the site with the site definition Id = [identifier].
• E. Open the site collection named http://sitecolIectionb from the SharePoint 2010 farm and rename the Customer
  content type and then restart the upgrade process.