| Exam Code/Number: | 70-452Join the discussion |
| Exam Name: | PRO:MS SQL Server 2008, Designing a Business Intelligence |
| Certification: | Microsoft |
| Question Number: | 139 |
| Publish Date: | Oct 21, 2025 |
|
Rating
100%
|
|
You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. The SQL Server 2008 instance hosts a database which is scheduled for a full backup on a monthly basis. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup and uses the bulk-logged recovery model. You have to back up the database changes to a tape drive every night while using as little storage space and time as possible. So which backup strategy should you use?
You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Analysis Services (SSAS) project and use Microsoft Visual Source Safe (VSS) as the source control system. After making changes to the project, you check in the files to the VSS. Then, you deploy the project to a shared server for testing. Four new developers are assigned to work in parallel on the project. You need to ensure that the new developers can modify the most recent version of the project and test it without affecting the work of the existing developers. What should you do?
You are the administrator of your company network. And you have been assigned a task to develop a SQL Server 2008 data warehousing project. An online transaction processing
(OLTP) system is the source database for the project. During business time, the OLTP system executes 4,200 transactions every minute. And it records only the date and time of insertion of a new row and not for the updates of existing rows. You intend to develop an extract, transform, and load (ETL) process for the project which populates a data warehouse from the source database. When developing the ETL process, it must be configured in the following manner:1. To run after business hours2. To capture new rows and existing rows that have been modifiedYou have to make sure that only new rows or modified rows from the database tables are processed by the ETL process. So 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?
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?
