You need to restore the server that hosts Data Quality Server to another server

You are the administrator of a server that hosts Data Quality Server for a large retail
company.
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a
recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)

You are the administrator of a server that hosts Data Quality Server for a large retail
company.
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a
recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)

A.
Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to
another server as soon as possible.

B.
Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the
appropriate parameter.

C.
Restore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as
soon as possible.

D.
Execute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate
parameter.

Explanation:
Steps to restore DQS Databases:
1. Restore DQS_MAIN database.
2. Restore the DQS_PROJECTS database.
3. Restore the DQS_STAGING_DATA database.
4. In Object Explorer, right-click the server, and then click New Query.
5. In the Query Editor window, copy the following SQL statements, and replace
<PASSWORD> with the password that you provided during the DQS installation for the
database master key:
USE [DQS_MAIN]
GO
EXECUTE [internal_core].[RestoreDQDatabases] ‘<PASSWORD>’
GO
6. Press F5 to execute the statements. Check the Results pane to verify that the
statements have executed successfully.
Note:
* Backup and restore of SQL Server databases are common operations that database
administrators perform for preventing loss of data in a case of disaster by recovering data
from the backup databases. Data Quality Server is primarily implemented by two SQL
Server databases: DQS_MAIN and DQS_PROJECTS. The backup and restore procedures
of the Data Quality Services (DQS) databases are similar to any other SQL Server
databases.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


dennis

dennis

the correct answer is

A & B

Ritesh

Ritesh

Yes Correct answers are A & B

MKL

MKL

Agree with above all. A & B.

TBiMac

TBiMac

According to the provided explanation, the answer is A & B:

1. Restore DQS_MAIN database.
2. Restore the DQS_PROJECTS database.
3. Restore the DQS_STAGING_DATA database.
4. In Object Explorer, right-click the server, and then click New Query.
5. In the Query Editor window, copy the following SQL statements, and replace
with the password that you provided during the DQS installation for the
database master key:
USE [DQS_MAIN]
GO
EXECUTE [internal_core].[RestoreDQDatabases] ‘’
GO
6. Press F5 to execute the statements. Check the Results pane to verify that the
statements have executed successfully.

A=> Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases
B=> Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the
appropriate parameter.

Aakaash

Aakaash

A & B are correct options.