70-466 Practice Questions

You need to meet the browsing requirements for the Products hierarchy. Which property should you modify?

You need to configure the format of the Sales Total measure. Which value should you use for the FormatString property?

You need to select a storage mode for each measure group. The solution must meet the following requirements: - The measure group contains a low data volume. - Queries that use the...

You need to define a relationship type for the dimension. Which relationship type should you select? (To answer, configure the appropriate option or options in the dialog box in th...

The Research and Development team has requested that capabilities be added to the database. The capabilities must meet the following requirements: - A device member must be able to...

You work in the Business Intelligence (BI) department of a multinational company. The company has requested a new corporate BI solution that meets the following requirements: - The...

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on...

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1. Table is in...

A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance i...

You manage a SQL Server Reporting Services (SSRS) instance. An application must pass credentials to the local security authority for Reporting Services. You need to configure Repor...

FactInternetSales table, in the DimProduct table, and in the DimCustomer table. In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the...

You are designing a SQL Server Analysis Services (SSAS) cube based on a Windows Azure SQL Database data warehouse. You need to implement a degenerate dimension. What should you do?

A sales cube contains two years of data. The sales team must see year-over-year (YOY) and month-over-month (MOM) sales metrics. You need to modify the cube to support the sales tea...

You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named...

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server 2012 relational database each day. You used to configure Reporting...

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to define a measure named Profit and include a table named Date. The table includes year, semeste...

You have a SQL Server 2012 database named DB1. You have a backup device named Device1. You discover that the log file for the database is full. You need to ensure that DB1 can comp...

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 developing a SQL Server Analysis Services (SSAS) tabular project. You need to add a calculated column to a table in the model. Which three actions should you perform in seq...

You have an application that uses a view to access data from multiple tables. You need to ensure that you can insert rows into the underlying tables by using the view. What should...

You are created a table named Orders. You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the ro...

You are administering a SQL Server Analysis Services (SSAS) tabular database. You need to create a new role that allows its members to query data and to refresh data in the model....

You are developing a SQL Server Analysis Services (SSAS) tabular project. In the data warehouse, a table named Employee Security defines a relationship between a salesperson's name...

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. You need to ensure that the header of the report is hi...

Hotspot Question You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table. In a report table showing sales by countri...

Drag and Drop Question You are making changes to a cube named Sales. You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the...

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

You need to configure the dataset for the ManufacturingIssues report. The solution must meet the technical requirements and the reporting requirements. What should you do?

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 need to configure a hierarchy for DimProduct that meets the technical requirements. What should you do?

You need to recommend a solution to meet the requirements for the ManufacturingIssues.rdl report. What is the best solution that you should include in the recommendation? More than...

You need to modify the environment before you create the QuarterSales report. What should you do?

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

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

Hotspot Question. You create a new SharePoint site to store reports for the manufacturing department. You need to recommend a solution to meet the security requirements for the sal...

You are managing a SQL Server Analysis Services (SSAS) tabular database. The database must meet the following requirements: - The processing must load data into partitions or table...

You maintain SQL Server Analysis Services (SSAS) instances. You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm. Which tool should you...

You are developing a SQL Server Reporting Services (SSRS) report for a company that has a subscription to a dataset from the Microsoft Azure Data Market. The dataset permits textbo...

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 have a SQL Server Reporting Services (SSRS) instance. The instance has a report that displays 3 million records. Users report that they experience performance issues when they...

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. Report users require PDF exports of the report with no...

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). The report contains tables, images, charts, page breaks, gauges, and indicator...

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. You identify a problem with the operations performed by the Report Server Web service. You...

You create a materialized reference dimension between a dimension named Regions and a measure group named Orders. You use a table named Customers as a bridge in shown in the exhibi...

A multidimensional SQL Server Analysis Services (SSAS) database will be tested next week. During the test period, users will access the database for 30 days. Multidimensional Expre...

You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company. The sales department has the following requirements for the cube: - Include a...

You are developing a SQL Server Analysis Services (SSAS) cube. You must create a four-level hierarchy for the employee dimension. Each level must be associated with an attribute in...

You are adding dimensions and a new measure group named Accounts Receivable to an existing SQL Server Analysis Services (SSAS) cube. Data is one of the existing dimensions in the S...

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dime...

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting. A SQL Server Analysis Serv...