Q1. - (Topic 6)
You have a SharePoint Server 2013 server farm.
You need to view the errors generated by a Web Part. What should you use?
A. The administrative reports
B. The SharePoint trace logs
C. The site collection health checks
D. The SharePoint Health Analyzer
Answer: B
Q2. HOTSPOT - (Topic 6)
A SharePoint environment was set up by using an automated installation script. Corporate policies prevent the use of wizards for installing and configuring server environments.
You plan to provide navigation based on term sets. You need to ensure that you can create the term sets.
Which service should you configure? (To answer, select the appropriate service in the answer area.)
Answer:
Q3. - (Topic 12)
A company has an Active Directory Domain Services domain that contains a SharePoint farm.
The farm contains a site collection that displays data from an employee information database.
You define a domain user account named HRUsers and configure the account to have read-only permissions to the database.
You have the following data access requirements for the employee information database:
✑ Members of the Human Resources department must be able to view data by using SharePoint, without entering database credentials.
✑ No other SharePoint users should be able to view the employee data.
You need to meet the requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Enable the Reports and Data Search Support site collection feature.
B. Create an external list that displays data from the employee information database.
C. In the Secure Store service application, define a target application by using a group mapping.
D. Enable site collection reporting.
E. In the Secure Store service application, define a target application by using an individual mapping.
Answer: A,C
Explanation: C (not E) The Secure Store Service is designed to create a background mapping between a group of users in SharePoint, and a single user known to the external data system.
Q4. - (Topic 6)
You are managing SharePoint Online site collections.
You need to assign the minimum permission level necessary to create subsites. Which permission level should you assign?
A. Approve
B. Design
C. Manage Hierarchy
D. Contribute
Answer: C
Q5. - (Topic 8)
You need to meet the security requirement for site collection upgrades.
Which two Windows PowerShell cmdlets should you perform? (Each correct answer presents part of the solution. Choose two.)
A. $reports.AllowSelfServiceUpgrade = false
B. $reports = Get-SPSite "http://reports.wideworldimporters.com"
C. $reports.AllowSelfServiceUpgrade
D. $reports = Get-SPWebApplication "http://reports.wideworldimporters.com"
E. Sreports.AllowSelfServiceUpgrade = true
Answer: A,B
Explanation: * At the Windows PowerShell command prompt, type the following command to view the self-service upgrade setting for a site collection:
$site=Get-SPSite<URL>
$site.AllowSelfServiceUpgrade=<Value> Where:
<URL> is URL for the site collection that you want to affect.
<Value> is either 'true' to allow site collection administrators to upgrade the site, or 'false' to not show them the notification and not allow them to upgrade.
* Get-SPSite
Returns all site collections that match the specified criteria.
Note:
* From scenario:
/ A site collection named Report Center has been created at http:// reports.wideworldimporters.com.
/ Site Collection administrators must not have the ability to upgrade site collections.
/ Site Collection upgrade jobs must be throttled to a maximum of five site collections at a time.
Incorrect:
D: Get-SPWebApplication
Returns all Web applications that match the given criteria.
The Get-SPWebApplicationcmdlet returns all Web applications that match the scope given by the Identity parameter. The Identity can be the name of the name, URL, or GUID of the Web application. If no Identity is specified, all Web applications are returned.
The Central Administration Web application is only returned if its exact identity is provided or the IncludeCentralAdministration flag is provided.
Reference: Manage site collection upgrades to SharePoint 2013
Q6. HOTSPOT - (Topic 6)
A company has a SharePoint farm. The environment contains a server-based virus scanner.
You need to configure the SharePoint farm to clean infected documents when users save changes to documents on the server.
How should you configure the antivirus settings? (To answer, select the appropriate check boxes in the answer area.)
Answer:
Q7. DRAG DROP - (Topic 12)
You are a SharePoint developer at Contoso, Ltd. The Contoso finance department is developing a reporting application that displays financial information from an internal application on the SharePoint Business Intelligence (BI) site.
You must configure a single server SharePoint environment to support Reporting Services. You must validate that the installation works correctly.
You need to build and test the environment.
Which five 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:
Q8. - (Topic 6)
A company has two SharePoint 2007 site collections that each store 200,000 unique documents. The average size of each document is 250 KB. There are two non-current versions for each document.
There are approximately 600,000 list items in addition to the documents. The company plans to upgrade the farm to SharePoint 2013.
The new farm will use two SQL Server instances that are configured as an AlwaysOn availability group. You use the following formula to estimate the size of the content database:
Database Size = ((D x V) x S) + (10 KB x (L + (V x D)))
You need to configure the storage for the content databases.
What is the minimum amount of storage space that you must allocate?
A. 101GB
B. 110 GB
C. 220 GB
D. 405 GB
E. 440 GB
Answer: B
Explanation: Using the formula we make the following calculation (see note below for details):
((200000 x 2) x 250)+ (10 x 1024 x (600000 + (2 x 200000))) which calculates to
103400000000 bytes, which is 103.4 GB. We would need 110 GB.
Note: Formula to estimate content database storage
1. Use the following formula to estimate the size of your content databases: Database size = ((D × V) × S) + (10 KB × (L + (V × D)))
2. Calculate the expected number of documents. This value is known as D in the formula.
3. Estimate the average size of the documents that you'll be storing. This value is known as S in the formula.
4. Estimate the number of list items in the environment. This value is known as L in the formula.
List items are more difficult to estimate than documents. We generally use an estimate of three times the number of documents (D), but this will vary based on how you expect to use your sites.
5. Determine the approximate number of versions. Estimate the average number of versions any document in a library will have. This value will usually be much lower than the maximum allowed number of versions. This value is known as V in the formula.
Reference: Storage and SQL Server capacity planning and configuration (SharePoint Server 2013)
https://technet.microsoft.com/en-us/library/cc298801.aspx
Q9. HOTSPOT - (Topic 6)
A SharePoint environment was set up by using an automated installation script. Corporate policies prevent the use of wizards for installing and configuring server environments.
You plan to provide information from an external business system as metadata values
within the environment. Users are not permitted to access this business system directly and the data cannot be exported from the external business system into SharePoint.
You need to ensure that users can access the metadata provided by the external system. Which service should you configure? (To answer, select the appropriate service in the
answer area.)
Answer:
Q10. - (Topic 6)
You are managing a site collection in a SharePoint farm.
You need to configure the minimum level of permissions necessary for users to manage lists in the site collection.
What permission level should you configure?
A. Edit
B. Contribute
C. Read
D. Limited Access
Answer: A
Q11. DRAG DROP - (Topic 6)
You have a SharePoint Server 2013 server farm that contains a single server. The farm has a User Profile Service Application named App1.
You need to configure delegated administration for the farm. The solution must meet the following requirements:
✑ A user named User1 must be able to manage audiences for App1.
✑ A user named User2 must be able to create web applications.
✑ The number of assigned permissions must be minimized.
To which group should you assign each user? (To answer, drag the appropriate groups to the correct users. Each group 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:
Q12. - (Topic 12)
You are moving a customized SharePoint site collection to a new farm. You attach and mount the source content database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
A. Install all custom applications in the destination farm.
B. Copy all custom master pages from the source site collection to the Style Library in the destination site collection.
C. Copy all SharePoint groups and users from the source farm to the destination farm.
D. Copy all custom master pages from the source site collection to the master page gallery in the destination site collection.
Answer: A
Q13. - (Topic 6)
You are managing a SharePoint farm in an Active Directory Domain Services (AD DS) forest.
The forest contains two domains named americas.contoso.com and europe.contoso.com. A single SharePoint farm is located in the americas.contoso.com domain and uses Kerberos authentication.
Users in the europe.contoso.com domain cannot access the Excel Services application in the americas.contoso.com domain when using an external data source.
You need to ensure that users in the europe.contoso.com domain can use the Excel Services application with external data sources.
What should you do?
A. Deploy a SharePoint farm in the europe.contoso.com domain.
B. Configure Kerberos constrained delegation.
C. Configure basic Kerberos delegation.
D. Configure anonymous access in the SharePoint farm.
Answer: A
Q14. DRAG DROP - (Topic 6)
You have a SharePoint Server 2013 server farm. The farm has four front-end Web servers.
You have a master page named Contoso.master. The master page contains an image file that is 50 KB.
You need to recommend a solution to cache content. The solution must meet the following requirements:
✑ The image must be stored physically on each front-end Web server.
✑ Authentication information must be cached and replicated on all of the font-end Web servers.
✑ The pages generated by using Contoso.master and all of the page layouts must be stored in the memory of each front-end Web server.
Which caching mechanism should you recommend for each requirement? (To answer, drag the appropriate caching mechanisms to the correct requirements. Each caching mechanism 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:
Q15. - (Topic 11)
You need to configure the required level of access to the SharePoint 2010 farm prior to the migration.
What should you do?
A. In the corporate farm, run the ALTER DATABASE Transact-SQL statement.
B. In the corporate farm, run the CONFIG DATABASE Transact-SQL statement.
C. In the product support farm, run the CONFIG DATABASE Transact-SQL statement.
D. In the product support farm, run the ALTER DATABASE Transact-SQL statement.
Answer: A