×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008
Analysis Services (SSAS) database. You want to use Dynamic Management View (DMV) to improve the query
performance.
What should you do?
2.
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008
Analysis Services (SSAS) method. The SSAS method contains a time dimension named CKTime in
conjunction with a rule named CKCalendar. The CKCalendar rule contains the levels for the Year, Quarter,
Month and Date properties. You need develop a dimension named setQuarter that will connect with the first
three months of the year 2009. What should you do?
3.
You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Analysis
Services (SSAS) database. You want to make use of the incremental processing method to ensure that data is
updated in a partition every hour. What should you do?
4.
You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Analysis
Services (SSAS) method. The SSAS method includes a dimension named CKTime. The method contains a
table named CKSales that includes the two fields named CKOrders and CKShipments which is connected with
CKTime. You need to make sure that data is received by measures using CKTime. What should you do?
5.
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008
Analysis Services database sample named CKOrders. You need to collect data related to the temporary file
usage in order to log Analysis Services performance data when CKOrders is used.
What should you do?
6.
You work as a database administrator at Abc.com. Your duties include administrating a SQL Server 2008
Analysis Services (SSAS) database named CKSales. While querying CKSales you receive a Duplicate Key
error. To ensure that processing will run normally you have to make the appropriate changes to the
ErrorConfiguration feature. What should you do?
7.
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008
Analysis Services method for Abc.com. Abc.com has a dimension named DimProducts. DimProducts includes
a property named Quantity. You need to ensure that aggregations cannot be linked to the Quantity property.
What should you do?
8.
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008
Reporting Services (SSRS) report for Abc.com. The report will run from a SQL Server 2005 Analysis Services
database named CKData. You need to ensure that the report displays the member attributes as well as the
extended attributes. What should you do?
9.
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008
Reporting Services (SSRS) report. The SSRS report includes a table as well as a matrix that makes use of the
dataset that returns data by running a stored procedure. You need to determine the data that will be returned in
the table. You need to accomplish this while ensuring that the matrix is running normally. What should you do?
10.
You work as a database administrator at Abc.com. You are currently creating a SQL Server 2008 Reporting
Services (SSRS) sample for Abc.com. You publish the report to a list of subscribers on a report server. You
need to create a subscription on the report server. What should you do?