[Free] 2017(Nov) Latesttests Pass4sure Microsoft 70-463 Dumps with VCE and PDF Download 71-80

Latesttests 2017 Nov Microsoft Official New Released 70-463
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/70-463.html

Implementing a Data Warehouse with Microsoft SQL Server 2012

Question No: 71 DRAG DROP – (Topic 2)

You are designing a SQL Server Integration Services (SSIS) package to execute 12 Transact-SQL (T-SQL) statements on a SQL Azure database. The T-SQL statements may be executed in any order. The T-SQL statements have unpredictable execution times.

You have the following requirements:

鈥he package must maximize parallel processing of the T-SQL statements.

鈥fter all the T-SQL statements have completed, a Send Mail task must notify administrators.

You need to design the SSIS package. 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:

Latesttests 2017 PDF and VCE

Question No: 72 HOTSPOT – (Topic 2)

You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools.

A package Connection Manager has been parameterized with project scope.

You need to display the parameters that have been generated for the Connection Manager.

What should you use? To answer, select the appropriate setting or settings in the answer area.

Latesttests 2017 PDF and VCE

Answer:

Latesttests 2017 PDF and VCE

Question No: 73 – (Topic 2)

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.

Referential integrity must be enforced declaratively.

You need to design a solution that can join a single time dimension to both fact tables. What should you do?

  1. Join the two fact tables.

  2. Merge the fact tables.

  3. Create a time dimension that can join to both fact tables at their respective granularity.

  4. Create a surrogate key for the time dimension.

    Answer: C

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

    http://technet.microsoft.com/en-us/library/ms174832.aspx http://msdn.microsoft.com/en-us/library/ms174884.aspx http://decipherinfosys.wordpress.com/2007/02/01/surrogate-keys-vs-natural-keys-for-

    primary-key/ http://www.agiledata.org/essays/keys.html

    http://www.databasejournal.com/features/mssql/article.php/3922066/SQL-Server-Natural-

    Key-Verses-Surrogate-Key.htm http://www.jamesserra.com/archive/2012/01/surrogate-keys/

    Question No: 74 DRAG DROP – (Topic 2)

    You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.

    A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the @CustomerID parameter of type INT.

    A project parameter named CustID will be mapped to the stored procedure parameter

    @CustomerID.

    You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.

    In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)

    Latesttests 2017 PDF and VCE

    Answer:

    Latesttests 2017 PDF and VCE

    Question No: 75 DRAG DROP – (Topic 2)

    You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.

    You need to display the number of rows in each buffer passed between each data flow component of the package.

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

    Latesttests 2017 PDF and VCE

    Answer: Explanation:

    1. Run with verbose settings

    2. Get Execution ID from .executions

    3. Get stats from .execution_data_statistics ( rows_sent ) Ref: http://msdn.microsoft.com/en-us/library/hh230986.aspx

      Question No: 76 – (Topic 2)

      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?

      1. Change the Exhaustive property to True.

      2. Decrease the maximum number of matches per lookup.

      3. Change the similarity threshold to 0.85.

      4. Increase the maximum number of matches per lookup.

Answer: C

Question No: 77 – (Topic 2)

You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse.

The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis.

You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum.

What should you do?

  1. Add an OnError event handler to the SSIS project.

  2. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.

  3. Use an msi file to deploy the package on the server.

  4. Open a command prompt and run the gacutil command.

  5. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

  6. Open a command prompt and run the dtutil /copy command.

  7. Create a reusable custom logging component and use it in the SSIS project.

  8. Configure the SSIS solution to use the Project Deployment Model.

  9. Configure the output of a component in the package data flow to use a data tap.

  10. Open a command prompt and run the dtexec /rep /conn command.

  11. Open a command prompt and run the dtexec /dumperror /conn command.

Answer: I Explanation:

References:

http://technet.microsoft.com/en-us/library/hh230989.aspx

http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/ms162820.aspx http://msdn.microsoft.com/en-us/library/hh231187.aspx http://technet.microsoft.com/en-us/library/ms140223.aspx http://msdn.microsoft.com/en-us/library/jj655339.aspx

Question No: 78 – (Topic 2)

You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit.

Latesttests 2017 PDF and VCE

Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you create a unique constraint?

  1. DateHired

  2. DepartmentID

  3. EmployeelD

  4. EmployeeNum

  5. FirstName

  6. JobTitle

  7. LastName

  8. MiddleName

  9. ReportsToID

Answer: D

Question No: 79 – (Topic 2)

A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store and is imported in parallel with the other files. The data flow tasks use OLE DB destinations in fast load data access mode.

The number of daily transactions per store can be very large and is growing. The Transaction table does not have any indexes.

You need to minimize the package execution time. What should you do?

  1. Partition the table by day and store.

  2. Create a clustered index on the Transaction table.

  3. Run the package in Performance mode.

  4. Increase the value of the Row per Batch property.

Answer: D

Explanation: * Data Access Mode – This setting provides the #39;fast load#39; option which internally uses a BULK INSERT statement for uploading data into the destination table instead of a simple INSERT statement (for each single row) as in the case for other options.

* BULK INSERT parameters include: ROWS_PER_BATCH =rows_per_batch

Indicates the approximate number of rows of data in the data file.

By default, all the data in the data file is sent to the server as a single transaction, and the number of rows in the batch is unknown to the query optimizer. If you specify ROWS_PER_BATCH (with a value gt; 0) the server uses this value to optimize the bulk- import operation. The value specified for ROWS_PER_BATCH should approximately the same as the actual number of rows.

Question No: 80 – (Topic 2)

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.

Referential integrity must be enforced declaratively.

You need to design a solution that can join a single time dimension to both fact tables. What should you do?

  1. Create a view on the sales table.

  2. Partition the fact tables by day.

  3. Create a surrogate key for the time dimension.

  4. Change the level of granularity in both fact tables to be the same.

Answer: D

100% Free Download!
Download Free Demo:70-463 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests 70-463 Full Exam PDF and VCE

Latesttests 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

2017 Latesttests IT Certification PDF and VCE

Leave a Reply

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