Exam Name:
TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Question: 1
You're the administrator of your company network. And SQL Server 2008 has been deployed on
your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services
(SSAS) solution and then you design a Business Intelligence (BI) solution. There's a dimension
named DEClients in the solution. And the dimension is used to stand for clients who buy products
in your company. The solution gives a list of top 8 Clients according to the sales amount. End
users of the solution use filters in Microsoft Excel worksheet to analyze data. Now you're
assigned a task to make sure that when the filters are applied, the list must be updated. So which
named set expression should you use to achieve this?
A. CREATE SESSION SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([
DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
B. CREATE HIDDEN SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([
DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
C. CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([
DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
D. CREATE SET CURRENTCUBE.[Top 10 Clients] ASTOPCOUNT([
DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
Answer: C
Question: 2
You're the administrator of your company network. And SQL Server 2008 has been deployed on
your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
There is a SQL Server 2008 Analysis Services (SSAS) cube which contains 110 million Fact rows
and 750 dimension attributes. The cube reads data from a remote data source and increases
several measure groups by 1 million rows everyday. You intend to deploy this SQL Server 2008
Analysis Services (SSAS) cube. You want to increase the total number of users by 180 percent
for the cube. During cube processing, you have to capture the baseline performance on the
overall system. So what should you do?
A. You should use the sp_monitor system stored procedure to monitor cube processing events.
B. You should use the sp_trace_setfilter system stored procedure to monitor cube processing
events.
C. You should configure the data collector to collect Query Activity statistics during cube
processing.
D. You should configure the data collector to collect Performance Counters statistics during cube
processing.
Answer: D
Question: 3
You're the administrator of your company network. And you are in charge of a Microsoft SQL
Server 2005 Reporting Services (SSRS) instance which is deployed as a single server and
configured to use Native mode. Besides this, the instance also has another feature: A custom
data extension developed by using Microsoft .NET Framework 2.0. Now you intend to upgrade
the instance to SQL Server 2008 Reporting Services without loss of functionality. So what should
you do to achieve this?
A. You should uninstall Internet Information Services (IIS).
B. You should upgrade the data extension to .NET Framework 3.5.
C. You should edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint
location.
D. You should install a new instance of SSRS. Migrate the existing configuration files and
database to the new instance.
Answer: D
Question: 4
You're the administrator of your company network. And SQL Server 2008 has been deployed on
your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
Now you manage a SQL Server 2008 instance which hosts a database. At present the database
is scheduled for a full backup every month and uses the bulk-logged recovery model. The 4-
terabyte database contains 3.5 terabyte of data in a read-only filegroup. You have to back up the
database changes to a tape drive every night, you must use as little storage space and time as
possible. So which backup strategy should you use?
A. You should use file backup
B. You should use Partial backup
C. You should use differential backup
D. You should use differential Partial backup
Answer: D
Question: 5
You're the administrator of your company network. And you're in charge of designing the SQL
Server 2008 Analysis Services (SSAS) data mining. The customer table contains column names
such as: Age, Name, IsBuyer, Customer_key, Education Level.
You intend to use Microsoft Decision Trees algorithm to build a data mining model for the
customer table. You have to identify the data columnCmodel parameter pairs to forecast the
potential buyers.
Click here to input the answer.
No comments:
Post a Comment