[Free] Get all latest Microsoft 70-467 Actual Tests 141-150

Ensurepass

QUESTION 141

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.

 

Correct Answer: A

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 142

DRAG DROP

You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.

 

A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.

 

Information that is encrypted in the SSISDB database must not be lost.

 

You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.

 

Which three steps should you document 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 143

DRAG DROP

You are administering a SQL Server Analysis Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.

 

You need to grant read access to the financial cube for all users in the group USAPowerUsers.

 

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_image006

 

Correct Answer:

clip_image008

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 144

You are designing a reporting solution that uses SQL Server Reporting Services (SSRS) in SharePoint integrated mode.

 

The reporting solution must meet the following requirements:

 

clip_image010Allow report writers to reuse content between different reports.

clip_image010[1]Allow report writers to modify reusable content in SharePoint.

clip_image010[2]Retain version history for report content.

 

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

 

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

 

A.

drillthrough reports

B.

linked reports

C.

subreports

D.

report parts

 

Correct Answer: D

 

 

QUESTION 145

You deploy a PowerPivot workbook to a document library in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B.

 

The workbook contains three small lookup tables from Source A, and five tables with a total of 20 million rows from Source B.Data from Source A is updated at 9:00 A.M.and data from Source B is updated throughout the day.

 

You have the following requirements:

 

clip_image010[3]Refresh the PowerPivot workbook with updated lookup data as soon as possible.

clip_image010[4]Minimize load on the source systems and the SharePoint environment during business hours.

clip_image010[5]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.

Set the default schedule to refresh outside of business hours. Do not manually refresh the workbook.

B.

Set the default schedule to refresh outside of business hours. Manually refresh the workbook at 9:00 A.M.every day.

C.

Set the default schedule to refresh at 9:00 A.M.every day. Create a separate schedule for Source B’s connection to refresh outside of business hours.

D.

Set the default schedule to refresh at 3:00 P.M.every day. Do not create individual source schedules.

E.

Set the default schedule to refresh at 9:00 A.M.every day. Do not create individual source schedules.

 

Correct Answer: C

 

 

QUESTION 146

You need to design a data warehouse schema to support a multidimensional cube. The fact table will contain multiple columns representing order dates, shipping dates, and billing dates. The cube will contain a measure group based on the fact table. What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

 

A.

In the database, create a time table for each date column in the fact table.

From the data source view, join each date column in the fact table to the corresponding time table.

Create dimensions for each time table.

B.

In the database, create a time table containing a column that corresponds to each date column in the fact table.

From the data source view, join each date column in the fact table to the corresponding column in the time table.

Create a dimension for the time table.

C.

In the database, create a time table that uses an integer primary key and a datetime column.

Create a dimension based on the time table.

From the Cube Designer, use the Dimension Usage tab to define a relationship between the measure group date columns and the datetime column of the time dimension.

D.

In the database, create a time table that uses an integer primary key and a datetime column.

Create a dimension based on the time table.

From the Cube Designer, use the Dimension Usage tab to define a relationship between the measure group date columns and the key column of the time dimension.

 

Correct Answer: B

 

 

QUESTION 147

You are creating a product dimension table and a SQL Server Integration Services (SSIS) package that will load the table. You need to keep a history in the table of changes to the names of products. Which three actions should you perform? Each correct answer presents part of the solution.

 

A.

Add a Slowly Changing Dimension transformation to the package.

B.

Enable Change Data Capture for the table.

C.

Create an inferred member column in the table.

D.

From the Slowly Changing Dimension Wizard, set the name column to Type 3.

E.

Create an end date column in the table.

F.

Create a start date column in the table.

 

Correct Answer: AEF

 

 

 

 

 

 

 

 

 

QUESTION 148

DRAG DROP

You are designing a business intelligence (BI) solution for a hotel booking system. Each hotel booking may have more than one guest.

 

The BI solution contains a fact table named Booking, a factless fact table named Booking_Guest and a dimension named Guest.

 

Booking contains an entry for each booking. Booking_Guest contains an entry for each guest in each booking. Guest contains an entry for each guest.

 

You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS) for the hotel booking system.

 

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.

 

clip_image012

 

Correct Answer:

clip_image014

 

 

 

 

 

 

QUESTION 149

HOTSPOT

You are designing aggregations for a SQL Server Analysis Services (SSAS) cube.

 

You need to ensure that every aggregation includes the Category attribute.

 

Which option should you select? To answer, select the appropriate option button in the answer area.

 

clip_image015

 

Correct Answer:

clip_image016

 

 

 

 

QUESTION 150

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. The FactSales5 partition contains the current year’s information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions. You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server. Several queries and reports are running very slowly. You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Use the Aggregation Design Wizard to create aggregations for the current partitions.

B.

Combine all the partitions into a single partition. Use the Usage-Based Optimization Wizard to create aggregations.

C.

Combine all the partitions into a single partition. Use the Aggregation Design Wizard to create aggregations.

D.

Use the Usage-Based Optimization Wizard to create aggregations for the current partitions.

 

Correct Answer: D

 

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.