[2021-New] Microsoft 70-463 Dumps With Update Exam Questions (81-90)

70-463 Dumps

70-463 Exam Questions - Online Test

70-463 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Q1. You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).

You need to complete the post-installation configuration.

What should you do?

A. Run the DQSInstaller.exe command.

B. Install the data providers that are used for data refresh.

C. Install ADOMD.NET.

D. Run the dbimpexp.exe command.

Answer: A

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

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

Q2. You are the data steward for a Business Intelligence project.

You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.

You need to produce the CSV file with the least amount of development effort.

What should you do?

A. Create an Integration Services package and use a Fuzzy Lookup transform.

B. Create a Master Data Services (MDS) model.

C. Create a Data Quality Project.

D. Create an Integration Services package and use a DQS Cleansing transform.

E. Create an Integration Services package and use a Fuzzy Grouping transform.

Answer: D

Explanation: The DQS Cleansing transformation uses Data Quality Services (DQS) to correct data from a connected data source, by applying approved rules that were created for the connected data source or a similar data source. To determine whether the data has to be corrected, the DQS Cleansing transformation processes data from an input column when the following conditions are true:

* The column is selected for data correction.

* The column data type is supported for data correction.

* The column is mapped a domain that has a compatible data type.

* The transformation also includes an error output that you configure to handle row-level errors

Q3. You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database.

The SSIS package has the following requirements:

Every night, a very large amount of data is imported into the staging database.

Package processing time must be minimized.

The package must run on its own dedicated server when it is deployed to

production.

Transaction log activity when data is imported must be minimized.

You need to design the package to meet the requirements.

Which destination component should you use?

A. Raw File

B. ODBC

C. Bulk Insert

D. OLE DB

Answer: D

Q4. You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.

The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.

If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.

The current setting for the Fuzzy Lookup similarity threshold is 0.50.

Many values are incorrectly matched.

You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.

What should you do?

A. Change the Exhaustive property to True.

B. Decrease the maximum number of matches per lookup.

C. Change the similarity threshold to 0.85.

D. Increase the maximum number of matches per lookup.

Answer: B

Q5. pic 2)

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.

. Support several packages with different configuration settings. 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.

Answer:

Q6. You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You are developing the part of the SSIS package that populates the ProjectDates dimension table.

The business key of the ProjectDates table is the ProjectName column. The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table:

ExpectedStartDate - New values should be tracked over time.

ActualStartDate - New values should not be accepted.

ExpectedEndDate - New values should replace existing values.

ActualEndDate - New values should be tracked over time.

You use the SSIS Slowly Changing Dimension Transformation.

You must configure the Change Type value for each source column.

Which settings should you select? (To answer, select the appropriate setting or settings in the answer area. Each Change Type may be used once, more than once, or not at all.)

Answer:

Q7. To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package.

The following requirements must be met:

All the user information for a given Active Directory group must be downloaded to a SQL Server table. The download process must traverse the Active Directory hierarchy recursively.

You need to configure the package to meet the requirements by using the least development effort.

What should you use?

A. script component

B. custom component

C. XML source

D. script task

Answer: A

Q8. You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.

Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:

Valid addresses

Autocorrected addresses

Invalid addresses

You need to enhance the SSIS packages to perform address validation by using an external service.

Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.)

Answer:

Q9. You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012.

The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter.

You need to create a solution to meet the requirements by using the least amount of administrative effort.

What should you do?

A. Add a SQLMOBILE connection manager to each package.

B. Add an ADO.NET project connection manager.

C. Add a SQLMOBILE project connection manager.

D. Add an ADO.NET connection manager to each data flow task.

E. Add a SQLMOBILE connection manager to each data flow task.

F. Add an ADO.NET connection manager to each package.

Answer: A

Q10. You are developing a SQL Server Integration Services (SSIS) package.

The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.

You need to create a separate data flow path for data that has been modified since it was last processed.

Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)

A. Multicast

B. Data Conversion

C. Lookup

D. Slowly Changing Dimension

E. Aggregate

Answer: A,C

Explanation: A: The transformation that distributes data sets to multiple outputs.

The transformation that distributes data sets to multiple outputs.

C: Lookup Transformation

The transformation that looks up values in a reference table using an exact match.

Note:

* SQL Server Integration Services provides three different types of data flow components:

sources, transformations, and destinations. Sources extract data from data stores such as

tables and views in relational databases, files, and Analysis Services databases.

Transformations modify, summarize, and clean data. Destinations load data into data

stores or create in-memory datasets.

Incorrect: Not B: Data Conversion Transformation The transformation that converts the data type of a column to a different data type. Not D: Slowly Changing Dimension Transformation The transformation that configures the updating of a slowly changing dimension. Not E: The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across.