[Free] Get all latest Microsoft 70-467 Actual Tests 161-170

Ensurepass

QUESTION 161

You have two servers named Served and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog. You are preparing a disaster recovery plan for a business intelligence (BI) solution. You need to ensure that the SSIS catalog from Server1 can be restored to Server2. Which two actions should you perform on Server1? Each correct answer presents part of the solution.

 

A.

Back up the master database.

B.

Run sp.configure ‘clr enabled’, 0.

C.

Back up the master key of the SSISDB database.

D.

Back up the master key of the master database.

E.

Back up the SSISDB database.

F.

Run sp_configure ‘clr enabled’, 1.

 

Correct Answer: CE

 

 

QUESTION 162

DRAG DROP

Your network contains a development environment, a staging environment, and a production environment.

 

You have a SQL Server Integration Services (SSIS) project. All of the packages in the project load data from files in a shared network folder. The packages use indirect XML configurations to set the location of the network folder.

 

The project is deployed to the three environments. Each environment has a different set of source files and a different network folder for the source files.

 

Currently, if an environment variable is missing, the package will use the network folder specified in the package, not the folder specified in the XML configuration file.

 

You need to ensure that each time a package is executed, the network folder location specified in the package is NOT used.

 

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.

 

clip_image002

 

Correct Answer:

clip_image004

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 163

A company has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Sales. Shared data sources exist in SSRS for the relational and SSAS databases. Each company department has its own report writers.

 

Report writers in the Marketing department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Sales cube. The custom formula will compare time periods across multiple products, categories, and regions.

 

You have the following requirements:

 

clip_image006Ensure that only Marketing department report writers can access the custom formula.

clip_image006[1]Implement only one dataset.

clip_image006[2]Ensure that the dataset references the data source that will provide the fastest data retrieval.

 

You need to meet the requirements to support the Marketing department report writers.

 

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

 

A.

Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes a calculated member for the custom formula.

B.

Create a calculated member in the Sales cube. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes the calculated member from the cube.

C.

Create and secure in the data warehouse a stored procedure that implements the custom formula.

Create and deploy a shared dataset that references the data warehouse shared data source.

D.

Create, deploy, and secure a shared dataset that references the data warehouse shared data source and includes custom Transact-SQL (T-SQL) code for the custom formula.

 

Correct Answer: B

 

 

QUESTION 164

You are designing a self-service reporting solution based on published PowerPivot workbooks.

 

The reporting solution must allow users to perform the following tasks:

 

clip_image006[3]Easily create reports.

clip_image006[4]Create report queries by dragging and dropping fields.

clip_image006[5]Create presentation-quality reports with minimal effort.

 

You need to choose a reporting tool that meets the requirements.

 

Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Report Builder

B.

Report Designer

C.

Power View

D.

Microsoft Excel

 

Correct Answer: C

 

 

QUESTION 165

HOTSPOT

A school stores information about teachers, students, classes, and enrollments in a Microsoft Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.

 

Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.

 

You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.

 

You need to ensure that the report displays the correct class enrollment data.

 

Which item should you configure?

 

To answer, select the appropriate item in the answer area.

 

clip_image007

 

Correct Answer:

clip_image008

 

 

QUESTION 166

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedules and report formats. You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Create a standard SSRS subscription for each record in the table.

B.

Create a data-driven SSRS subscription for each record in the schedule table.

C.

Create a standard SSRS subscription for each subscription schedule.

D.

Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.

 

Correct Answer: D

Explanation:

http://technet.microsoft.com/en-us/library/ms187066(v=sql.105).aspx

 

 

QUESTION 167

DRAG DROP

You are configuring an Excel Services service application in a Microsoft SharePoint farm.

 

Users will deploy Excel workbooks to SharePoint libraries that allow interaction with PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.

 

You need to ensure that users can refresh the PivotTables from within Excel Services without a warning message appearing.

 

What should you do?

 

To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Use only terms that apply.)

 

clip_image010

 

Correct Answer:

clip_image012

 

 

QUESTION 168

A hospital has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Pharmacy. Shared data sources exist in SSRS for the relational and SSAS databases. Each hospital department has its own report writers.

 

Report writers in the Human Resources (HR) department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Pharmacy cube. The custom formula will compare time periods across multiple products, categories, and employees.

 

You have the following requirements:

 

clip_image006[6]Ensure that only the HR department report writers can access the custom formula.

clip_image006[7]Implement only one dataset.

clip_image006[8]Ensure that the dataset references the data source that will provide the fastest data retrieval.

 

You need to meet the requirements to support the HR department report writers.

 

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

 

A.

Create, deploy, and secure a shared dataset that references the data warehouse shared data source and includes custom Transact-SQL (T-SQL) code for the custom formula.

B.

Create a calculated member in the Pharmacy cube.

Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes the calculated member from the cube.

C.

Create and secure in the data warehouse a stored procedure that implements the custom formula.

Create and deploy a shared dataset that references the data warehouse shared data source.

D.

Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes a calculated member for the custom formula.

 

Correct Answer: B

 

 

QUESTION 169

HOTSPOT

You are developing a SQL Server Reporting Services (SSRS) solution.

 

You plan to create reports based on the results of a currency exchange SOAP web service call.

 

You need to configure a shared data source.

 

Which data source type should you use?

 

To answer, select the appropriate type from the drop-down list in the answer area.

 

clip_image013

 

Correct Answer:

clip_image014

 

 

QUESTION 170

Your network contains the following components:

 

clip_image006[9]Microsoft SharePoint Server 2010

clip_image006[10]SQL Server 2008 Service Pack 2 (SP2)

clip_image006[11]SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode

 

You need to recommend a solution to upgrade the network to SQL Server 2014.

 

The solution must meet the following requirements:

 

clip_image006[12]Minimize the amount of time that SharePoint services are unavailable.

clip_image006[13]Deploy the upgraded Reporting Services instance in Reporting Services SharePoint Integrated Mode.

 

You upgrade the Database Engine to SQL Server 2014.

 

Which three actions should you recommend performing next? Each correct answer presents part of the solution.

 

A.

Install a SQL Server 2014 Reporting Services add-in for SharePoint on all of the front- end Web servers that have SharePoint Server installed.

B.

Perform an in-place upgrade to SQL Server Reporting Services (SSRS) 2014.

C.

Perform a SharePoint 2013 side-by-side upgrade.

D.

Perform a SharePoint 2013 in-place upgrade.

E.

Migrate legacy reports and application data.

F.

Install a new instance of SQL Server Reporting Services (SSRS) 2014.

 

Correct Answer: AEF

 

Instant Access to Download Testing Software & PDF File for Microsoft 70-467 Real Exam

Instant Access to Try Microsoft 70-467 Free Demo

This entry was posted in 70-467 Actual Tests and tagged , , , , , . Bookmark the permalink.