Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. - (Topic 12)
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
C. Add SPShellAdmin -UserName LITWARE\svcExcelService -database WSS_Content_Portal_Content_Database
D. $wa = Get-SPWebApplication https://portal.litware.com and
$wa.GrantToProcessIdentity("LITWARE \svcExcelService")
Answer: D
Q2. - (Topic 3)
You need to ensure that all required sites can use microblogging features for collaboration.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Enable the Site Feeds feature on each My Site.
B. Enable the Following Content feature on each team site.
C. Enable self-service site creation on the web application that contains the team sites.
D. Enable the Site Feeds feature on each team site.
Answer: B,D
Explanation: Note:
When an administrator upgrades team sites from SharePoint Server 2010, they must activate site feeds on the upgraded team site by first enabling the Following Content feature on the team site, and then enabling the Site Feeds feature on the team site.
Q3. - (Topic 12)
A SharePoint environment contains an instance of Microsoft SQL Server 2008 R2.
You plan to migrate data from the existing database to a new instance of SQL Server 2012. You need to configure SQL Server to support the migration. You must accomplish this goal
without requiring any SharePoint application configuration changes. What should you do?
A. On the SQL Server, configure a named instance.
B. On all servers in the farm, configure a SQL Server alias.
C. On all servers in the farm, configure SQL Server database mirroring.
D. Create a single-node SQL Server cluster.
Answer: B
Q4. - (Topic 6)
You have a SharePoint Server 2013 server farm.
You need to ensure that users can use the Newsfeed app on their My Site to aggregate user actions and system activities.
Which type of cache should you configure?
A. An output cache
B. An object cache
C. A BLOB cache
D. A distributed cache
Answer: D
Explanation: SharePoint 2013, makes use of distributed cache to cache newsfeeds, microblogging, conversations, security trimming, OneNote client access, and even keeps the FedAuth cookie for claims based authentication on the server side, so it’s more secure, load balancer friendly, and works with webkit-based browsers that like to chop off your cookies at 64kb.
Q5. DRAG DROP - (Topic 12)
A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The company uses a third-party application to process payroll data and view payroll reports. The third-party application uses SQL Authentication. Payroll administrators currently use custom credentials to sign in to the payroll application.
You have the following requirements:
✑ Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports from within SharePoint.
✑ Payroll administrators must not be required to enter credentials when accessing
payroll data.
✑ The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
Q6. - (Topic 12)
You have a SharePoint Server 2013 server farm named Farm1. Farm1 contains the following service applications:
✑ Excel Services Application
✑ Search Service Application
✑ Managed Metadata Service
✑ User Profile Service Application
You plan to deploy a new SharePoint Server 2013 server farm named Farm2. Farm2 must use the same service applications as Farm1.
You plan to use as many services from Farm1 in Farm2 as possible. You need to identify which service application must be created in Farm2. Which service application should you identify?
A. Search Service Application
B. User Profile Service Application
C. Managed Metadata Service
D. Excel Services Application
Answer: C
Explanation: Configuration
If you want to create a new Service Application connect to the Central Administration and click on Manage Service Applications
Select Managed Metadata Service
SharePoint will prompt you a little wizard and you have to fill some information to create your service.
Please provide a: Name
Database Name
Application Pool Configurable Account
Incorrect:
Not B: The User Profile service application stores information about users in a central location. Social computing features use this information to enable productive interactions so that users can collaborate efficiently. In order to provision My Sites, enable social computing features such as social tagging and newsfeeds, and create and distribute profiles across multiple sites and farms, you must enable the User Profile service application.
Not D: Excel Services in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server. The published workbooks can be managed and secured according to your organizational needs and shared among SharePoint Server 2013 users, who can render the workbooks in a browser.
Q7. - (Topic 7)
You need to ensure that the developers have the necessary permissions to meet the BCS model requirements.
What should you do?
A. Grant Edit permissions to the developers by using the Set Object Permissions option
B. Grant Execute permissions to the developers by using the Set Object Permissions option
C. Grant Edit permissions to the developers by using the Set Metadata Store Permissions option
D. Grant Execute permissions to the developers by using the Set Metadata Store Permissions option
Answer: C
Q8. DRAG DROP - (Topic 11)
You need to configure the database servers for high availability.
What should you do? (To answer, drag the appropriate elements to the correct target or targets in the answer area. Each element may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
Answer:
Q9. - (Topic 6)
Your network contains an Active Directory forest The forest contains a single domain named adatum.com.
The network contains a SharePoint Server 2013 server farm. The farm contains a single web application named Web1. Users connect to Web1 by using the URL http://webl.adatum.com.
You need to configure the People Picker control to display only users who are members of organizational units (OUs) named Managers and Contractors.
What should you do?
A. Modify the User Information List of the site collection.
B. Set the Peoplepicker-setsiteuseraccountdirectorypath property of the site collection.
C. Set the Peoplepicker-searchadforests property of the site collection.
D. Modify the User Policy of Web1.
Answer: B
Explanation: * Operation name: Setsiteuseraccountdirectorypath
Sets the site user account directory path to a specific organizational unit (OU) in the same domain when the url andpathparameters are specified.
* Example
To set a list of users to a specific OU (for example, Sales) in the Contoso Corp domain, use the following syntax:
stsadm -o setsiteuseraccountdirectorypath -path "CN=Sales,DC=ContosoCorp,DC=local"
–url http://server_name