EnsurepassQUESTION 161 HOTSPOT 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
EnsurepassQUESTION 151 You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment. The production database has been configured
EnsurepassQUESTION 141 You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to
EnsurepassQUESTION 131 You are conducting a design review of a multidimensional project. In the Customer Geography dimension, all non-key attributes relate directly to the key
EnsurepassQUESTION 121 You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure
EnsurepassQUESTION 111 You are modifying a SQL Server Analysis Service (SSAS) cube. The cube consist of a single measure group that contains the following
EnsurepassQUESTION 101 A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data.
EnsurepassQUESTION 91 You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft Azure SQL Database database. The PowerPivot model includes a
EnsurepassQUESTION 81 You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You
EnsurepassQUESTION 61 You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?
EnsurepassQUESTION 51 DRAG DROP You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption
EnsurepassQUESTION 41 You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to