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 flexible queries. You need to choose the connection type for the…
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 Microsoft Azure SQL Database database. The report must use a…
You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year Month Number, and InvCount. The report includes a table that displays the inventory count per year, as shown in the following…
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 configured to deliver reports through email by using a shared schedule. The email server will…
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 dimension. What should you do? A. Write a Multidimensional Expressions (MDX)…
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, logon ID, and assigned sales territory. You need to ensure that each salesperson…
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 tabular model. Which role permission should you use? A. Explorer B. Select C.…
You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft Azure SQL Database database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product and Revenue. The model…
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 appropriate query mode. Which query mode should you select? A. DirectQuery with In-Memory…
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 a data warehouse fact table and consists of a single…