Tag: 70-463 free dumps

Updated Microsoft 70-463 PDF & VCE Free Download Now (181-190)

Posted on

QUESTION 181
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode. Some of the data to be loaded will reference products that need special processing logic in the data flow. You need to enable separate processing streams for a subset of rows based on the source product code. Which data flow transformation should you use?

A.    Source Assistant
B.    Destination Assistant
C.    Audit
D.    Script Component

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (161-170)

Posted on

QUESTION 161
Hotspot Questions
You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model- The model consists of two entities: one named Customer and one named State.
You opened the Customer entity.
Currently, data stewards can enter any text value in the Customer entity’s State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity. You need to configure the State attribute of the Customer entity. Which command should you use? (To answer, select the appropriate command in the answer area.)
1611

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (151-160)

Posted on

QUESTION 151
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database. The package is deployed to SQL Server. The package is not producing the desired results. You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues. What should you do?

A.    Execute the catalog.add_data_tap stored procedure with the package execution_id.
B.    Execute the catalog.create_execution_dump stored procedure with the package execution_id.
C.    Run the DTEXEC utility with the /DumpOnError option.
D.    Run the DTEXEC utility with the /Reporting V option.

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (131-140)

Posted on

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

A.    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.
B.    Use Data Flow tasks to process the clean data.
C.    Use a Data Profiling task. Read the exceptions in Data Profile Viewer.
D.    Design a stored procedure that examines data for common dirty data patterns. Use an Execute SQL task.

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (111-120)

Posted on

QUESTION 111
You work as a senior database administrator at Lead2pass.com. The Lead2pass.com network consists of a single domain named Lead2pass.com. Lead2pass.com makes use of Microsoft SQL Server 2012 in their environment. You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing Multicast transformation. Which of the following is TRUE with regards to Multicast transformation? (Choose two.)

A.    It prevents a package from creating logical copies of data.
B.    It allows a package to create logical copies of data.
C.    It distributes its input to one or more outputs.
D.    It distributes its input to a single output.

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (101-110)

Posted on

QUESTION 101
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?

A.    Create SSIS configuration files for the packages.
B.    Create an Integration Services catalog.
C.    Install Data Quality Services.
D.    Install Master Data services.

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (61-70)

Posted on

QUESTION 61
Drag and Drop Questions
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed to several servers that run SQL Server 2012. The project accepts one required parameter. The data type of the parameter is a string. A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter. You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the package. Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
611

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (51-60)

Posted on

QUESTION 51
To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements:
* Centralized logging in SQL Server
* Simple deployment
* Availability of log information through reports or T-SQL
* Automatic purge of older log entries
* Configurable log details
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?

A.    Deploy the package by using an msi file.
B.    Use the gacutil command.
C.    Create an OnError event handler.
D.    Create a reusable custom logging component.
E.    Use the dtutil /copy command.
F.    Use the Project Deployment Wizard.
G.    Run the package by using the dtexec /rep /conn command.
H.    Add a data tap on the output of a component in the package data flow.
I.    Run the package by using the dtexec /dumperror /conn command.
J.    Run the package by using the dtexecui.exe utility and the SQL Log provider.
K.    Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

Read More …

Updated Microsoft 70-463 PDF & VCE Free Download Now (1-10)

Posted on

QUESTION 1
You are reviewing the design of a customer dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to customer attributes such as Postcode.
You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode. What should you do?

A.    Add StartDate and EndDate columns to the customer dimension.
B.     Add an IsCurrent column to the customer dimension.
C.    Enable Snapshot Isolation on the data warehouse.
D.    Add CurrentValue and PreviousValue columns to the customer dimension.