[Free] 2018(June) Dumps4cert Microsoft 70-463 Dumps with VCE and PDF Download 111-120

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: 111 – (Topic 2)

You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours.

Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.

You need to partition the table to maximize the performance of queries. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

  1. Partition the fact table by month, and compress each partition.

  2. Partition the fact table by week.

  3. Partition the fact table by year.

  4. Partition the fact table by day, and compress each partition.

Answer: D

Question No: 112 – (Topic 2)

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.

You have added a CDC Source component to the data flow to read changed data from the source system.

You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.

Which data flow transformation should you use?

  1. Audit

  2. Merge Join

  3. Merge

  4. CDC Splitter

Answer: D

Explanation: The CDC splitter splits a single flow of change rows from a CDC source data flow into different data flows for Insert, Update and Delete operations

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

Question No: 113 CORRECT TEXT – (Topic 2)

You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition:

Dumps4Cert 2018 PDF and VCE

You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.

You need to ensure that the following requirements are met:

->The first row of the file contains the first row of data.

->Each record is of the same length.

->The date follows the U.S. date format.

->The file supports international characters.

What should you do? (To answer, simply select the option or options in the answer area that you would configure.)

Answer: Tick the “Unicode” checkbox. Set the Format option to “Fixed Width”

Untick the “Column names in the first data row” checkbox.

Explanation:

Each record is of the same length = Fixed Width. The file supports international characters = Unicode.

The date follows the U.S. date format = Locale (already configured).

The first row of the file contains the first row of data = Uncheck “Column names in the first data row”

Question No: 114 CORRECT TEXT – (Topic 2)

You are designing a package control flow. The package moves sales order data from a SQL Azure transactional database to an on-premise reporting database. The package will run several times a day, while new sales orders are being added to the transactional database. The current design of the package control flow is shown in the answer area. (Click the Exhibit button.)

Dumps4Cert 2018 PDF and VCE

The Insert New Orders Data Flow task must meet the following requirements:

鈥sage of the tempdb database should not be impacted.

鈥oncurrency should be maximized, while only reading committed transactions.

鈥f the task fails, only that task needs to be rolled back.

You need to configure the Insert New Orders Data Flow task to meet the requirements.

How should you configure the transaction properties? (To answer, select the appropriate setting or settings in the answer area.)

Answer: IsolationLevel = ReadCommited. TransactionOption = Required References:

http://msdn.microsoft.com/en-us/library/ms137690.aspx http://msdn.microsoft.com/en-us/library/ms137749.aspx http://msdn.microsoft.com/en- us/library/microsoft.sqlserver.dts.runtime.dtscontainer.isolationlevel.aspx http://msdn.microsoft.com/en-us/library/ms173763.aspx

Question No: 115 – (Topic 2)

You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred.

You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.

What should you do?

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

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

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

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

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

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

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

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

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

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

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

    Answer: C Explanation:

    References:

    http://msdn.microsoft.com/en-us/library/ms141212.aspx http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server- 2012-part-1-of-2/

    http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server- 2012-part-2-of-2/

    Question No: 116 DRAG DROP – (Topic 2)

    You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.

    The package performs the following steps:

    1. Download a sales transaction file by using FTP.

    2. Truncate a staging table.

    3. Load the contents of the file to the staging table.

    4. Merge the data with another data source for loading to a data warehouse.

      Dumps4Cert 2018 PDF and VCE

      The checkpoints are currently working such that if any of the four steps fail, the package will restart from the failed step the next time it executes.

      You need to modify the package to ensure that if either the Truncate Staging Table or the Load Sales to Staging task fails, the package will always restart from the Truncate Staging Table task the next time the package runs.

      Which three steps 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: 117 HOTSPOT – (Topic 2)

      You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found.

      After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending on the value of the InStock variable.

      You need to set the precedence constraints.

      Which value for the evaluation operation should you use? (To answer, select the appropriate option for the evaluation operation in the answer area.)

      Answer:

      Dumps4Cert 2018 PDF and VCE

      Question No: 118 DRAG DROP – (Topic 2)

      You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a production server. The package contains sensitive information secured by

      using the EncryptSensitiveWithUserKey package protection level.

      You are preparing the package for deployment by the production operations team.

      You need to ensure that the production operations team can open and execute the package without re-entering the sensitive information.

      Which three steps 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: 119 DRAG DROP – (Topic 2)

      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:

      ->Test

      ->Production

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

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

      Dumps4Cert 2018 PDF and VCE

      Answer:

      Dumps4Cert 2018 PDF and VCE

      Explanation:

      Box 1:

      Box 2:

      Box 3:

      Dumps4Cert 2018 PDF and VCE

      We need to add references to the Test and Production environments to the project. Then we can map the variables in the project to the environment variables defined in the environments.

      When you execute a package in a project that references multiple environments (Test and Production in this case), we can select which environment the package runs under.

      Question No: 120 – (Topic 2)

      You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.

      Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.

      You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.

      What should you do?

      1. Create a conformed dimension for the geography dimension.

      2. Implement change tracking.

      3. Create a degenerate dimension for the geography dimension.

      4. Create a Type 2 slowly changing dimension for the geography dimension.

Answer: A

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

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

Leave a Reply

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