70-466 Practice Questions

You are developing a SQL Server Analysis Services (SSAS) cube. You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measu...

You are developing a SQL Server Analysis Services (SSAS) cube. You need to add a calculated member to the Customer dimension to evaluate the sum of values for France and Germany. W...

You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department. You create a measure group named Exchange Rate that consists of measures pertaining to cu...

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 using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube. You need to compute the aggregate value of the 10 most-ordered produces in the...

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. T...

You are modifying a SQL Server Analysis Service (SSAS) cube. The cube consist of a single measure group that contains the following measures: - Total Quantity On Hand - Average Qua...

You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset. You need to include additional data sourced from a...

You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are config...

You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the...

You manage a SQL Server Reporting Services (SSRS) instance running in native mode. You are troubleshooting a performance problem and need to know which reports are frequently execu...

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 are stored in a S...

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 are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server. The Folder Access Controller role c...

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

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support ro...

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modif...

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant permission for salespersons to be able to view only the data based on their sales territ...

You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data sou...

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database. You plan to use multiple servers to p...

You manage a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance. The application generat...

You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the...

You plan to design an application that temporarily stores data in a SQL Azure database. You need to identify which types of database objects can be used to store data for the appli...

You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored procedures or user-created functions. You need to minimize...

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance. You need to ascertain the memory consumed by each object in the SSAS...

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings. The model has one cube and the cube has one measure group. The...

You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The project will be deployed to a SSAS server that has 16 GB of RAM. The project will source data...

You need to create the KPI in the AdhocReports project. What should you do?

You need to deploy the StandardReports project. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

You need to deploy the StandardReports project at the end of the current business day. What should you do? (Each correct answer presents a complete solution. Choose all that apply....

You need to create the hierarchy in the AdhocReports project. What should you do?

You need to identify the reports that produce the errors that Marc is receiving. What should you do?

You need to create the KPI in the AdhocReports project in time for the next production release cycle. What should you do?

You need to ascertain why Marc did not receive his reports. What should you do?

You need to create the data source view for the StandardReports project. What should you do?

You need to create the sales territory and product measures. Which aggregate function should you use for both measures?

You need to create a measure for DOD sales. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

You need to develop the multidimensional project to meet the requirements of the Excel users. What should you do?

You need to configure the permissions for the sales team members in the Sales Reports library. Which permissions should you use? (Each answer presents part of the solution. Choose...

You need to configure the SSRS data source. What should you do?

Drag and drop question. You need to optimize the Regions dimension. How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list o...

You need to develop the executive reports. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?

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

You need to configure per-user security authentication for reporting against the Sales cube. What should you do? (Each correct answer presents part of the complete solution. Choose...

You need to modify the Sales cube to support the planning requirements. Which SSAS feature should you use?

You need to configure the UserRegions role. Which Multidimensional Expressions (MDX) function should you use?

You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?

You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

You need to create the AD Sales measure. Which aggregation function should you use?