70-467 Practice Questions
127 real 70-467 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #140
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the...
- Question #141
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...
- Question #142
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 hav...
- Question #144
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 contain...
- Question #151
You have an application that uses a view to access data from multiple tables. You need to ensure that you can insert rows into the underlying tables by using the view. What should...
- Question #156
The IT department is currently upgrading all SQL Server Integration Services (SSIS) packages to SSIS 2012. The final version of a complex SSIS 2005 package has been overwritten. Fo...
- Question #159
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 contain...
- Question #160
You are designing a reporting solution that uses SQL Server Reporting Services (SSRS) in SharePoint integrated mode. The reporting solution must meet the following requirements: -...
- Question #161
You deploy a PowerPivot workbook to a document library in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B. The workbook contains...
- Question #162
You need to design a data warehouse schema to support a multidimensional cube. The fact table will contain multiple columns representing order dates, shipping dates, and billing da...
- Question #163
You are creating a product dimension table and a SQL Server Integration Services (SSIS) package that will load the table. You need to keep a history in the table of changes to the...
- Question #164
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 p...
- Question #165
You have a data warehouse named DW1. An OLAP cube named Cube1 uses DW1 as its data source. Cube1 uses the MOLAP storage mode. You create a SQL Server Integration Services (SSIS) pa...
- Question #166
The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data....
- Question #167
You are creating a calculated measure in a sales cube by using a Multidimensional Expressions (MDX) calculation. The cube includes a date dimension. The date dimension has a hierar...
- Question #168
You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data. Customer dimension attributes will c...
- Question #169
You have two servers named Served and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog. You are preparing a...
- Question #170
A company has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube na...
- Question #171
You are designing a self-service reporting solution based on published PowerPivot workbooks. The reporting solution must allow users to perform the following tasks: - Easily create...
- Question #172
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 schedule...
- Question #173
A hospital has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube n...
- Question #174
Your network contains the following components: - Microsoft SharePoint Server 2010 - SQL Server 2008 Service Pack 2 (SP2) - SQL Server 2008 Service Pack 1 (SP1) in Reporting Servic...
- Question #175
You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint 2010 farm. You need to upgrade to SSRS 2014 with the minimum downtime and hardw...
- Question #176
You are designing a partitioning strategy for a SQL Server Analysis Services (SSAS) cube. New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 mi...
- Question #187
You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on...
- Question #188
A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product. The DimProduc...
- Question #416
You have a SQL Server 2012 database named DB1. You have a backup device named Device1. You discover that the log file for the database is full. You need to ensure that DB1 can comp...