Question 1.
You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB01, which hosts the SQL Server 2008 Reporting Services (SSRS) instance. During routine monitoring, you discover that this instance does not render any extensions for Microsoft Office Word.

How would you modify the instance to render these extensions?

A. The Report Server database should be modified on ABC-DB01.
B. The RSReportServer.config file should be modified on ABC-DB01.
C. The XML configuration file should be modified onABC-DB01.
D. The Web.config file should be modified on ABC-DB01.

Answer: B

Explanation:

Question 2.
You work as a database administrator for ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB03. You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for the ABC.com network. ABC.com has informed you that ABC-DB03 will be hosting the package. You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03 becomes inactive.

How can this be achieved?

A. The master database should be backed up.
B. You should back up ABC-DB03.
C. You should execute an incremental backup on a weekly basis.
D. The SSIS package should be backed up.

Answer: A

Explanation:

Question 3.
You work as a database administrator at ABC.com. You are responsible for managing a SQL Server 2008 database server named ABC-DB01. You receive instruction that the SQL Server 2008 Reporting Services model needs to be deployed on ABC-DB01 to support a data source that contains 800 tables for the Marketing division. You have been tasked with developing a report model.

Which of the following options will make sure that the Marketing division is only able to access 10 tables? (Choose two)

A. A data source view should be developed.
B. The marketing division should be denied access to the other tables.
C. The tables and views the marketing division will not be using should be highlighted.
D. The tables and views the marketing division will use should be indicated.
E. The Dynamic Management View should be properly modified.

Answer: A, D

Explanation:

Question 4.
You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server Analysis Services (SSAS) role. There is a dimension named Housing in ABC-DB01 that contains three properties named Slabs, Cement and Bricks. The relationship between the properties is nonflexible. Currently a data source is used that indicates the changes between the affiliations of the properties. You receive an instruction from the CIO to ensure that any modifications will be reflected.

Identify the command that will help you to accomplish your task?

A. The ProcessDefault command
B. The ProcessAdd command.
C. The ProcessFull command.
D. The ProcessClear command.
E. The ProcessNone command.

Answer: A, D

Explanation:

Question 5.
You work as a database administrator at ABC.com. Your duties include administering a SQL Server 2008 Analysis Services (SSAS) sample named ABC-DB01. You receive an instruction from the CIO to log all queries. You then decide to make the necessary changes to the QueryLogconnection String feature.

What should your next step be?

A. You should modify the connection string to the default value.
B. A valid connection string should be set on ABC-DB01.
C. The source attribute should be set to 20.
D. You should set the default value using Discover_Query.

Answer: B

Explanation:

Question 6.
You work as a database administrator at ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role. While querying ABC-DB05, you are presented with a Duplicate Key error. You receive an instruction from the CIO to make minor modifications to the ErrorConfiguration feature to resolve this problem.

Which of the following actions should you take?

A. The store procedure should be modified.
B. The Data Viewer object should be modified.
C. The connection string should be modified.
D. The dimension should be modified.

Answer: D

Explanation:

Question 7.
You work as a database administrator for ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB01 that contains a single partition. ABC-DB01 is hosting a SQL Server 2008 Analysis Services (SSAS) role. You are tasked with the responsibility of ensuring that information is updated in the partition every thirty minutes.

Identify the command that will assist you in updating the partition?

A. The ProcessClear command should be used.
B. The ProcessDefault command should be used.
C. The ProcessIndex command should be used.
D. The ProcessAdd command should be used.
E. The ProcessDefault command should be used.

Answer: D

Explanation:

Question 8.
You work as a database administrator for ABC.com. The ABC.com network has a SQL Server 2008 Analysis Services (SSAS) instance on a database server named ABC-DB05. ABC-DB05 contains a DataDir feature. You receive notification from management to change the feature to a folder named Features. It is imperative that Features is used in as little time as possible.

How can you achieve this?

A. By configuring the Analysis services.
B. By using the SQL Server Destination.
C. By running the database.
D. By setting the query log using the Transaction Log Tool.

Answer: C

Explanation:

Question 9.
You work as a database administrator at ABC.com. You are responsible for managing a SQL Server 2008 database server named ABC-DB01. You are in the process of creating a complex report on ABC-DB01 using SQL Server 2008 Reporting Services (SSRS). You receive an instruction to have the report cached for the first twenty minutes upon commencing the request. You then decide to configure ABC-DB01 to comply with the stipulation.

Which of the following actions should you take?

A. The Full cache option should be configured.
B. You should configure the data source as a parameter from the data table.
C. You should configure the Default cache option.
D. Report execution caching should be configured.

Answer: D

Explanation:

Question 10.
You work as a database administrator for ABC.com. You are responsible for a SQL Server 2008 computer named ABC-DB01, which hosts a SQL Server 2008 Reporting Services (SSRS) sample. A new ABC.com policy permits users to move reports via e-mail. ABC-DB01 should therefore be configured for the delivery of e-mail.

How can you configure ABC-DB01 to send or receive e-mail messages?

A. The XML configuration file should be modified.
B. The Report Server database should be modified.
C. The RSReportServer.config file should be modified.
D. The Web.config file should be disbaled.

Answer: C

Explanation:

	Web www.certsbraindumps.com