70-467 Practice Questions

You need to scale out SSAS. What should you do?

You need to implement security in the cube to limit the sites visible to each user. What should you do?

You need to implement the aggregation designs for the cube. What should you do?

You need to identify changes in the financial database. What should you do?

You need to select the appropriate storage settings for the cube. Which settings should you choose?

You need to configure a parameter for the database connection string. What should you do?

You need to restrict access to data in the tables in the data warehouse. What should you do?

You need to ensure that managers can successfully run reports. What should you do?

You need to implement a strategy for efficiently storing sales order data in the data warehouse. What should you do?

You need to ensure that you can monitor the usage data. What should you do?

You need to improve the performance of data warehouse queries. What should you do?

You need to create the factCustomerContact table. Which type of table should you create?

You need to configure permissions for the Customers dimension. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

You need to select a method of moving data from the staging tables to the factOrders table. What type of Transact-SQL (T-SQL) statement should you use?

You need to select the appropriate mode for the Sales database. Which mode should you select?

You need to design the dimCustomers table. Which design approach should you use?

You need to select and configure a tool for the monitoring solution. What should you choose?

You need to select the appropriate model type for the Finance database. Which model type should you select?

You need to implement the date dimension in the Operations database. What should you do?

You need to ensure that the Sales Per Capita calculated measure produces correct results. What should you do?

You need to ensure that the corporate logos appear in reports. What should you do?

You need to ensure that queries to the Sales Analysis cube default to the correct time period. Where should you set the default member Multidimensional Expressions (MDX) expression...

You need to ensure that the Sales measure in the Power View field list meets the requirements. What should you do? (Each correct answer presents a part of the solution. Choose all...

You need to identify the reasons that data alert notifications are not being sent. Which of the following reasons are possible? (Each correct answer presents a complete solution. C...

You need to develop the tabular project to support the date analysis requirements. What should you do?

You need to update the Execute SQL task in the OnVariableValueChanged event handler of all SSIS packages. Which additional variable should be logged?

You need to recommend a cube architecture for CUBE1. The solution must meet the performance requirements for CUBE1. Which two partitions should you recommend creating? Each Answer...

You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function." You need to ensure that th...

You need to implement the SalesCommission model to support the planned reports and queries. What should you do?

You need to deploy a solution for the planned self-service reports that will be used by the sales department managers. What is the best solution you should deploy? More than one an...

You need to recommend a partitioning strategy that meets the performance requirements for CUBE1. What should you include in the recommendation?

You need to prepare the infrastructure for the planned implementation of Gallery1. Which three actions should you perform? Each Answer presents part of the solution,

You are deploying the Research model. You need to ensure that the data contained in the model can be refreshed. What should you do?

You need to configure Library1 to support the planned self-service reports. What is the best configuration you should add to Library1? More than one answer choice may achieve the g...

You need to recommend a SQL Server Integration Services (SSIS) package design that meets the ETL requirements. What should you include in the recommendation?

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...

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 i...

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...

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. Th...

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...

You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?

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...

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading. The production en...

You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the r...

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 appli...

You have a text file that contains an XML Schema Definition (XSD). You have a table named Schemal.Table1. You have a stored procedure named Schemal.Proc1 that accepts an XML parame...

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named DimEmployee. The table contains employee details, including the sales ter...

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 o...

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a data model. Which r...

You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?