MCM SharePoint Server 2 — Questions and Answers
Question 1: Which SharePoint Server concept defines a collection of web applications, databases, and services installed on one or more servers working together?
- Web Application
- Site Collection
- Server Farm (Correct answer)
- Service Application Pool
Correct answer: Server Farm
A SharePoint Server Farm is the top-level logical unit consisting of all servers, web applications, service applications, and databases that work together as a single system.
Question 2: What is the purpose of the Secure Store Service in SharePoint?
- Encrypting content databases at rest
- Storing and mapping credentials for accessing external data sources (Correct answer)
- Managing SSL certificates for web applications
- Providing encrypted storage for user passwords in profiles
Correct answer: Storing and mapping credentials for accessing external data sources
The Secure Store Service stores credential sets (target application credentials) and maps them to SharePoint users or groups, enabling single sign-on to external systems.
Question 3: In SharePoint, what is a Managed Account and why is it used?
- A service account whose password is automatically managed and rotated by SharePoint (Correct answer)
- An account with Managed Metadata Service write access
- A privileged admin account locked to Central Administration only
- An account synchronized from a managed LDAP directory
Correct answer: A service account whose password is automatically managed and rotated by SharePoint
A Managed Account is a Windows domain account registered with SharePoint so that SharePoint can automatically change its password on a schedule, reducing manual credential management.
Question 4: Which SharePoint Server feature enables content to automatically move between document libraries based on metadata rules and conditions?
- Content Organizer (Correct answer)
- Retention Policy
- Record Declaration
- Workflow Foundation
Correct answer: Content Organizer
The Content Organizer routes documents to specific libraries or folders based on content type, metadata values, or other configurable rules when content is submitted.
Question 5: What does a SharePoint Web Application's IIS application pool identity determine?
- Which site collections can be created
- The security context under which SharePoint code runs when serving requests (Correct answer)
- The maximum file upload size for the application
- The authentication method used by client browsers
Correct answer: The security context under which SharePoint code runs when serving requests
The application pool identity is the Windows account under which the IIS worker process runs, determining what resources SharePoint code can access on the server and network.
Question 6: In SharePoint Server's search architecture, what is the role of the Index component?
- Crawling and fetching content from sources
- Storing the processed search index and serving queries (Correct answer)
- Processing and enriching crawled content with metadata
- Managing query suggestions and spelling corrections
Correct answer: Storing the processed search index and serving queries
The Index component stores the inverted index built from crawled and processed content, and it serves search queries by returning ranked document IDs to the query processing component.
Question 7: Which PowerShell cmdlet is used to add a new content database to an existing SharePoint web application?
- New-SPDatabase
- Mount-SPContentDatabase (Correct answer)
- Add-SPContentDatabase
- Install-SPContentDatabase
Correct answer: Mount-SPContentDatabase
Mount-SPContentDatabase attaches an existing SQL Server database to a SharePoint web application, making its site collections available in the farm.
MCM SharePoint Server 2
Which SharePoint Server concept defines a collection of web applications, databases, and services installed on one or more servers working together?