70-467 Exam
All About 70-467 dumps Mar 2021
we provide Practical Microsoft 70-467 exam which are the best for clearing 70-467 test, and to get certified by Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server 2012. The 70-467 Questions & Answers covers all the knowledge points of the real 70-467 exam. Crack your Microsoft 70-467 Exam with latest dumps, guaranteed!
Q41. 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. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.
A. Use the Usage-Based Optimization Wizard to create aggregations for the current partitions.
B. Use the Aggregation Design Wizard to create aggregations for the current partitions.
C. Combine all the partitions into a single partition. Use the Usage-Based Optimization Wizard to create aggregations.
D. Combine all the partitions into a single partition. Use the Aggregation Design Wizard to create aggregations.
Answer: C
Q42. 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 requirements:
Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.
Ensure that users can generate the exception report in an XML format.
Use the minimum development effort.
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.)
A. Use a Data Profiling task. Use a Data Flow task to extract the XML output of the Data Profiling task into a SQL Server table. Query the table to view the exceptions.
B. Use Data Flow tasks to process the clean data.
C. Use a Data Profiling task. Read the exceptions in Data Profile Viewer.
D. Design a stored procedure that examines data for common dirty data patterns. Use an Execute SQL task.
Answer: C
Q43. 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 is purged each day at midnight for regulatory compliance purposes. The shared datasets may continue to cache data that should not be used in reports. Shared report schedules are often paused during nightly server maintenance windows.
Reports must not return purged data.
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. Create a shared schedule. Configure the datasets to expire on the shared schedule.
B. Write a script that calls the flushcache method to clear individual items from the SSRS cache. Create a SQL Server Agent job that runs rs.exe with the script as an input file, and schedule the job to run every day after the purge process completes.
C. Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to delete the data from the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the purge process completes.
D. Republish the cached datasets by using SQL Server Data Tools.
Answer: B
Q44. You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy.
You need to return only the female customers in the Geography 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: A
Q45. 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?
A. In the DefaultMember property of the Month attribute of the Date dimension.
B. In the cube's calculation script.
C. In the DefaultMeasure property of the cube.
D. In the Analysts role.
Answer: B
Q46. You need to select an appropriate tool for creating the Regional Sales report.
Which tool or tools should you use? (Each correct answer presents a complete solution. Choose all that apply.)
A. Excel 2010, using the CUBE functions
B. Power View, using a Matrix
C. Excel 2010, using a PivotTable
D. Report Builder, using a Matrix
Answer: BC