70-467 Exam Questions - Online Test

70-467 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Want to know Actualtests 70-467 Exam practice test features? Want to lear more about Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server 2012 certification experience? Study Accurate Microsoft 70-467 answers to Most up-to-date 70-467 questions at Actualtests. Gat a success with an absolute guarantee to pass Microsoft 70-467 (Designing Business Intelligence Solutions with Microsoft SQL Server 2012) test on your first attempt.

Q11. 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 able to update shared data sources. . Members of the role must not be able to consume reports or manage subscriptions. . The role must provide only the minimum permissions required. 

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

A. The Content Manager role 

B. The Read and Process role 

C. The Publisher role 

D. The Browser role 

Answer: C 

Q12. 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 prior day's sales data. 

The ETL process for the fact table must meet the following requirements: 

Load new data in the shortest possible time. 

Remove data that is more than 36 months old. 

Minimize record locking. 

Minimize impact on the transaction log. 

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

A. Partition the fact table by date. Insert new data directly into the fact table and delete old data directly from the fact table. 

B. Partition the fact table by customer. Use partition switching both to remove old data and to load new data into each partition. 

C. Partition the fact table by date. Use partition switching and staging tables both to remove old data and to load new data. 

D. Partition the fact table by date. Use partition switching and a staging table to remove old data. Insert new data directly into the fact table. 

Answer: C 

Q13. You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic. 

You have the following requirements: 

. Ensure that queries of the data model correctly display average student age by class and average class level by student. . Minimize development effort. 

You need to design the data model. 

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

A. Create a multidimensional project and define measures and a reference relationship. 

B. Create a tabular project and define calculated columns. 

C. Create a multidimensional project and define measures and a many-to-many dimensional relationship. 

D. Create a tabular project and define measures. 

Answer: C 

Q14. 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 the information contained within them is available to users on demand. 

. Optimize performance. 

You need to redesign the cube dimension to meet the requirements. 

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

A. set the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types. 

B. Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies. 

C. Create user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Run incremental processing. 

D. Remove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement natural hierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural hierarchies. 

Answer: D 

Q15. 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 that apply.) 

A. Format the column to display zero decimal places. 

B. Hide the column from client tools. 

C. Create a measure named Sales based on the column by using the Data Analysis Expressions (DAX) SUM() function. 

D. Rename the column to Sales. 

E. Format the measure to display zero decimal places. 

Answer: AC 

Q16. You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. 

The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy. 

You need to return only the blue products in the Category hierarchy. 

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

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: C 

Q17. You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Set the AttributeHierarchyVisible property to False. 

B. Set the IsAggregatable property to False. 

C. Set the Usage property to Parent. 

D. set the DefaultMember property to the Forecast member. 

E. Set the AttributeHierarchyEnabled property to False. 

F. Set the RootMemberIf property to ParentIsMissing. 

Answer: CD 

Q18. 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 requirements: 

Allow users to easily display and navigate data. 

Minimize report processing time. 

Simplify the report design and maintenance processes. 

You need to design a report that meets the requirements. 

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

A. Retrieve all customers and use drilldown groupings to show or hide hierarchy levels. 

B. Add a report part for each hierarchy level. 

C. Add a subreport for each hierarchy level. 

D. Display only the children of the current hierarchy level and drill through to the selected member. 

Answer: D 

Q19. 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 managers and variables. 

You have the following requirements: 

The deployment model must support changing the content of connection strings by 

using parameters at execution time. 

The deployment model must automatically log events to the SSISOB database. 

Maximize performance at execution time. 

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

A. Use a project deployment model. Modify connection manager properties to use project parameters. 

B. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments. 

C. Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package. 

D. Use a project deployment model. Modify connection manager properties to use package parameters. 

Answer: A 

Q20. You need to ensure that the Sales Per Capita calculated measure produces correct results. 

What should you do? 

A. Set the DataType property of the Population column of the FactPopulation data source view table to System.Int64. 

B. Set the Source DataType property of the Population measure to Biglnt. 

C. Set the data type of the Population column of the FactPopulation data warehouse table to BIGINT. 

D. Set the DataType property of the Population measure to Biglnt. 

Answer: B