web analytics

How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day. You define a connection. You need to

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

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

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

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.

You need to grant the minimum permissions necessary to enable users to query data in a tabular model. Which role permission should you use?

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

Which data access strategy should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

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

You need to hide the tables and columns. What should you do?

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

You need to ascertain the memory consumed by each object in the SSAS instance. What should you do?

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

What should you do before the partition can be write-enabled?

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

You need to implement a time dimension. What should you do?

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

Users of the cube report that the precision for the SalesAmount measure is four digits. You need to ensure that the SalesAmount measure stores values to two digits of precision. What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube. Users of the cube report that the precision for the SalesAmount measure is four digits. You need to ensure that

You need to use an appropriate project type. Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

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

You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?

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

You need to ensure that the cube meets the requirements while optimizing query response time. What should you do? (Each answer presents a complete solution. Choose all that apply.)

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 of customers

You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level. What should you do?

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

You need to create a measure to count unique customers. What should you do?

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

You need to create a measure that calculates the quantity in stock value. 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 MovementQuantity

You need to create a dimension to allow users to view and compare data by scenario. What should you do?

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. A fact table is related to a dimension table named DimScenario by a column named ScenarioKey. The dimension table

You need to ensure that the Reports Writer role can view and modify report caching parameters. What should you do?

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

Which two actions should you perform? Each correct answer presents part of the solution.

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 use the

Which task should you add to the Folder Access Controller role?

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 consists

You need to restore a copy of the symmetric key. Which command should you run?

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run? A. rskeymgmt -d B. rskeymgmt -e -f %temp%\rs.key

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

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

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

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

You need to include additional data sourced from a Microsoft Azure SQL Database in the report. What should you do?

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 need to choose the connection type for the data source. Which connection type should you choose?

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

You need to temporarily suspend the shared schedule until the email server is brought back online. What should you do?

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

You need to delete the dimension. What should you do?

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.

You need to ensure that the model has the most recent data while minimizing the processing time. What should you do?

You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database. In the data source, the FactInternetSales table is partitioned by month. Data from

Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)

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 use? (Each correct

Which event class should you use?

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 identify the

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project. In the data warehouse, a table named Sales Persons and Territories defines a relationship between a salesperson’s name, logon

You need to grant the minimum permissions necessary to enable users to query data in a data model. Which role permission should you use?

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

You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort. What should you do?

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

You need to implement a processing strategy for the database to meet the requirements. Which processing mode should you use?

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 tables. The processing must

You need to add the City column to the Customer table. How should you write the calculation?

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

Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are administrating 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

You need to implement a solution that meets the requirements. What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column. The Sales table must

What should you use? More than one answer choice may achieve the goal. Select the BEST answer.

You are creating 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