You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a Microsoft Azure SQL Database database and an OData data feed. The model will be deployed to a server with significantly more memory than the…
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 the model. Which permission should you use? (More than one…
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 of a hierarchy. The City column exists in the…
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 not rebuild hierarchies or relationships. - The processing…
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 the employee dimension table. Two thirds of the dimension data contain…
You are adding dimensions and a new measure group named Accounts Receivable to an existing SQL Server Analysis Services (SSAS) cube. Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group…
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 executed. You discover that the report server execution logs are empty, despite significant…
A 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 Canada allows users to browse data pertaining to Canada.…
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 meet the following requirements: - Queries must be able to…
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 sales from the first month…