70-467 Exam Questions - Online Test

70-467 Premium VCE File

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

Pass4sure offers free demo for 70-467 exam. "Designing Business Intelligence Solutions with Microsoft SQL Server 2012", also known as 70-467 exam, is a Microsoft Certification. This set of posts, Passing the Microsoft 70-467 exam, will help you answer those questions. The 70-467 Questions & Answers covers all the knowledge points of the real exam. 100% real Microsoft 70-467 exams and revised by experts!

Q21. You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing. 

What should you do? 

A. Restore the SSAS databases from the latest backup to SSAS01. 

B. Script the databases as a Create script to a new window and then execute the script on SSAS01. 

C. Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01. 

D. Use the Import/Export Wizard to copy the databases from the production server to the development server. 

Answer: A 

Q22. You need to configure package execution logging to meet the requirements. What should you do? 

A. Configure logging in each ETL package to log the OnError, Onlnformation, and Diagnostic events. 

B. Set the SSIS catalog's Server-wide Default Logging Level property to Performance. C set the SSIS catalog's Server-wide Default Logging Level property to Basic. 

C. Set the SSIS catalog's Server-wide Default Logging Level property to Verbose. 

D. Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events. 

Answer: B 

Q23. You need to design the dimCustomers table. 

Which design approach should you use? 

A. Reference dimension 

B. Type 2 slowly changing dimension 

C. Junk dimension 

D. Conformed dimension 

E. Type 1 slowly changing dimension 

Answer: B 

Q24. You need to identify changes in the financial database. 

What should you do? 

A. Add SQL Server replication to each table. 

B. Extract data from the current partition of each table. 

C. Add a timestamp column to each table. 

D. Perform a full extract of each table. 

E. Enable change data capture on each table. 

Answer: E 

Q25. You need to select and configure a tool for the monitoring solution. 

What should you choose? 

A. Performance Monitor configured with the MSAS11:Storage Engine Query counter 

B. Performance Monitor configured with the MSAS11:Processing counter 

C. SQL Server Profiler configured with the Query Processing: Query Subcube event 

D. SQL Server Profiler configured with the Queries Events: Query Begin event 

Answer: D 

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

Q27. You need to select the appropriate storage settings for the cube. 

Which settings should you choose? 

A. Relational OLAP (ROLAP) with proactive caching enabled 

B. Multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours 

C. Hybrid OLAP (HOLAP) with proactive caching disabled 

D. Hybrid OLAP (HOLAP) with proactive caching enabled 

Answer: C 

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

A. Use the CREATE CACHE statement. 

B. Use the Aggregation Design Wizard. 

C. Create relational indexes on the source tables. 

D Use the Usage-Based Optimization Wizard. 

Answer: B 

Q29. 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 of effort to perform manual aggregation tuning. 

Minimize impact on the performance of previously tuned queries. 

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

A. Enable SQL Server Analysis Services (SSAS) query logging. Run the Usage-Based Optimization Wizard to generate aggregations. Merge the wizard results with existing aggregation designs. 

B. Set up multiple partitions. Run the Aggregation Design Wizard periodically for each measure group. After the wizard finishes, discard the old aggregation design and accept the new one. 

C. Set up multiple partitions. Run the Aggregation Design Wizard on each partition. Schedule the aggregations by using an XMLA script in SQL Server Agent. 

D. Set the AggregationUsage property of all attributes based on natural keys to Full. 

Answer: A 

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

A. Back up the cube on ServerB and restore it on ServerC each day. 

B. Create an empty cube on ServerC and link to the objects in the cube on ServerB. 

C. Process the cube on both ServerB and ServerC each day. 

D. Synchronize the cube from ServerB to ServerC each day. 

Answer: D