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?
Which expression should you use?
You create a SQL Server 2008 Reporting Services (SSRS) report for a school district.
The school district needs to be able to retrieve the median value of all test scores.
You build a custom function named Median that accepts the test scores and returns the
median test score.
You need to run this custom function.
Which expression should you use?
You need to derive the profit for each order without modifying the underlying data
You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder
table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?
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?
You need to enable this tracking based on Sales, Orders, and Shipments fact tables
You create a SQL Server 2008 Analysis Services (SSAS) solution.
Your organization wants to track the times that products are ordered, shipped, and received
in an existing cube.
You need to enable this tracking based on Sales, Orders, and Shipments fact tables.
What should you do?
You need to enable this functionality
You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report
with two parameters named Region and City in that order.
When the Region parameter is selected, the City parameter should be filtered by the Region
selected.
You need to enable this functionality.
What should you do?
Which Transact-SQL statement should you use?
You use a Microsoft SQL Server 2012 database that contains a table named BlogEntry that has the
following columns:
Id is the Primary Key.
You need to append the “This is in a draft stage” string to the Summary column of the recent 10
entries based on the values in EntryDateTime.
Which Transact-SQL statement should you use?