Q1. - (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
Q2. - (Topic 12)
You are configuring a SharePoint farm.
You have the following requirements:
✑ Implement an enterprise resource pool.
✑ Enable tasks to be assigned to users.
✑ Implement a resource breakdown structure.
You need to implement a solution that meets the requirements. What should you do?
A. Import a Microsoft Excel spreadsheet as a custom list.
B. Provision a Microsoft Project web app.
C. Create a SharePoint task list.
D. Create a collaboration portal.
Answer: B
Q3. - (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 Internet Information Services (IIS) logs
B. the audit logs for the site collection
C. the site collection health checks
D. the SharePoint trace logs
Answer: D
Q4. - (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 custom master pages from the source site collection to the master page gallery in the destination site collection.
B. Copy all custom site definitions from the file system of the source farm to the destination farm.
C. Copy all permission levels from the source farm to the destination farm.
D. Copy all search indexes from the source farm to the destination farm.
Answer: B
Q5. DRAG DROP - (Topic 6)
Contoso, Ltd. Recently merged with Fabrikam, Inc. Each company has an Active Directory Domain Services (AD RS) domain. You are managing the SharePoint environment in each domain.
You need to enable users in the Fabrikam.com domain to access the Contoso SharePoint farm but prevent users in the Contoso.com domain from accessing resources in the Fabrikam SharePoint farm event if they have been explicitly granted access to a site.
Answer:
Q6. DRAG DROP - (Topic 6)
You are managing a SharePoint search topology.
You need to index custom entity extractor types (tokenized content) in unstructured documents.
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:
Q7. - (Topic 12)
You have a ShafePoint Server 2013 server farm that has Excel Web Services deployed.
A user has a Microsoft Excel spreadsheet that uses a dynamic-link library (DLL) to perform custom calculations.
The user plans to upload the spreadsheet to the farm.
You need to ensure that when the spreadsheet is rendered by Excel Web Services, the custom calculations are performed.
What should you add?
A. A new trust relationship
B. The DLL to the global assembly cache
C. A trusted data provider
D. A user-defined function assembly
Answer: B
Explanation: Excel Services User-Defined Functions (UDFs) Strong Name Dependencies
In some cases, a user-defined function (UDF) assembly depends on other assemblies that are deployed with it. These dependent DLLs load successfully if they are in the global assembly cache, or if they are located in the same folder as the UDF assembly.
Reference: Excel Services Best Practices
Q8. - (Topic 4)
You need to ensure that the web servers can communicate with service applications after you replace the existing farm.
What should you do?
A. Configure Windows Firewall to allow traffic on port 1433.
B. Configure the network firewalls to allow traffic on port 32843.
C. Configure Windows Firewall to allow traffic on port 32843.
D. Configure the network firewalls to allow traffic on port 1433.
Answer: B
Q9. - (Topic 12)
You are configuring a SharePoint farm in an environment that includes Microsoft Exchange Server 2013.
You need to ensure that specified SharePoint users can search the Exchange mailboxes of all employees, place holds on mailbox data, and export mailbox data.
What should you do first?
A. Configure forms-based authentication between SharePoint and Exchange.
B. Create an external content type for Exchange mailbox information.
C. Define a group target application in the Secure Store that contains Exchange connection information.
D. Configure SharePoint and Exchange to use the same realm name.
Answer: A
Q10. DRAG DROP - (Topic 6)
Your company has an internal network and a perimeter network. The internal network contains an Active Directory domain.
You plan to deploy a SharePoint Server 2013 server farm. The farm will contain a single web application that uses NTLM authentication by using the domain controller on the internal network.
The relevant components on the network are listed in the following table.
All services use default TCP ports.
You need to configure the inbound rules for Firewall1 and Firewall2 to ensure that users
from the Internet can access content in the farm by using either HTTP or HTTPS.
What should you configure? 0"o answer, drag the appropriate TCP ports to the correct firewalls.
Each port 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: