DRAG DROP You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process. Several calculated columns have been added to…
HOTSPOT 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…
DRAG DROP You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data source that is configured to use credentials that are…
DRAG DROP You are developing a SQL Server Analysis Services (SSAS) multidimensional project. You identify that a dimension, which has a large number of attributes, is issuing a separate (SELECT DISTINCT) query for each attribute even though they all come…
HOTSPOT You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings. The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and…
DRAG DROP You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a Microsoft Azure SQL Database database. The cube is processed each night at midnight. The largest partition in the cube…
DRAG DROP You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server. While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of physical memory in the server…
You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance. The application generates all T-SQL statements dynamically and does not use stored procedures.…
You plan to design an application that temporarily stores data in a SQL Azure database. You need to identify which types of database objects can be used to store data for the application. The solution must ensure that the application…
You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored procedures or user-created functions. You need to minimize the amount of memory used for query plan caching. Which advanced server option…