Q1. - (Topic 1)
You need to configure Excel Services.
What should you do?
A. Add a trusted file location to the Tailspin360 site.
B. Add each user as a Viewer.
C. Add each user as a Contributor.
D. Add a trusted data connection library to the Tailspin360 site.
Answer: A
Q2. HOTSPOT - (Topic 6)
You are configuring SharePoint 2013 social features.
You need to ensure that users receive email notifications that relate to their microblogging activities.
Which settings should you configure from the User Profile Service Application? (To answer, select the appropriate link in the answer area.)
Answer:
Q3. - (Topic 6)
An organization is using SharePoint for team collaboration. Each department in the organization has a team site and a site owner who is responsible for site management.
Site owners do not have administrative rights to the web servers.
You need to ensure that site owners can install trusted apps to their own sites.
What should you do?
A. Create a sandbox solution.
B. Grant the site owners the Full Control permission level to the web applications.
C. Configure solution blocking settings.
D. Configure content deployment settings.
E. Create an App Catalog site.
Answer: E
Q4. DRAG DROP - (Topic 6)
You manage a SharePoint farm.
The sales team would like to evaluate the Microsoft SQL Server 2012 Reporting Services
(SSRS) Power View feature.
You need to install Reporting Services for SharePoint to support Power View.
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:
Q5. DRAG DROP - (Topic 6)
You have a custom solution named SalesSolution deployed to the URL http://site.contoso.com/sites/sales.
You need to deploy a new version of the solution without retracting the previous version.
How should you complete the Windows PowerShell cmdlet? (To answer, drag the appropriate terms to the correct location or locations in the answer area. Each term 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. DRAG DROP - (Topic 1)
You need to design the architecture of the farm.
What should you do? (To answer, drag the appropriate terms to the correct location or locations in the answer area. Each term 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:
Q7. HOTSPOT - (Topic 6)
You are managing search results in a SharePoint farm.
You need to configure a query rule that fires for all queries.
In the Search service application, which option should you select? (To answer, select the appropriate option in the answer area.)
Answer:
Q8. DRAG DROP - (Topic 6)
You plan to create two external content types named ECT1 and ECT2. ECT1 will retrieve data from a database hosted on a Microsoft SQL Server server. ECT2 will retrieve data from a database hosted on an Oracle server. ECT1 and ECT2 will be deployed at the server farm-level.
You need to recommend a tool to create the external content types. The solution must minimize development effort.
Which tool should you recommend? (To answer, drag the appropriate tools to the correct external content types. Each tool 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)
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. 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;
B. 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
C. Run the following Windows PowerShell cmdlets for each web application in the SharePoint 2010 farm you plan to upgrade. $db = Get-SPContentDatabase<web application name>Set-SPContentDatabase$db -Status Offline
D. 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";
Answer: A
Q10. DRAG DROP - (Topic 5)
You need to make the required resources available for users in the accounting department. 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: