70-467 Practice Questions

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day. You have the foll...

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic....

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse. Tens of millions of new inventory fact records are loaded into the data warehous...

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedule...

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with wh...

You administer a SQL Server Reporting Services (SSRS) instance in native mode. You need to assign a predefined role that meets the following requirements: - Members of the role mus...

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,...

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define th...

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...

You are designing an extract, transform, load (ETL) process for loading data from a SQL Server database into a large fact table in a data warehouse each day with the prior day's sa...

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Customer A, Projected Revenue is defined as 150 percent of the Total Sales fo...

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic....

You are modifying a star schema data mart that feeds order data from a SQL Azure database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables t...

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Product dimension that contains a Category hierarchy and a Color attri...

An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements: - Implement drill-down browsing. - Reduce the number of...

You are designing an extract, transform, load (ETL) process for loading data from a SQL Azure database into a large fact table in a data warehouse each day with the prior day's sal...

You are designing a multidimensional OLAP (MOLAP) cube. The MOLAP cube must meet the following requirements: Ensure that workloads for aggregation tuning can be automatically colle...

You are designing a fact table in a SQL Server database. The fact table must meet the following requirements: - Include a columnstore index. - Allow users to choose up to 10 dimens...

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Product A, Projected Revenue is defined as 150 percent of the Total Sales of...

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Customer dimension that contains a Geography hierarchy and a Gender at...

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 hav...

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define th...

You need to fix the PowerPivot data refresh problem by using the least amount of administrative effort. What should you do?

You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?

You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure. What should you do? (Each correct answer presents part of the...

You need to configure package execution logging to meet the requirements. What should you do?

You need to create the Sales Reporting shared SSRS data source. Which SSRS data connection type should you use?

You need to select an appropriate tool for creating the Regional Sales report. Which tool or tools should you use? (Each correct answer presents a complete solution. Choose all tha...

You need to select an appropriate tool for creating the Regional Sales report. Which tools or tools should you use? (Each Answer presents a complete solution. Choose all that apply...

You need to create the calculation for SalespersonName. What should you do? (Each Answer presents a complete solution. Choose all that apply.)

You need to configure data refresh for the Manufacturing Performance PowerPivot workbook. What should you do? (Each Answer presents part of the solution. Choose ail that apply.)

You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime. What should you do? (Each correct answer presents part of the solution. Cho...

You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS). How should you configure the backup options?

You need to implement the Customer Sales and Manufacturing data models. What should you do? (Each correct answer presents a partial solution. Choose all that apply.)

You need to re-establish subscriptions on SSRS01. What should you do?

You need to roll back the compatibility level of the Research database. What should you do?

You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort. Which development approach and mode...

You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing. What should you do?

You need to configure SSRS to send the required notification messages. Which configuration settings should you use? (Each correct answer presents a partial solution. Choose all tha...

You need to implement the security requirement for the sales representatives. Which MDX expression should you use?

You need to use Reporting Services Configuration Manager to configure SSRS to complete the installation on SSRS02. What should you do? (Each correct answer presents a partial solut...

You need to re-establish subscriptions on SSRS01. What should you do?

You need to design the recovery strategy for SSRS01. What should the strategy include? (Each Answer presents part of the solution. Choose all that apply.)

You need to identify changes in the financial database. What should you do?

You need to create the Package Activity report. What should you do?

You need to implement the aggregation designs for the cube. What should you do?

You need to slice data by the CouponUsed, OnSale, and Closeout columns. What should you do?

You need to design a cube partitioning strategy to be implemented as the cube size increases. What should you do?

You need to choose the appropriate key to use when designing a dimension table based on the Customer table. What should you do?

You need to implement the product dimension. What should you do?