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.
the correct answer is
A & B
Yes Correct answers are A & B
https://msdn.microsoft.com/en-us/library/hh213068(v=sql.110).aspx
Agree with above all. A & B.
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.
A & B
A & B are correct options.