MCM SharePoint Server 1 — Questions and Answers
Question 1: In SharePoint Server, which service application is responsible for providing search functionality across farm boundaries?
- User Profile Service
- Search Service Application (Correct answer)
- Managed Metadata Service
- Business Connectivity Services
Correct answer: Search Service Application
The Search Service Application indexes and queries content across the farm and can be shared across farms via service application proxies.
Question 2: What is the maximum recommended number of items in a SharePoint list before performance degradation typically occurs without list view throttling adjustments?
- 5,000 (Correct answer)
- 10,000
- 30,000
- 100,000
Correct answer: 5,000
SharePoint enforces a 5,000-item list view threshold by default to prevent database query timeouts and performance issues.
Question 3: Which SharePoint Server component is used to synchronize user profile properties from Active Directory Domain Services?
- Business Connectivity Services
- Secure Store Service
- User Profile Synchronization Service (Correct answer)
- Claims to Windows Token Service
Correct answer: User Profile Synchronization Service
The User Profile Synchronization Service (UPS) imports and synchronizes profile data from directory sources like AD DS into the User Profile Service Application.
Question 4: In a SharePoint farm, what is the primary role of the Distributed Cache service?
- Caching SQL query results to disk
- Providing in-memory caching for authentication tokens, newsfeeds, and session state (Correct answer)
- Distributing search index partitions across servers
- Managing distributed timer job execution
Correct answer: Providing in-memory caching for authentication tokens, newsfeeds, and session state
The Distributed Cache service uses AppFabric to cache transient data such as authentication tokens, social feeds, and MicroBlog data in memory for fast retrieval.
Question 5: Which database in a SharePoint farm stores configuration data for the entire farm including service application associations?
- Content Database
- Central Administration Database
- Configuration Database (Correct answer)
- Search Administration Database
Correct answer: Configuration Database
The SharePoint Configuration Database (SharePoint_Config) stores farm-wide settings, service application configurations, and server topology information.
Question 6: What SharePoint feature allows users to access data from external LOB systems such as SAP or Salesforce within SharePoint lists?
- External Content Types via Business Connectivity Services (Correct answer)
- InfoPath Forms Services
- Secure Store Service direct connectors
- SharePoint Connector for Oracle
Correct answer: External Content Types via Business Connectivity Services
Business Connectivity Services (BCS) uses External Content Types to define connections to external data sources and surface them as SharePoint lists or data columns.
Question 7: In SharePoint Server, which claims authentication provider allows users from multiple trusted identity providers to authenticate using a standards-based protocol?
- NTLM
- Kerberos
- SAML-based claims (Correct answer)
- Basic Authentication
Correct answer: SAML-based claims
SAML-based claims authentication enables federation with external identity providers (e.g., AD FS) using the Security Assertion Markup Language standard.
