Q1. - (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.
Q2. DRAG DROP - (Topic 12)
You plan to deploy SharePoint Server 2013 to your enterprise organization's multi-farm configuration.
A dedicated enterprise services farm will be created to host shared service applications. Two collaboration farms will be created to host collaboration sites.
All users must be able to perform the following tasks:
✑ Aggregate tasks from different site collections.
✑ Automatically translate pages to different languages.
✑ Classify documents by using an enterprise taxonomy.
✑ View Microsoft Excel files rendered in the web browser of the users.
You need to identify which service applications to deploy to each farm.
What should you identify? (To answer, drag the appropriate service applications to the correct farms. Each service application 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:
Q3. DRAG DROP - (Topic 12)
You administer a SharePoint 2013 farm for Contoso, Ltd.
Company policy requires that minimal permissions are granted to users to perform their tasks.
You need to add User1 as Full Control on the User Profile Service Application.
How should you complete the relevant Windows PowerShell commands? To answer, select the appropriate Windows PowerShell segment from each list in the answer area.
Answer:
Q4. - (Topic 6)
You are the term store manager of a SharePoint environment.
You need to make term sets available across the entire farm. You must ensure that users can reuse terms but not edit terms.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Prohibit the use of keywords other than those in a specific term set.
B. Create a global term set.
C. Enable term pinning.
D. Prohibit grid editing in the Datasheet view.
E. Create a local term set.
Answer: A,B
Explanation: Note:
Anyone can add a new term to an open term set. Only people who were identified as contributors to a term set group can add terms to a closed term set in the group. For example, a term set that represents cost centers would probably be closed. A term set that represents contributors to a charity might be open.
On global term set see step 8) below.
Make a term set available to other site collections
After you create a term set on the authoring site collection, you have to make it available to publishing site collections. You can make a term set available to all site collections or to specific site collections.
To make a term set available to all site collections:
✑ Verify that the user account that performs this procedure is a member of the Owners SharePoint group on the authoring site that contains the catalog.
✑ On the authoring site, on the Settings menu, click Site Settings.
✑ On the Site Settings page, in the Site Administration section, click Term store management. If the user that performs this procedure is already a member of the Term Store Administrators group, you can skip to step 7.
✑ In the Term Store Management Tool, verify that Managed Metadata Service is selected.
✑ In the Term Store Administrator section, type one or more user names.
✑ Click Save.
✑ Right-click Managed Metadata Service, and then select New Group.
✑ Type the name of the global term set that you want to create, and then press Enter.
✑ Refresh the page.
✑ Right-click the term set that you want to make available to all site collections, and then click Move Term Set.
✑ In the Term Set Move dialog box, click the global term set that you want to move the term set to, and then click OK.
✑ Refresh the page.
Q5. DRAG DROP - (Topic 12)
You plan to deploy the following elements to a SharePoint Server 2013 server farm:
✑ A farm solution
✑ A sandbox solution
✑ A SharePoint hosted app
You need to identify where to deploy each element.
What should you identify? (To answer, drag the appropriate locations to the correct elements. Each location 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:
Q6. - (Topic 12)
A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm.
You are upgrading the farm to SharePoint 2013.
You need to ensure that users can access the unmodified farm contents during the upgrade process.
What should you do?
A. In SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade. Set the Instance Read-Only value to True.
B. In SQL Server Management Studio, locate the content databases and service application databases you plan to upgrade. Set the Database Read-Only value to True.
C. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. EXEC sp_dboption<database name>, "read only", "True";
D. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urlsite collection name> -lock readonly
Answer: B
Q7. - (Topic 12)
You have a SharePoint Server 2013 server farm.
You purchase an app for SharePoint from the Office Store. You plan to deploy the app to the farm.
You need to recommend which changes must be made to the network infrastructure before you can deploy the app.
What should you recommend?
A. Add a host header in Internet Information Services (IIS).
B. Modify the Hosts file on the front-end Web servers.
C. Modify the Web.config file on the front-end Web servers.
D. Add an alias (CNAME) record in DNS.
Answer: D
Explanation: Before you use apps for SharePoint in your environment, you have to configure your environment to support them. If you don’t configure your environment, site owners who try to install and use apps for SharePoint receive error messages. For all apps for SharePoint, you must set up a Domain Name Services (DNS) domain name to provide a host name for the installed apps.
By using a separate domain name, apps for SharePoint are separated from SharePoint sites to prevent unauthorized access to user data and to reduce the possibility of cross-site scripting attacks. The use of separate URLs for apps for SharePoint and SharePoint sites is called app isolation. You also need a DNS record so that the domain name can get correctly resolved. You can create one of two of the following types of DNS records for app for SharePoint URLs:
* A wildcard Canonical Name (CNAME) record that points to the host domain assigned to the SharePoint farm.
* A wildcard A record that points to the IP address for the SharePoint farm.
Q8. DRAG DROP - (Topic 7)
You need to configure authentication for the Tailspin360.TailspinToys.com site.
Which three 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:
Q9. - (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. Copy all search indexes from the source farm to the destination farm.
B. Configure alternate access mappings on the source server.
C. Copy all custom master pages from the source site collection to the Style Library in the destination site collection.
D. Copy all custom site definitions from the file system of the source farm to the destination farm.
Answer: D
Explanation: Note:
* SharePoint Server 2013 customers can create their own site definitions that customize and extend standard SharePoint site templates.
* To create a custom site definition with one or more custom site definition configurations
* on front-end servers, you must create a copy of an existing site definition directory.
* For backup/restore and migration operations, you must restore your site to a server that has the same front-end customizations as the server from which you backed up or migrated.
Reference: Guidelines for Using Custom Site Definitions, Configurations, and Templates
Q10. - (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