70-460 Exam Questions

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 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 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 designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading. The production en...

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named DimEmployee. The table contains employee details, including the sales ter...

You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The column will be used in the definition o...

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to the user. The columns and tables cannot be...

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

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube. A user reports that a Multidimensional Expressions (MDX) query is very slow. You need to i...

You are creating a new report in SQL Server Report Builder. You add a SQL Azure data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales. Y...

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube contains a Key Performance Indicator (KPI) to show if...

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands...

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report lay...

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQ...

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company. The sales department requires the following set of metrics: - Unique count o...

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLA...

You are creating a SQL Server Analysis Services (SSAS) cube. You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It...

You are creating a SQL Server Analysis Services (SSAS) multidimensional database. Users need a time dimension for: - Dates - Delivery dates - Ship dates You need to implement the m...

You are designing a SQL Server Analysis Services (SSAS) cube. You need to create a measure to count unique customers. What should you do?

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 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 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 modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains...

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing...

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 grant appropriate permissions to the SSISOwners SQL Server login. What should you do?

You need to define the trend calculation for the sales performance KPI. Which KPI trend MDX expression should you use?

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

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 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 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 re-establish subscriptions on SSRS01. What should you do?

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 select the appropriate storage settings for the cube. Which settings should you choose?

You need to implement the aggregation designs for the cube. 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 implement security in the cube to limit the sites visible to each user. What should you do?

You need to scale out SSAS. What should you do?

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

You need to restrict access to data in the tables in the data warehouse. What should you do?

You need to select the appropriate storage settings for the cube. Which settings should you choose?

You need to configure a hierarchy for DimProduct that meets the technical requirements. What should you do?

After you deploy the RegionalSales report, you attempt to configure the subscriptions. You discover that the subscription creation screen does not display the option to deliver the...

After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email. You need to ensure that the sales department manag...

You need to recommend a solution for the sales department that meets the security requirements. What should you recommend?

You need to ensure that all reports meet the reporting requirements. What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST ans...

You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function." You need to ensure that th...

You are deploying the Research model. You need to ensure that the data contained in the model can be refreshed. What should you do?