70-467 Exam Questions - Online Test

70-467 Premium VCE File

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

Certified of 70-467 exam topics materials and practice exam for Microsoft certification for IT specialist, Real Success Guaranteed with Updated 70-467 pdf dumps vce Materials. 100% PASS Designing Business Intelligence Solutions with Microsoft SQL Server 2012 exam Today!

Q1. You need to configure SSRS to send the required notification messages. 

Which configuration settings should you use? (Each correct answer presents a partial solution. Choose all that apply.) 

A. <SendUsing>2</SendUsing> 

B. <SendUsing>contoso.com</SendUsing> 

C. <SMTPServer>SMTP01/SMTPServer> 

D. <SMTPServerPort>110</SMTPServerPort> 

E. <SMTPServer>SSRS01/SMTPServer> 

F. <From>reports@contoso.com</From> 

G. <PermittedHosts>contoso.com</PermittedHosts> 

Answer: ACF 

Q2. 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. Their report assignments come from various departments within the organization. 

The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode. After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables. 

You are designing the data access strategy. You have the following requirements: 

. Ensure that report writers can create only reports that display data which they have database permissions to view. . Minimize the effort required to update connection strings for all reports developed by the report writers. . Minimize the number of fields visible in a specific report for report writers who work for multiple departments. 

You need to design the data access strategy. 

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

A. Create report models by using SQL Server Data Tools (SSDT). Include data sources and data source views for each department's data requirements. Configure each data source to use integrated security. 

B. Create one shared data source that uses integrated security. Create an embedded dataset for each report. 

C. Create one shared data source that uses integrated security. Create one shared dataset that includes all tables required by the report writers. 

D. Create one shared data source that uses integrated security. Create a shared dataset for each department's data requirements. 

Answer: D 

Q3. You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort. 

Which development approach and mode should you use? 

A. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to DirectQuery. 

B. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to In-Memory with DirectQuery. 

C. Develop a multidimensional project and configure the model with the DirectQuery mode setting off. 

D. Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage mode. 

Answer: B 

Q4. 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 archived 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 archived data. 

You need to create a fully automated solution to ensure that reports do not deliver archived data. 

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

A. 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 archive process completes. 

B. Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to truncate the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the archive process completes. 

C. Create a SQL Server Agent job that restarts the SQL Server Reporting Services service. Schedule the job to run every day after the archive process completes. 

D. Create a shared schedule. Configure the datasets to expire on the shared schedule. 

Answer: A 

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

Q6. You need to create the Sales Reporting shared SSR5 data source. 

Which SSRS data connection type should you use? 

A. OData 

B. Microsoft SQL Server 

C. ODBC 

D. OLE DB 

Answer: C 

Q7. You need to choose the appropriate key to use when designing a dimension table based on the Customer table. 

What should you do? 

A. Use a surrogate key. 

B. Use a natural key. 

C. Use the CustomerNumber column as the key. 

D Concatenate the CustomerName and CustomerNumber columns and use the concatenated string as the key. 

D. Use the CustomerName column as the key. 

Answer: A 

Q8. You need to implement a strategy for efficiently storing sales order data in the data warehouse. 

What should you do? 

A. Separate the factOrders table into multiple tables, one for each month that has orders, and use a local partitioned view. 

B. Separate the factOrders table into multiple tables, one for each day that has orders, and use a local partitioned view. 

C. Create daily partitions in the factOrders table. 

D. Create monthly partitions in the factOrders table. 

Answer: C 

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

A. In SharePoint Central Administration, enable usage data collection. 

B. In the PowerPivot Configuration Tool, repair PowerPivot for SharePoint. 

C. In the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint. 

D. In Reporting Services Configuration Manager, enable report execution logging. 

Answer: A 

Q10. 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 contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B. Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M. 

. You have the following requirements:Refresh the PowerPivot workbook with updated lookup data as soon as possible. . Minimize load on the source systems and the SharePoint environment during business hours. . Minimize user involvement in the data refresh process. 

You enable automatic data refresh for the workbook. 

You need to configure a data refresh schedule for the workbook that meets the requirements. 

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

A. Power View 

B. Report Designer 

C. Report Builder 

D. PerformancePoint Services 

Answer: A