Microsoft PRO:MS SQL Server 2008, Designing a Business Intelligence - 070-452무료 덤프문제 풀어보기
You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008
Reporting Services (SSRS) report that meets the following requirements:
-Displays sales data for the last 12 months.
-Enables users to view the sales information summarized by month.
-Enables users to view individual sales orders for any given month.
You need to design the report to minimize the impact on bandwidth.
What should you do?
Reporting Services (SSRS) report that meets the following requirements:
-Displays sales data for the last 12 months.
-Enables users to view the sales information summarized by month.
-Enables users to view individual sales orders for any given month.
You need to design the report to minimize the impact on bandwidth.
What should you do?
정답: D
You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You intend to configure a SQL Server 2008Analysis Services (SSAS) cube which reads from a remote data source and increases several measure groups by 1 million rows everyday. The cube includes 110 million Fact rows and 600 dimension attributes. You intend to increase the number of users by 200 percent for the cube. During cube processing, you must capture the baseline performance on the overall system. So what should you do?
정답: B
You administer a server that runs SQL Server 2008 Integration Services (SSIS) packages.
The packages are stored on the file system.
You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL
Server backup process.
What should you do?
The packages are stored on the file system.
You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL
Server backup process.
What should you do?
정답: C
You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the Web site of your company. Information that you need for analysis is stored in the log files on the Web server. You plan to work out a SQL Server 2008 Integration Services (SSIS) solution to load the information from the log files into a database. You need to enumerate the log files that are stored on the Web server.So which control flow element should you utilize?
정답: D
You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a measure named
Sales Amount and a dimension named Date. The Date dimension has a hierarchy named Fiscal that has
levels named Fiscal Year, Fiscal Quarter, and Fiscal Month.
You need to create a calculated member to analyze the Sales Amount share percentage at different levels
compared to the total sales for a given Fiscal Year.
Which code segment should you use?
Sales Amount and a dimension named Date. The Date dimension has a hierarchy named Fiscal that has
levels named Fiscal Year, Fiscal Quarter, and Fiscal Month.
You need to create a calculated member to analyze the Sales Amount share percentage at different levels
compared to the total sales for a given Fiscal Year.
Which code segment should you use?
정답: C
You design a Business Intelligence (BI) solution by using SQL Server 2008. Your company processes all
transaction data in a Point of Sale (POS) application. Based on the transaction data, you design a solution
to predict the type of products a customer tends to purchase on a single visit.
You need to identify the appropriate algorithm to design the solution.
Which algorithm should you use?
transaction data in a Point of Sale (POS) application. Based on the transaction data, you design a solution
to predict the type of products a customer tends to purchase on a single visit.
You need to identify the appropriate algorithm to design the solution.
Which algorithm should you use?
정답: A
You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL
Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application
increases. This results in performance problems. The datasets for the reports are optimized.
You investigate the SSRS deployment and discover the following characteristics:
-Users report that the reports take a long time to run.
-There are a large number of graphical reports that summarize data.
-Subscription processing affects the performance of reports that are run by interactive users.
You need to modify the SSRS infrastructure to resolve the performance problems.
Which scale-out strategy should you use?
Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application
increases. This results in performance problems. The datasets for the reports are optimized.
You investigate the SSRS deployment and discover the following characteristics:
-Users report that the reports take a long time to run.
-There are a large number of graphical reports that summarize data.
-Subscription processing affects the performance of reports that are run by interactive users.
You need to modify the SSRS infrastructure to resolve the performance problems.
Which scale-out strategy should you use?
정답: C
You design a Business Intelligence (BI) solution by using SQL Server 2008. You have created an extract,
transform, and load (ETL) solution by using SQL Server 2008 Integration Services (SSIS). The solution
contains 10 child packages and a parent package that executes the child packages in sequence.
You plan to deploy the solution to 20 locations that are not connected to each other. You need to deploy
the solution by configuring the connection managers of all packages with the appropriate settings. You need
to achieve this goal by using the minimum amount of administrative effort.
What should you do?
transform, and load (ETL) solution by using SQL Server 2008 Integration Services (SSIS). The solution
contains 10 child packages and a parent package that executes the child packages in sequence.
You plan to deploy the solution to 20 locations that are not connected to each other. You need to deploy
the solution by configuring the connection managers of all packages with the appropriate settings. You need
to achieve this goal by using the minimum amount of administrative effort.
What should you do?
정답: D