×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using multiple security roles. The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The application is configured to use Windows Authentication. You need to ensure that the users of the application can successfully access the SSAS database. You also need to ensure that security restrictions of the roles are applied. What should you do?
2.
You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
You need to create a mining model that can be processed by using this mining structure. You also need to ensure that the model uses the Microsoft Decision Trees algorithm. Which DMX statement should you use?
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
You need to create a mining model that can be processed by using this mining structure. You also need to ensure that the model uses the Microsoft Decision Trees algorithm. Which DMX statement should you use?
3.
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension named Date along with a hierarchy named Calendar. The Calendar hierarchy has levels for the Year, Quarter, Month, and Date attributes. You need to create a named set that refers to the first seven months of the year 2007. Which expression should you write for the named set?
4.
You maintain a SQL Server 2008 Analysis Services (SSAS) database. You plan to troubleshoot query performance by using SQL Profiler. You need to identify the queries that take a long time to run. Which trace event should you use?
5.
You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis Services (SSAS) database. The database contains a dimension named Employee. You plan to configure the security for the Managers role. You need to allow the Managers role to access aggregate data based on only three or less employees. What should you do?
6.
You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new measure group in one of the cubes. You have a program that maintains partitions on the production copy of the cube. You need to update the cube definition on the production server without overwriting any existing partitions. What should you do?
7.
You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instance. You plan to document the Analysis Services performance information. You need to collect information related to the temporary file usage when the database is processed. Which object should you use?
8.
You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension. The dimension contains the Category and Subcategory attributes. The attributes have a Rigid relationship type. The data source for the Product dimension changes the relationship between the Category and Subcategory values. You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully reflect the change. What should you do?
9.
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to run the Usage-Based Optimization Wizard. You need to enable query logging. What should you do?
10.
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to process a cube by using an XML for Analysis (XMLA) script. You need to ensure that aggregations are populated. What should you do?