What should you do?

Correct Answer for the following Question is given below

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.)Steps to restore DQS Databases:1. Restore DQS_MAIN database.2. Restore the DQS_PROJECTS database.Restore the DQS_STAGING_DATA database.3.In Object Explorer, right-click the server, and then click New Query.4.In the Query Editor window, copy the following SQL statements, and 5. replace with the password that you provided during the DQS installation for the database master key:USE [DQS_MAIN]GOEXECUTE [internal_core].[RestoreDQDatabases] ‘’ GOPress F5 to execute the statements. Check the Results pane to verify that the statements 6.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 andDQS_PROJECTS. The backup and restore procedures of the Data Quality Services (DQS) databases are similar to any other SQL Server databases.Ref: http://msdn.microsoft.com/en-gb/library/hh213068(v=sql.110).aspx

Question:

What should you do?

Options:

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

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

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

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

Correct Answer

The Correct Answer for this Question is

Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to another server as soon as possible.
Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the appropriate parameter.

Explanation

The Question – What should you do? has been answered correctly and answers for the question is Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to another server as soon as possible.
Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the appropriate parameter.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment