nerdexam
Microsoft

70-489 · Question #114

A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm. You are upgrading the farm to SharePoint 2013. You need to…

The correct answer is A. Run the following Transact-SQL (T-SQL) statement for each content database and service application. During a SharePoint 2010 to 2013 database-attach upgrade, setting content databases to read-only via T-SQL keeps the legacy farm live and accessible to users while those databases are being migrated to the new farm.

Implement an application lifecycle management (ALM) process for Microsoft SharePoint 2013

Question

A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm. You are upgrading the farm to SharePoint 2013. You need to ensure that users can access the unmodified farm contents during the upgrade process. What should you do?

Exhibit

70-489 question #114 exhibit

Options

  • ARun the following Transact-SQL (T-SQL) statement for each content database and service application
  • BRun the following command-line tool for each site collection in the content databases you plan
  • CRun the following Windows PowerShell cmdlets for each web application in the SharePoint 2010
  • DRun the following Transact-SQL (T-SQL) statement for each content database and service application

How the community answered

(34 responses)
  • A
    74% (25)
  • B
    3% (1)
  • C
    9% (3)
  • D
    15% (5)

Why each option

During a SharePoint 2010 to 2013 database-attach upgrade, setting content databases to read-only via T-SQL keeps the legacy farm live and accessible to users while those databases are being migrated to the new farm.

ARun the following Transact-SQL (T-SQL) statement for each content database and service applicationCorrect

Executing a T-SQL ALTER DATABASE ... SET READ_ONLY statement against each content database and service application database forces SQL Server to reject write operations, allowing the existing SharePoint 2010 farm to continue serving read requests to users uninterrupted while the databases are detached, copied, and attached to the SharePoint 2013 farm. This is the prescribed database-attach upgrade approach that prevents data changes mid-migration and ensures farm contents remain unmodified and accessible throughout the process.

BRun the following command-line tool for each site collection in the content databases you plan

Running a command-line tool per site collection operates at the SharePoint application layer and does not place the underlying SQL databases into read-only mode, so the farm content cannot be guaranteed to remain unmodified during the upgrade.

CRun the following Windows PowerShell cmdlets for each web application in the SharePoint 2010

Windows PowerShell cmdlets targeting each web application in SharePoint 2010 manage SharePoint-level configuration but do not set the SQL Server databases to READ_ONLY, which is the SQL-level mechanism required to preserve content integrity and continued user access during a database-attach upgrade.

DRun the following Transact-SQL (T-SQL) statement for each content database and service application

As presented, this option is textually identical to option A and appears to be a duplicate or data error in the question; the correct action is the T-SQL READ_ONLY approach described in option A.

Concept tested: SharePoint database-attach upgrade read-only SQL configuration

Source: https://learn.microsoft.com/en-us/sharepoint/upgrade-and-update/upgrade-content-databases

Topics

#farm upgrade#read-only content access#SP 2010 to 2013#content database

Community Discussion

No community discussion yet for this question.

Full 70-489 Practice