Exam 70-452 study material Made available by Testkingprep.com
Free 70-452 Exam Preparation Questions Exam 70-452: PRO: MS SQL Server@ 2008, Designing Business Intelligence
For Latest 70-452 Exam Questions and study guides- visit- http://www.testkingprep.com/70-452.html
Question:1 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? 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:2 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? A. You should configure the data warehouse database to support the Type II Slowly Changing Dimension transformation. B. You should configure the data warehouse database to support the Type I Slowly Changing Dimension transformation. C. You should configure the Change Data Capture feature on all the source database tables that will be processed by the ETL process. D. You should configure the Change Data Capture feature on all the data warehouse database tables that will be processed by the ETL process. Answer: C Question:3 You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. And you intend to develop a dimensional modeling strategy for a new data warehouse application which contains the following dimension: Time, Product, Customer, SalesPerson.And the application contains the following cubes:1: Sales that contains all the dimensions2: Customers that contain the Customer and Time dimensions3: Products that contain the Product and the Time dimensionsNow you have to develop a suitable dimensional modeling strategy for the Product and the Time dimensions.So which dimensional model should you utilize? A. You should utilize reference dimensions B. You should utilize conformed dimensions C. You should utilize degenerate dimensions D. You should utilize Parent-Child dimensions Answer: B Question:4 You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. The instance includes an SQL Server 2008 Analysis Services (SSAS) database which contains a cube named Sales. And the sales cube has a role named roleAfrica and a dimension named locality which has a hierarchy that contains the following members: City, Region, Continent.You intend to develop the security configuration for the Sales cube. You have to enable the Read permissions for the roleAfrica role. You also have to ensure that the roleAfrica role can access
For Latest 70-452 Exam Questions and study guides- visit- http://www.testkingprep.com/70-452.html
only the Fact rows that are members of the Africa continent. So which Multidimensional Expressions (MDX) statement should you utilize? A. You should utilize MEASURES.CURRENTMEMBER IS EUROPE B. You should utilize ANCESTOR(GEOGRAPHY.CURRENTMEMBER) IS EUROPE C. You should utilize MEASURES.CURRENTMEMBER[CONTINENT] IS EUROPE D. You should utilize ANCESTOR(GEOGRAPHY.CURRENTMEMBER,[CONTINENT]) IS EUROPE Answer: D
For Latest 70-452 Exam Questions and study guides- visit- http://www.testkingprep.com/70-452.html
For complete Exam 70-452 Training kits and Self-Paced Study Material Visit: http://www.testkingprep.com/70-452.html
http://www.testkingprep.com/
For Latest 70-452 Exam Questions and study guides- visit- http://www.testkingprep.com/70-452.html