Online Access Free 070-331 Exam Questions

DRAG DROP
You manage a SharePoint farm in an Active Directory Domain Services (AD DS) forest. All enterprise application databases are hosted on a server that runs SQL Server 2014 Enterprise Edition.
You need to configure the maximum degree of parallelism for SQL Server.
How should you complete the relevant Transact-SQL script?
To answer, drag the appropriate Transact-SQL statement or value to the correct location. Each Transact-SQL statement or value 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.

Correct Answer:

Explanation:

HOTSPOT
A three-tiered SharePoint farm contains two front-end web servers, one application server, and one enterprise database server. The database server is also used by other critical line-of-business applications. You do not have administrative rights on the database server.
The SharePoint content databases are fragmented and are degrading the performance of other databases.
You need to access the correct tools for performing maintenance on the SharePoint content databases.
Which option should you choose? (To answer, select the appropriate option in the answer area.)

Correct Answer:

Explanation:

Note: Resolution: Enable and run the crawl database defragmentation health rule Verify that the user account that is performing this procedure is a member of the Farm Administrators group.
-
On the Monitoring page, in the Health Analyzer section, click Review rule definitions. On the All Rules page, in the Performance section, click Search - One or more
If the rule is not enabled, in the Health Analyzer Rule Definitions dialog, click Edit Item on the ribbon. Ensure that the Enabledcheck box is selected, and then click
In Central Administration, on the home page, click Monitoring. - crawl databases may have fragmented indices. - Save on the ribbon. On the ribbon, click Run Now.
Click Close.
--
--
The rule iterates over all crawl databases in all Search service applications. When it runs, it attempts to perform an online defragmentation first, and then it switches to offline defragmentation where required. In online defragmentation, only the SQL Server leaf pages are defragmented, not the SQL Server locked pages. In offline defragmentation, the locked pages and all the leaf pages are defragmented.

DRAG DROP
You need to provide access to the Corporate Projects site collection to remote internal users.
Which authentication mode and site collection URL should you use? (To answer, drag the appropriate answer choices to the correct location or locations in the answer area. Each answer choice 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.)

Correct Answer:

Explanation:
Box 1: DirectAccess authentication Box 2: Path-based site collections
Note:
*From scenario: Automate the sign-in experience by using the local AD FS 2.0 servers for AD FS single sign-on (SSO).
*The Corporate Projects site collection must be available to internal users who connect from outside of the corporate network and must not require a VPN connection
*DirectAccess authenticates the computer before the user logs on. Typically, computer authentication grants access only to domain controllers and DNS servers. After the user logs on, DirectAccess authenticates the user, and the user can connect to any resources he or she is authorized to access. DirectAccess supports standard user authentication using a computer certificate and user account name and password credentials.
DirectAccess supports standard user authentication using a computer certificate and user account name and password credentials. For greater security, you can implement additional authorization with smart cards. This type of configuration allows users to access Internet resources without their smart cards, but requires a smart card before users can connect to intranet resources. A user must insert a smart card in addition to typing his or her user credentials. Smart card authorization prevents an attacker who acquires a user's password (but not the smart card) from accessing the intranet. Similarly, an attacker who acquires the smart card but does not know the user's password does not have access. When smart cards are required for end-to-end authentication, you must use Active DirectoryDomain Services (AD DS) in Windows Server 2008 R2.
*From scenario: Ensure that a web usage report that contains traffic reports, search reports, and inventory reports can be provided for any site.
*Microsoft SharePoint supports both path-based and host-named site collections. The primary difference between path-based and host-named site collections is that all path-based site collections in a Web application share the same host name (DNS name), and each host-named site collection in a Web application is assigned a unique DNS name.
Path-based site collections Ex: http://www.company.com/sites/cust1 http://www.company.com/sites/cust2 http://www.company.com/sites/cust3
Host-named site collections Ex: http://cust1.company.com http://cust2.company.com

You need to implement Office 365 authentication. What should you do?

• A.Deploy an AD FS proxy for the proseware.com domain.
• B.Add proseware.com as an Office 365 SSO domain and update all user principal names (UPNs) to also use proseware.com.
• C.Create an AD DS domain named proseware.com and join the AD FS servers to the proseware.com domain.
• D.Add a DNS CNAME record for www.proseware.com and point it to www.adatum.com.

Your company has a SharePoint Server 2013 server farm that is integrated with Microsoft SharePoint Online.
Users report that when they connect to SharePoint Online and perform a search, they only see search results from SharePoint Online.
You need to ensure that when the users search from SharePoint Online, the results are displayed from the SharePoint Server 2013 farm and from SharePoint Online.
What should you do?

• A.From SharePoint Online, create a result source and a query rule.
• B.From SharePoint Online, create a content source and a search scope.
• C.From the SharePoint Server 2013 farm, create a content source and a search scope.
• D.From the SharePoint Server 2013 farm, create a result source and a query rule.