You need to ensure that all SSRS reports communicate to the SQL Server instance by using the Kerberos authenti
You administer a SQL Server 2008 Reporting Services (SSRS) instance. You plan to design
an authentication method for SSRS reports that use SQL Server data connections. You
need to ensure that all SSRS reports communicate to the SQL Server instance by using the
Kerberos authentication protocol. What should you do?
You need to create a dimension relationship to ensure that the OrderAmount column can be aggregated by the Shi
You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named
Orders that contains the following columns:
• OrderKey
• Shipper
• OrderAmount
You create a dimension named DimOrders from the Orders table. You set the OrderKey as a
key column and the Shipper column as an attribute. You create a measure group named
FactOrders from the Orders table.
You need to create a dimension relationship to ensure that the OrderAmount column can be
aggregated by the Shipper column.
What should you do?
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as
shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer
dimension.
What should you do?
Which code fragment should you insert at line 05?
You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining
extensions (DMX) to query a data mining model. You write the following DMX code segment
to query a Bike Buyer data mining model in a Decision Tree data mining structure. (Line
numbers are included for reference only.)
You need to ensure that the input columns automatically map to the columns in the data
mining structure.
Which code fragment should you insert at line 05?
Which code segment should you use?
CORRECT TEXT
You have a view that was created by using the following code:
You need to create an inline table-valued function named Sales.fn_OrdersByTerritory, which must
meet the following requirements:
Accept the @T integer parameter.
Use one-part names to reference columns.
Filter the query results by SalesTerritoryID.
Return the columns in the same order as the order used in OrdersByTerritoryView.
Which code segment should you use?
To answer, type the correct code in the answer area.
You need to ensure that the reports will not affect query performance on the OLTP database
You are designing a database for a reporting solution that is based on data from an Online
Transaction Processing (OLTP) database. The reports will contain aggregated data. You
need to ensure that the reports will not affect query performance on the OLTP database.
The solution must minimize the use of joins when performing the aggregate calculations.
What should you do?
You need to ensure that the BonusPlan column is protected from unauthorized access by using the most secure me
You administer a SQL Server 2008 instance. You plan to design the security requirements
for a new database application that will be deployed to the instance. The new database
contains a table that is created by using the following code segment: CREATE TABLE
EmpBonusPlan ( EmployeeID INT NOT NULL IDENTITY(1,1), NumOptions INT NOT NULL,
BaseSalary MONEY NOT NULL, BonusPlan VARBINARY(MAX) FILESTREAM ) You need
to ensure that the BonusPlan column is protected from unauthorized access by using the
most secure method. What should you do?
Which MDX code segment should you insert at line 02?
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key
performance indicator (KPI) named GPMargin for your solution. You set the Value
expression of the KPI in the following manner.
You need to set a Trend expression of the KPI to show a difference in the values compared
with the previous quarter. Which MDX code segment should you insert at line 02?
You need to ensure that the aggregations designed on FactSales always include the Month attribute
You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution has the following components:
A dimension named DimTime that contains an attribute named Month
A measure group named FactSales that references the DimTime dimension
You need to ensure that the aggregations designed on FactSales always include the Month
attribute.
What should you do?
You need to ensure that SSAS can query relational data when multidimensional storage is being updated
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.
You need to ensure that SSAS can query relational data when multidimensional storage is
being updated.
What should you do?