nerdexam
Microsoft

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.

Plan a SharePoint environment

Question

You need to configure the required level of access to the SharePoint 2010 farm prior to the migration. What should you do?

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)
  • A
    81% (17)
  • B
    5% (1)
  • C
    10% (2)
  • D
    5% (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.

AIn the corporate farm, run the ALTER DATABASE Transact-SQL statement.Correct

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.

BIn the corporate farm, run the CONFIG DATABASE Transact-SQL statement.

CONFIG DATABASE is not a valid Transact-SQL statement; no such command exists in SQL Server for configuring database access.

CIn the product support farm, run the CONFIG DATABASE Transact-SQL statement.

The product support farm is the destination, not the source; the access configuration must be applied in the corporate farm where the data resides.

DIn the product support farm, run the ALTER DATABASE Transact-SQL statement.

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

#migration#database access#ALTER DATABASE#SharePoint 2010 farm

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice