70-466 Practice Questions

You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity. YTD sales quantity values are classified in th...

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 working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server. The Reports Writer role cannot view...

You are developing a SQL Server Analysis Services (SSAS) cube. The cube consists of a single measure group. The measure group consists of one partition that uses MOLAP. The proacti...

You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging. Some users report that they cannot acc...

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and RegCount. The report includes a table that...

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database. The report must display the value and status of a Key Performance Indic...

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 developing a SQL Server Analysis Services (SSAS) cube. The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuant...

MISSING STEM for Question 10. The options describe actions.

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

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution. You need to grant permission for salespersons to view only the data based on the...

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 deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named D...

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). The report must define a report parameter to prompt the user for the business...

You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube. Date is one of the existing dimensions in the SSAS...

You need to configure the appropriate query mode. Which query mode should you select?

You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade to the instance to SQL Server 2014. You need to import an existing PowerPivot wo...

You are designing a dimension named Employee for a SQL Server Analysis Services multidimensional project. The Employee dimension contains a DateOfBirth attribute and a MaritalStatu...

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database. You have identified a dimension that is no longer used by any cubes. You need to delete the dimen...

SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Can...

You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server. While processing a very large tabular model, you receive an out-of-memory error. You identif...

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography. The DimGeogra...

You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database. The ProcessingOption property for the project is set to Do Not Process. Seve...

You develop a SQL Server Analysis Services (SSAS) stored procedure. You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the store...

You are modifying a SQL Server Analysis Services (SSAS) cube. Users in the cube report that the precision for the TransactionCost measure is five digits. You need to ensure that th...

You execute the following code: CREATE TABLE dbo.Customers ( id int PRIMARY KEY, CustomerName char(10) ) You create a nonclustered index named IX_CustomerName on the CustomerName c...

You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You need to implement a time di...

You have a SQL Server Analysis Services (SSAS) database named DB1 on a server named Server1. You need to deploy DB1 from Server1 to four other servers. If the destination server al...

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financia database. The model will be deployed to a ser...

You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache. You need to configure the appropri...

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 must be p...

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 that will be used by the finance, sales, and marketing teams. The sales team reports that the model is too...

You are developing a SQL Server PowerPivot workbook that sources data from a SQL Azure database. The PowerPivot model includes a single table named FactSales that consists of four...

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 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 designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson. The cu...

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

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and InvCount. The report includes a table that...

You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a dat...

You are planning the installation of PowerPivot for SharePoint. You install SharePoint Server 2010 Enterprise Edition with Service Pack 1. You need to install the PowerPivot for Sh...

Which three actions should you perform in sequence to install and configure the SharePoint farm? (To answer, move the appropriate actions from the list of actions to the answer are...

You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?

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 are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following...

You are conducting a design review of a multidimensional project. In the geography dimension, all non-key attributes relate directly to the key attribute. The underlying data of th...

You have a cube named Cube1 that contains the sales data for your company. You plan to build a report based on the cube. You need to write an MDX expression that returns the total...

You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will be deployed to a server...

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