Mar 2016 updated: Testking Microsoft 70-466 practice test 106-120

70-466 Royal Pack Testengine pdf

100% Actual & Verified — 100% PASS

Unlimited access to the world's largest Dumps library! Try it Free Today!

Get it now →

Product Description:
Exam Number/Code: 70-466
Exam name: Implementing Data Models and Reports with Microsoft SQL Server 2012
n questions with full explanations
Certification: Microsoft Certification
Last updated on Global synchronizing

Free Certification Real IT 70-466 Exam pdf Collection

Question No. 106

- (Topic 2) 

You need to configure SSRS to meet the maximum number of snapshots requirement. 

What should you do? (Each answer presents a complete solution. Choose all that apply.) 

A. In SharePoint Central Administration, set the System Snapshot Limit option to 5. 

B. In Reporting Services Configuration Manager, set the Limit number of snapshots option to 5. 

C. For each report, set the System Snapshot Limit option to 5. 

D. Use PowerShell to set the System Snapshot Limit option to 5. 

Answer: A,D 


Question No. 107

- (Topic 3) 

You need to configure the SSRS data source. 

What should you do? 

A. Use Windows credentials. 

B. Prompt the user for credentials. 

C. In the data source configuration window, select the Credentials are not required option. 

D. Store the credentials. 

Answer:


Question No. 108

- (Topic 4) 

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings. 

The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows. 

You need to ensure that all rows are available in the cube while minimizing the processing time. 

Which processing option should you use? 

A. Process Index 

B. Process Data 

C. Process Add 

D. Process Default 

E. Process Clear 

F. Process Full 

Answer:


Question No. 109

- (Topic 4) 

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Microsoft Azure SQL Database database. 

The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.) 

You need to ensure that the report displays only a user selected map region. 

Which source of spatial data should you use for the map? 

A. SQL Server spatial query 

B. Map gallery 

C. ESRI shape file 

D. Bing Maps layer 

Answer:


Question No. 110

- (Topic 1) 

You need to recommend a solution to meet the requirements for the Manufacturinglssues.rdl report. 

What is the best solution that you should include in the recommendation? More than one answer choice may achieve the goal. Choose the BEST answer. 

A. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Add a dataset for each parameter created. Configure each parameter to use the values in the dataset. 

B. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer. 

C. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Use the default display for the parameters. 

D. Add a dataset to the report that uses a stored procedure. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer. 

Answer:


Question No. 111

- (Topic 3) 

You need to develop the multidimensional project to meet the requirements of the Excel users. 

What should you do? 

A. Create a separate cube for the executive team so that it contains only the data they want to see. 

B. Create a perspective for the executive team. 

C. Create security roles to restrict access to the executive team. 

D. Create a view for the executive team. 

Answer:


Question No. 112

- (Topic 4) 

A multidimensional SQL Server Analysis Services (SSAS) database will be tested next week. 

During the test period, users will access the database for 30 days. Multidimensional Expressions (MDX) queries generated during the test period must represent the variety of queries that will be used in the production environment. 

After testing completes, you need to implement aggregations for every partition in the solution while minimizing development effort. You need to ensure that the aggregations are optimal. 

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

A. Set up a query log and record all user queries during the test period. After completion of the test, use the Usage Based Optimization Wizard to define aggregations for each partition. 

B. During the test period, identify long-running queries by using SQL Server Profiler. Use those queries to design aggregations by using the DesignAggregations command in XML for Analysis (XMLA). 

C. During the test period, run SQL Server Profiler for 10 minutes every day and record all queries executed in those 10 minutes. Use the Aggregation Design Wizard to design the aggregations. 

D. Develop a SQL Server Integration Services (SSIS) package by using a Script task and then use Analysis Management Objects (AMO) to design the aggregations. 

Answer:


Question No. 113

DRAG DROP - (Topic 4) 

You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server. 

While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of physical memory in the server is insufficient. Additional physical memory cannot be installed in the server. 

You need to configure the server to allow paging to disk by using the operating system page file (pagefile.sys). 

Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 


Question No. 114

- (Topic 4) 

You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging. 

Some users report that they cannot access the server. 

You need to ascertain the IP addresses of the client computers that are accessing the server. 

What should you do? 

A. View the ExecutionLog view in the Report Server database. 

B. View the Report Server service trace log. 

C. View the Report Server HTTP log. 

D. View the Windows System event log. 

Answer:

Explanation: http://msdn.microsoft.com/en-us/library/bb630443.aspx 


Question No. 115

DRAG DROP - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) cube. 

You need to reuse a measure group from a different database. 

In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 


Question No. 116

- (Topic 4) 

You are developing a SQL Server Reporting Services (SSRS) sales summary report. 

The report header consists of several images. Report users require PDF exports of the report with no bulky images of the report header. 

You need to ensure that the header of the report is hidden when a user exports the report to PDF format. 

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

A. Set the Hidden property of the report header to (GlobalslRenderFormat.Name = "PDF"). 

B. Set the Hidden property of the report header to (GlobalslRenderFormat.IsInteractive = False). 

C. Set the Hidden property of the report header to FALSE. 

D. Set the Hidden property of the report header to TRUE. 

Answer:


Question No. 117

- (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams. 

The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model. 

You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort. 

What should you do? 

A. Create a separate partition for each team. 

B. Create a separate data source for each team. 

C. Create a perspective for the sales team. 

D. Enable client side security to filter non-sales data. 

Answer:


Question No. 118

- (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) tabular project. 

You need to grant permission for salespersons to be able to view only the data based on their sales territory. 

What should you do? 

A. Create a member and then create a Multidimensional Expressions (MDX) filter. 

B. Create a member and then create a Data Analysis Expressions (DAX) filter. 

C. Create a role and then create a Multidimensional Expressions (MDX) filter. 

D. Create a role and then create a Data Analysis Expressions (DAX) filter. 

Answer:


Question No. 119

DRAG DROP - (Topic 4) 

You are developing a SQL Server PowerPivot model to monitor the rate of production of defective products. 

The PowerPivot model contains many tables. The FactProduction table is configured as shown in the following diagram. 

The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column. 

The KPI has the following requirements. 

. If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red). . If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow). . If the rate of production of defective products less than 2% then the KPI must report a status of on target (green). 

You need to develop the KPI to meet the requirements. 

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 


Question No. 120

- (Topic 4) 

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM. 

The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. 

You need to ensure the highest query performance and scalability for the accounting department queries. 

Which project type should you choose? 

A. Tabular project that uses the In-Memory query mode 

B. PowerPivot workbook deployed to SharePoint 

C. Tabular project that uses the DirectQuery query mode 

D. Multidimensional project 

Answer: