Free Microsoft 070-452 Exam Dumps Questions & Answers
| Exam Code/Number: | 070-452Join the discussion |
| Exam Name: | PRO:MS SQL Server 2008, Designing a Business Intelligence |
| Certification: | Microsoft |
| Free Question Number: | 139 |
| Publish Date: | Sep 18, 2025 |
| # of views: | 2187 |
|
|
|
You design a Business Intelligence (BI) solution by using SQL Server 2008. Employees use a Windows
Forms application based on Microsoft .NET Framework 3.5. SQL Server is not installed on the employees'
computers.
You write a report by using Report Definition Language (RDL). You need to ensure that if the employees
are disconnected from the corporate network, the application renders the report.
What should you do?
You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a
dimensional modeling strategy for a new data warehouse application.
The application contains the following dimensions:
-Product
-Time
-Customer
-SalesPerson
The application contains the following cubes:
-Sales that contains all the dimensions
-Products that contain the Product and the Time dimensions Customers that contain the Customer and the
Time dimensions
You need to design an appropriate dimensional modeling strategy for the Product and the Time
dimensions.
Which dimensional model should you use?
You design a SQL Server 2008 Analysis Services (SSAS) solution that contains a cube. The solution has a measure group that contains different measures aggregated by different dimensions. Users often browse the cube by using Microsoft Excel. You need to enable users to view additional row-level information of the aggregated measures from Excel by using the minimum amount of development effort. Which Action should you create?
You are managing a Business Intelligence (BI) infrastructure that uses SQL Server 2008 Integration
Services (SSIS). Your infrastructure has many SSIS solutions that contain several packages. The current
backup strategy includes nightly backups of all databases on the server. You need to develop a
deployment strategy that meets the following requirements:
-Deploys only the packages that have been modified.
-Includes all packages in the current backup strategy.
What should you do?
You administer a SQL Server 2008 Reporting Services (SSRS) environment. You restore the ReportServer and ReportServerTempDB databases to a new server. When you browse to the Report Manager Web page, you receive an error message. You are unable to view the folder structure and the reports. You need to view the folder structure and the reports. What should you do?