Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 May Microsoft Official New Released 70-463
100% Free Download! 100% Pass Guaranteed!

Implementing a Data Warehouse with Microsoft SQL Server 2012

Question No: 31 DRAG DROP – (Topic 1)

A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse.

The SSIS catalog includes two Environments:

->Development

->QA

Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the development or QA data warehouses.

You need to be able to execute deployed packages by using either of the defined Environments.

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:

Dumps4Cert 2018 PDF and VCE

Question No: 32 – (Topic 1)

You are installing SQL Server Data Quality Services (DQS).

You need to give specific users access to the Data Quality Server.

Which SQL Server application should you use?

  1. SQL Server Configuration Manager

  2. SQL Server Data Tools

  3. SQL Server Management Studio

  4. Data Quality Client

Answer: C Explanation:

Ref: http://msdn.microsoft.com/en-us/library/hh213045.aspx

Question No: 33 – (Topic 1)

You are installing SQL Server Data Quality Services (DQS).

You need to give users belonging to a specific Active Directory group access to the Data Quality Server.

Which SQL Server application should you use?

  1. Data Quality Client with administrative credentials

  2. SQL Server Configuration Manager with local administrative credentials

  3. SQL Server Data Tools with local administrative permissions

  4. SQL Server Management Studio with administrative credentials

Answer: D

Question No: 34 – (Topic 1)

You are creating a SQL Server Master Data Services (MDS) model for a company.

The source data for the company is stored in a single table that contains the manager-to- subordinate relationships.

You need to create a hierarchy representing the organizational structure of the company. Which hierarchy type should you use?

  1. Natural

  2. Explicit

  3. Parent

  4. Recursive

Answer: D

Reference: http://technet.microsoft.com/en-us/library/ff487006.aspx Reference: http://msdn.microsoft.com/en-us/library/ee633747.aspx Reference: http://technet.microsoft.com/en-us/library/ee633759.aspx

Question No: 35 – (Topic 1)

You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD).

You need to add a task or component to the package that allows you to implement the SCD logic.

What should you use?

  1. a Data Conversion component

  2. an Execute SQL task that executes a MERGE statement on the database

  3. a Merge component

  4. an Expression task

Answer: C Explanation:

Note: Type of Slowly Changing Dimensions Slowly Changing Dimensions are categorized into three types named: Type 1, Type 2, and Type3. The Type 1 SCD does not maintain the history of changing attributes, it overwrites values of the attributes. Type 2 maintains historical values for changing attributes. Type 3 that we do not use much maintains separate columns for changed attributes. SSIS SCD wizard supports both Type

1 and Type 2.

Using MERGE instead of SCD wizard Replacement of SCD wizard with MERGE is not a straightforward technique. If the SCD has both Type 1 and Type 2 types attributes, they need to be handled separately.

Question No: 36 – (Topic 1)

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.

In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Team Type, does not yet have a domain.

You need to complete the mapping of the Team Type column. What should you do?

  1. Add a column mapping for the Team Type column.

  2. Map a composite domain to the source column.

  3. Create a composite domain that includes the Team Type column.

  4. Add a domain for the Team Type column.

Answer: D

Explanation: References: http://msdn.microsoft.com/en-us/library/ff877917.aspx http://msdn.microsoft.com/en-us/library/hh213015.aspx http://msdn.microsoft.com/en-us/library/gg524799.aspx

Question No: 37 – (Topic 1)

You are reviewing the design of an existing fact table named factSales, which is loaded from a SQL Azure database by a SQL Server Integration Services (SSIS) package each day. The fact table has approximately 1 billion rows and is dimensioned by product, sales date, and sales time of day.

Dumps4Cert 2018 PDF and VCE

The database administrator is concerned about the growth of the database. Users report poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table.

You need to reduce the report processing time and minimize the growth of the database. What should you do?

  1. Partition the table by product type.

  2. Create a view over the fact table to aggregate sales by month.

  3. Change the granularity of the fact table to month.

  4. Create an indexed view over the fact table to aggregate sales by month.

Answer: C

Question No: 38 – (Topic 1)

You manage a SQL Server Master Data Services (MDS) environment.

A new application requires access to the product data that is available in the MDS repository.

You need to design a solution that gives the application access to the product data with the least amount of development effort.

What should you do?

  1. Create a Subscription View in MDS.

  2. Access the product entity tables in the MDS database directly.

  3. Use SQL Server Integration Services (SSIS) to extract the data and put it in a staging

    database.

  4. Use change data capture on the product entity tables.

Answer: A

Question No: 39 DRAG DROP – (Topic 1)

You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B.

Both packages must reference a file path corresponding to an input folder where files will be located for further processing.

You need to design a solution so that the file path can be easily configured with the least administrative and development effort.

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

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 40 – (Topic 1)

You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.

Products for each distributor source must be combined for insertion into a single product table destination.

You need to select the appropriate data flow transformation to meet this requirement.

Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)

  1. Multicast

  2. Merge Join

  3. Term Extraction

  4. union All

  5. Merge

Answer: D,E

Reference: http://msdn.microsoft.com/en-us/library/ms141703.aspx Reference: http://msdn.microsoft.com/en-us/library/ms141775.aspx Reference: http://msdn.microsoft.com/en-us/library/ms141020.aspx Reference: http://msdn.microsoft.com/en-us/library/ms141809.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms137701.aspx

100% Dumps4cert Free Download!
Download Free Demo:70-463 Demo PDF
100% Dumps4cert Pass Guaranteed!
70-463 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No