web analytics

You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection

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

You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B. The workbook contains five

How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members. You have the following

You need to create a fully automated solution to ensure that reports do not deliver purged data. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS) in native mode. Reports are based on data that is cached in multiple shared datasets. Source data

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

A group of report writers develop reports. The report writers currently use Report Builder 1.0 and report models. The report writers are not trained on SQL Server query writing. Their

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

You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time.

You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet- facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured. You need

You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection

You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You have the following

You need to design the fact table to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a fact table in a SQL Server database. The fact table must meet the following requirements: Include a columnstore index. Allow users to choose up to 10

You need to design a MOLAP cube that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a multidimensional OLAP (MOLAP) cube. The MOLAP cube must meet the following requirements: Ensure that workloads for aggregation tuning can be automatically collected. Require the least amount

You need to design an ETL process that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing an extract, transform, load (ETL) process for loading data from a SQL Azure database into a large fact table in a data warehouse each day with the

Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day. You have the

Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse. Tens of millions of new inventory fact records are loaded into the data warehouse

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

An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements: Implement drill-down browsing. Reduce the number of attribute hierarchies but ensure that

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

You are modifying a star schema data mart that feeds order data from a SQL Azure database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two

You need to design an ETL process that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing an extract, transform, load (ETL) process for loading data from a SQL Server database into a large fact table in a data warehouse each day with the

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

You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of

You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection

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

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS). Many of the SSRS reports will use common utilities and functions, including the

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

You administer a SQL Server Reporting Services (SSRS) instance in native mode. You need to assign a predefined role that meets the following requirements: Members of the role must be

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

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which

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

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedules and report formats. You