Q1. - (Topic 6)
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. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;
C. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly
D. Sign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only.
Answer: B
Explanation:
Set the previous version databases to be read-only
If you want your original environment to remain available to users in a read-only state, set the databases to read-only before you back them up.
Complete this step for each content database in your environment.
Depending on your organization, you might need a database administrator to complete this step.
Incorrect:
Not A: The content databases, not the server instance, should be set to Read-only.
Note:
* To set content databases to be read-only
1. Verify that you have the following administrative credentials: You must be a member of the db_ownerfixed database role in each database.
2. Open SQL Server Management Studio.
3. Right-click the content database that you want to change to read-only, and then click Properties.
4. Select the Options page, and, in the Other options list, scroll to the State section.
5. In the Database Read-Only row, click the arrow next to False, select True, and then click OK.
6. Repeat for all other content databases.
* A farm is considered to be read-only if any of the following are true:
/All content databases are set to read-only.
/Service application databases are set to read-only.
Q2. - (Topic 6)
You plan to deploy a SharePoint Server 2013 server farm.
The sales department uses Microsoft Office documents to track sales leads.
You need to recommend a solution to ensure that users use the co-authoring functionality in SharePoint Server 2013 to collaborate on Office documents.
What should you include in the recommendation?
A. The App Management Service
B. OneNote Web App
C. Word Automation Services
D. The Work Management Service
Answer: B
Explanation: Co-authoring simplifies collaboration by enabling multiple users to work productively on the same document without intruding on one another’s work or locking out other users. This capability requires no additional server setup and is the default status for documents that are stored in SharePoint 2013 document libraries. Here are some changes in co-authoring for Office 2013.
* Co-authoring is now supported in Visio Professional 2013, Word Web App, and PowerPoint Web App.
* Seeing other editors who join the document to co-author is faster in Word 2013, Excel 2013, PowerPoint 2013, and Visio Professional 2013.
* Updates are faster when multiple users co-author in the same OneNote page.
Incorrect:
Not C: Word Automation Services
Provides unattended, server-side conversion of documents that are supported by Word.
Q3. DRAG DROP - (Topic 6)
You are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections. Three site collections are available only inside the company network. The fourth site collection is available to an external partner company by using forms-based authentication. The external site collection is used to store contracts and purchase orders. Every site collection has its own content database.
Contoso purchases an Office 365 subscription for external partner employees. Contoso plans to move the external site collection to SharePoint Online. You have the following requirements:
Upgrade the external partner site collection to SharePoint Online.
Upgrade the on-premises farm to SharePoint 2013.
Minimize downtime for the upgrade.
Ensure the sites are read-only during the upgrade.
You need to plan the upgrade for the extranet 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:
Q4. DRAG DROP - (Topic 6)
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:
Q5. - (Topic 1)
You need to provision a SharePoint environment for MyTailspin.TailspinToys.com.
What should you do?
A. Create a web application and a site collection using the My Site Host template.
B. Create a web application, a site collection using the My Site Host template, and site collections for each user.
C. Configure the User Profile Synchronization service to perform a full import of AD DS user profiles.
D. Configure the User Profile Synchronization service to set up a My Sites site collection.
Answer: A
Q6. HOTSPOT - (Topic 6)
You have a Windows SharePoint Services 3.0 server farm.
You plan to perform the following tasks:
. Upgrade the Windows SharePoint Services 3.0 farm to Microsoft SharePoint
Foundation 2010.
. Upgrade SharePoint Foundation 2010 to SharePoint Server 2010.
. Upgrade SharePoint Server 2010 to SharePoint Server 2013.
You need to recommend an upgrade method for each task. The solution must use in-place upgrades, whenever possible.
Which method should you recommend for each task? {To answer, select the appropriate upgrade method for each task in the answer area.)
Answer:
Q7. - (Topic 6)
A company has a SharePoint environment that contains multiple site collections.
The company purchases an app.
You need to ensure that the app is available in all site collections.
Which Windows PowerShell cmdlets should you run?
A. Install-SPApp and then Update-SPAppCatalogSettings
B. Import-SPAppPackage and then Install-SPApp
C. Import-SPAppPackage and then Enable-SPAppAutoProvision
D. Enable-SPAppAutoProvision and then Install-SPApp
Answer: B
Q8. - (Topic 6)
You have a SharePoint Server 2013 server farm.
You implement Business Connectivity Services (BCS). You need to ensure that the BCS data is available for search.
What should you configure?
A. A result source
B. A content source
C. A search scope
D. A crawl rule
Answer: B
Explanation: A content source is a set of options that you use to specify what, when, and how to crawl. When a Search service application is created, a content source named "Local SharePoint sites" is automatically created and configured for crawling all SharePoint sites in the local server farm. You can create additional content sources to specify other content to crawl and how the system should crawl that content. After you create a content source, you can edit or delete it at any time.
Q9. DRAG DROP - (Topic 6)
A SharePoint 2010 environment contains the site collections described in the following table.
You plan to migrate the environment to SharePoint 2013. You create a SharePoint 2013 site at the URL http:// testIntranet.contoso.com. You restore the database backups from the 2010 environment to the 2013 environment.
You test the migration plan by migrating the Intranet_Content database to the new site. You need to verify that the test migration succeeds.
Which Windows PowerShell cmdlets should you run? (To answer, drag the appropriate cmdlets to the correct location or locations in the answer area. Each cmdlet 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:
Q10. - (Topic 6)
You plan to deploy a SharePoint Server 2013 server farm.
Your company frequently creates large video files that can be up to 40 GB in size.
You need to recommend a solution to ensure that users can locate the video files from within SharePoint sites.
What should you include in the recommendation?
A. File shares and content sources
B. File shares and shredded storage
C. Remote BLOB Storage (RBS) and a BLOB cache
D. Remote BLOB Storage (RBS) and content sources
Answer: D
Explanation: * RBS is a SQL Server library API set that is incorporated as an add-on feature pack for SQL Server 2008 R2, SQL Server 2008 or SQL Server 2008 R2 Express. The RBS feature enables applications, such as SharePoint 2013, to store BLOBs in a location outside the content databases. Storing the BLOBs externally can reduce how much SQL Server database storage space is required. The metadata for each BLOB is stored in the SQL Server database and the BLOB is stored in the RBS store.
* The BLOB cache also provides features that support serving media files to users. One such feature is support for byte-range requests, which lets users select a later point in the video and immediately begin playback. Another feature is progressive caching, which starts serving the beginning of a large video file while the rest of the file is being cached. Video files are divided and retrieved in smaller sections to reduce the load between the front-end and back-end servers.