PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which action should you perform?

You are a professional level SQL Sever 2008 Database Administrator. An authentication
method should be designed for SSRS reports that SQL Server data connections are
utilized. Since you are the technical support of the company, you are required to make sure
that all SSRS reports utilize the Kerberos authentication protocol to communicate to the
SQL Server instance. Which action should you perform?

Which expression should you use?

You are developing a SQL Server 2008 Reporting Services (SSRS) report.
The organization requires a drilldown report that color coordinates the values of students’
test scores. All average scores 70% or higher should have a green background. All lower
average scores should have a red background.
You need to enable this functionality.
Which expression should you use?

You need to ensure that the query retrieves data in minimum possible time

You are a database developer. You plan to design a database solution by using SQL Server
2008. The database has a table named Sales. The Sales table contains 10 million rows.
You discover that the following query takes a long time to execute. SELECT s.sale_id, …
FROM Sales AS s JOIN Country AS c ON s.Country_id = c.Country_id AND
c.Country_name = ‘USA’ A summary of the execution plan is as shown in the following code
segment. |–Hash Match(Inner Join, HASH:([s].[Country_id]) = ([c].[Country_id]) |–Clustered
Index Scan(OBJECT:([Country].[PK_Country_Country_id] AS [c]) |–Clustered Index
Scan(OBJECT:([Sales].[PK_Sales_Sale_id] AS [s])) You need to ensure that the query
retrieves data in minimum possible time. What should you do?

Which action will you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator. Two SQL Server
2008 instances are managed by you, and they are respectively called Ins01 and Ins02. The
Sales database is included in Ins01, while the Accounts database is contained by Ins02. A
transaction is started by A procedure in the Sales database. And then, the Sales.dbo.Order
table and the Accounts.dbo. OrderHistory table are updated by the procedure through a
linked server. Since you are the technical support of the company, you are required to make
sure that a two-phase commit is utilized by the transaction. Which action will you perform to
finish the task?

Which clustering method should you use?

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You are developing a new data mining structure.
You need to set the Microsoft Clustering Algorithm to meet the following requirements:
Allow data points to be assigned to two clusters.
Generate a probability for each combination of data point and cluster.
Provide the fastest results on large datasets (greater than one million records).
Which clustering method should you use?