70-332 · Question #78
You need to configure the required level of access to the SharePoint 2010 farm prior to the migration. What should you do?
The correct answer is A. In the corporate farm, run the ALTER DATABASE Transact-SQL statement. The ALTER DATABASE Transact-SQL statement is used in the source (corporate) farm to grant the migration service account the necessary database-level permissions required before content can be read and migrated.
Question
Options
- AIn the corporate farm, run the ALTER DATABASE Transact-SQL statement.
- BIn the corporate farm, run the CONFIG DATABASE Transact-SQL statement.
- CIn the product support farm, run the CONFIG DATABASE Transact-SQL statement.
- DIn the product support farm, run the ALTER DATABASE Transact-SQL statement.
How the community answered
(21 responses)- A81% (17)
- B5% (1)
- C10% (2)
- D5% (1)
Why each option
The ALTER DATABASE Transact-SQL statement is used in the source (corporate) farm to grant the migration service account the necessary database-level permissions required before content can be read and migrated.
ALTER DATABASE allows a SQL Server administrator to modify database properties and permissions, including adding login mappings and changing database access settings needed by the migration account. The command must run in the corporate farm because that is the source environment whose databases need to be made accessible to the migration process. Using the correct farm ensures permissions are granted on the actual data being migrated.
CONFIG DATABASE is not a valid Transact-SQL statement; no such command exists in SQL Server for configuring database access.
The product support farm is the destination, not the source; the access configuration must be applied in the corporate farm where the data resides.
Although ALTER DATABASE is the correct statement, running it in the product support farm targets the wrong environment and would not grant access to the corporate farm's databases that need to be migrated.
Concept tested: Granting pre-migration database access using ALTER DATABASE in SharePoint
Source: https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql
Topics
Community Discussion
No community discussion yet for this question.