Ensurepass

QUESTION 41

HOTSPOT

You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:

 

  • Include multiple properties in a configuration.

  • Force packages to load all settings in the configuration.

  • Support Encrypting File System (EFS) formats.

 

You need to select the appropriate configuration. Which configuration type should you use?

 

To answer, select the appropriate option from the drop-down list in the dialog box.

 

Hot Area:

70-467-demo-47

 

Correct Answer:

70-467-demo-48

 

 

QUESTION 42

You are designing a SQL Server Integration Services (SSIS) solution that will
load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You have the following requirements:

 

  • Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.

  • Ensure that users can generate the exception report in an XML format.

  • Use the minimum development effort.

 

You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

  1. Use a Data Profiling task. Use a Data Flow task to extract the XML output of the Data Profiling task into a SQL Server table. Query the table to view the exceptions.

  2. Use Data Flow tasks to process the clean data.

  3. Use a Data Profiling task. Read the exceptions in Data Profile Viewer.

  4. Design a stored procedure that examines data for common dirty data patterns. Use an Execute SQL task.

 

Correct Answer: C

 

 

QUESTION 43

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. You have the following requirements:

 

  • The deployment model must support changing the content of connection strings by using parameters at execution time.

  • The deployment model must automatically log events to the SSISOB database.

  • Maximize performance at execution time.

 

You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

  1. Use a project deployment model. Modify connection manager properties to use project parameters.

  2. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.

  3. Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.

  4. Use a project deployment model. Modify connection manager properties to use package parameters.

 

Correct Answer: A

 

 

QUESTION 44

You need to fix the PowerPivot data refresh problem by using the least amount of administrative effort. What should you do?

 

  1. Use the PowerPivot Configuration Tool and select the Upgrade Features, Services, Applications and Solutions option.

  2. Use the PowerPivot Configuration Tool and select the Configure or Repair PowerPivot for SharePoint option.

  3. Reinstall SSAS in PowerPivot for SharePoint mode by using the SQL Server 2012 installation media.

  4. In SharePoint Central Administration, create a target application and configure the PowerPivot service application settings to use the target application.

 

Correct Answer: B

 

 

 

 

QUESTION 45

You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?

 

  1. Map the login to the SSISDB database. Assign the user to the ssis_admin role.

  2. Map the login to the msdb database. Assign the user to the db_owner role.

  3. Map the login to the msdb database. Assign the user to the db_ssisadmin role.

  4. Map the login to the SSISDB database. Assign the user to the db_ssisadmin role.

  5. Map the login to the SSISDB database. Assign the user to the db_owner role.

  6. Map the login to the msdb database. Assign the user to the ssis_admin role.

 

Correct Answer: E

 

 

QUESTION 46

You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

 

  1. Set the AttributeHierarchyVisible property to False.

  2. Set the IsAggregatable property to False.

  3. Set the Usage property to Parent.

  4. Set the DefaultMember property to the Forecast member.

  5. Set the AttributeHierarchyEnabled property to False.

  6. Set the RootMemberIf property to ParentIsMissing.

 

Correct Answer: CD

 

 

QUESTION 47

DRAG DROP

You need to configure the attribute relationship types for the Salesperson dimension. Which configuration should you use?

 

To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

 

Select and Place:

70-467-demo-49

 

Correct Answer:

70-467-demo-50

 

 

QUESTION 48

You need to define the trend calculation for the sales performance KPI. Which KPI trend MDX expression should you use?

 

  1. CASE

WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN -1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE 1

END

 

  1. IIF([Sales Variance %3 < ([Sales Variance %], [Date].[Calendar].PrevMember), 1, 0)

 

  1. IIF([Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember), 0, 1)

 

  1. CASE

WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE -1

END

 

Correct Answer: A

 

 

QUESTION 49

DRAG DROP

You need to extend the schema design to store the product dimension data. Which design should you use?

 

To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)

 

Select and Place:

70-467-demo-51

 

Correct Answer:

70-467-demo-52

 

 

QUESTION 50

You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

 

  1. Register a service principal name for the Report Server service.

  2. Register a service principal name for the Analysis Services service.

  3. Restart the IIS service.

  4. Configure SSRS01 to use the Negotiate authentication type.

  5. Configure SSRS01 to use the Custom authentication type.

 

Correct Answer: AD

 

Instant Access to Download Latest Complete Collection of Microsoft MCP 70-467 Real Exam

Try Microsoft MCP 70-467 Free Demo

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.