Which script should you run?
You install and configure a SQL Server 2008 Reporting Services (SSRS) instance on a
server named ReportServer in the domain ABC.Com. SSRS is using a local database.
You need to set SSRS to use a new domain user account named ReportUser. The
password for ReportUser is Alphabet01.
Which script should you run?
Which authentication method should you use?
You administer a SQL Server 2005 instance. The instance is configured to use the named
pipes network communication protocol. You plan to upgrade the instance to SQL Server
2008. You need to ensure that the upgraded instance can continue to use the named pipes
network communication protocol. You also need to ensure that the server uses the most
secure authentication method available. Which authentication method should you use?
Which type of data region should you use?
You develop a report by using SQL Server 2008 Reporting Services (SSRS).
The report has a dataset that contains 25 columns of data. You plan to render the dataset to
a Microsoft Excel worksheet.
You need to implement drilldown technology when rendering to Excel.
Which type of data region should you use?
Which DMV should you use?
You administer a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to troubleshoot query performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute more than 10 commands prior to
disconnecting. Which DMV should you use?
Which Transact-SQL query should you use?
A table named Profits stores the total profit made each year within a territory. The Profits table has
columns named Territory, Year, and Profit. You need to create a report that displays the profits
made by each territory for each year and its preceding year. Which Transact-SQL query should you
use?
You need to ensure that only the dimensions are updated
You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to update only the Products dimension while processing the cube by using an XML
for Analysis (XMLA) script.
You need to ensure that only the dimensions are updated.
What should you do?
You need to ensure that the policy is configured to meet the security requirement
You administer a SQL Server 2008 instance. Your company security policy is designed to
prevent changes to the server to the server configuration. You plan to use Policy-Based
Management Framework to implement the security policy. You need to ensure that the
policy is configured to meet the security requirement. What should you do?
You need to ensure that users in the Engineering and Design role can only view data for their department
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains
a database that is used by the members of the Engineering group.
You configure a new role named Engineering and Design by using the following allowed
permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can only view data for
their department.
What should you do?
You need to ensure that the disruption to users is minimal while the stored procedure is being executed
You are a database developer. You plan to design a database solution by using SQL Server
2008. A database contains a table named Policies. The table contains information about
100 million insurance policies. A complex stored procedure executes daily to calculate the
risk amount of each policy and stores the information in the table. When the stored
procedure is executed, users experience poor performance and query time-out errors. The
queries used in the stored procedure are optimized for performance. You need to ensure
that the disruption to users is minimal while the stored procedure is being executed. What
should you do?
You need to determine the inventory at the end of a quarter
Your company network includes a SQL Server 2008 R2 database server with the SQL
Server 2008 Analysis Services (SSAS) role enabled.
You design a cube named Materials with a measure group named MaterialsInventory. This
group has a measure, QuantityOnHand, which shows the total stock in inventory for the
company by time.
You need to determine the inventory at the end of a quarter.
What should you do?