Get real exam questions for 70-470 Recertification for MCSE: Business Intelligence. 100% Free.
Q1. HOTSPOT - (Topic 9) You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Category is based on the DimCategory table. A subset of the data source view is shown in the following graphic. You need to relate the Category dimension to the Sales measure group. Which relationship type should you choose? To answer, select the appropriate option from the drop-down list
Q1. - (Topic 2) You need to configure SSRS to meet the maximum number of snapshots requirement. What should you do? (Each answer presents a complete solution. Choose all that apply.) A. In SharePoint Central Administration, set the System Snapshot Limit option to 5. B. In Reporting Services Configuration Manager, set the System Snapshot Limit option to 5. C. For each report, set the Limit n
Q1. - (Topic 9) You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS). Many of the SSRS reports will use common utilities and functions, including the following: .. Report utility functions and business logic in code Standardized report formatting properties such as fonts and colors for report branding Formatting may change and new f
Q1. - (Topic 9) You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You have the following requirements: . Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distribut
Q1. - (Topic 10) You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a data model. Which role permission should you use? A. Explorer B. Process C. Administrator D. select E. Browser F. Read View AnswerAnswer: F Q2. HOTSPOT - (Topic 10) You are developing a SQL Server Analysis
Q1. - (Topic 1) You need to create the hierarchy in the AdhocReports project in time for the next production release cycle. What should you do? A. Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle. B. Use the RELATED() function to consolidate the columns in the DimSalesTerritory table, mult
Q1. - (Topic 1) You need to create the sales territory and product measures. Which aggregate function should you use for both measures? A. COUNT (DISTINCT column_name) B. Distinct Count C. Distinct D. Count View AnswerAnswer: B Q2. - (Topic 10) You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The c
Q1. - (Topic 5) You need to select the appropriate storage settings for the cube. Which settings should you choose? A. Relational OLAP (ROLAP) with proactive caching enabled B. Multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours C. Hybrid OLAP (HOLAP) with proactive caching disabled D. Hybrid OLAP (HOLAP) with proactive caching enabled View Answe
Q1. - (Topic 7) You need to identify the reasons that data alert notifications are not being sent. Which of the following reasons are possible? (Each correct answer presents a complete solution. Choose al that apply.) A. The shared schedule is paused. B. The data source used by the report is disabled. C. The SSRS service is not running. D. The report data has not changed since the previous
Q1. - (Topic 9) You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours. Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level. You need to partition the table to maximize the
Q1. HOTSPOT - (Topic 9) You administer a SQL Server Analysis Services (SSAS) cube. You plan to optimize the cube partitions by using usage-based optimization. You need to configure the SSAS instance. Which properties should you configure? To answer, select the appropriate properties in the dialog box in the answer area. View AnswerAnswer: Q2. - (Topic 10) You are managing a SQL Server R
Q1. DRAG DROP - (Topic 10) You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2012. You need to import an existing PowerPivot workbook to create a tabular project. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in
Q1. - (Topic 5) You need to implement the aggregation designs for the cube. What should you do? A. Use the Usage-Based Optimization Wizard. B. Use the Aggregation Design Wizard. C. Partition the cube by month. D. Implement cache warming in SSAS via an SSIS package. View AnswerAnswer: B Q2. - (Topic 9) You are designing a subscription strategy for a SQL Server Reporting Services (SSRS)
Q1. - (Topic 10) You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff i
Q1. - (Topic 10) You are designing a SQL Server Analysis Services (SSAS) cube. You need to create a measure to count unique customers. What should you do? A. Use role playing dimensions. B. Use the Business Intelligence Wizard to define dimension intelligence. C. Add a measure that uses the Count aggregate function to an existing measure group. D. Add a measure that uses the DistinctCount