New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 181-190

EnsurepassQUESTION 181 HOTSPOT You are developing a SQL Server Integration Services (SSIS) package. OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by using SQL Server Management Studio. You need to execute the package and minimize the number of event types that are logged. Which setting should you use?   To answer, change the appropriate setting in the answer area.   Hot Area:   Correct Answer:     QUESTION 182 You develop a SQL Server Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 171-180

EnsurepassQUESTION 171 HOTSPOT You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads rows from a source system and compares them to rows in a destination system. New rows will be inserted and changed rows will be updated. You have used a Lookup transformation and a Conditional Split transformation. The Lookup transformation joins the source and destination table on the business key, and includes all columns from the destination Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 161-170

EnsurepassQUESTION 161 You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL 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 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 and maximizing data flow performance. What Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 151-160

EnsurepassQUESTION 151 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. Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 131-140

EnsurepassQUESTION 131 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.         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 Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 141-150

EnsurepassQUESTION 141 DRAG DROP You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL 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 Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 111-120

EnsurepassQUESTION 111 DRAG DROP 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. Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 121-130

EnsurepassQUESTION 121 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?   a Data Conversion component an Execute SQL task that executes a MERGE statement on the database a Merge component an Expression task   Correct Answer: C     QUESTION 122 You are designing a data warehouse for a Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 101-110

EnsurepassQUESTION 101 DRAG DROP You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.   The package performs the following steps:   Download a sales transaction file by using FTP. Truncate a staging table. Load the contents of the file to the staging table. Merge the data with another data source for loading to a data warehouse.     The checkpoints are currently working such that if any of the four steps fail, the package will restart Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 91-100

EnsurepassQUESTION 91 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 Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 81-90

EnsurepassQUESTION 81 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?   Join the two fact tables. Merge the fact tables. Create a time dimension that can join to both fact tables at their respective granularity. Create a surrogate Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 71-80

EnsurepassQUESTION 71 You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages. The new capability is not available as an SSIS task. Each package must be extended with the same new capability. You need to add the new capability to all the packages without copying the code between packages. What should you do?   Use the Expression task. Use the Script component. Use the Script task. Develop a custom task. Develop a custom component.   Correct Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 61-70

EnsurepassQUESTION 61 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?   Natural Explicit Parent Recursive   Correct Answer: D     QUESTION 62 You develop a SQL Server Integration Services (SSIS) package that Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 51-60

EnsurepassQUESTION 51 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 Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 41-50

EnsurepassQUESTION 41 You are installing the Data Quality Client on user desktops. You need to ensure that the prerequisite software components are installed. Which components must be present to meet this goal? (Each correct answer presents part of the solution. Choose all that apply.)   SQL Server Management Studio Internet Explorer 6.0 SP1 or later Microsoft Silverlight 5 .NET Framework 3.5 SP1 .NET Framework 4.0 Microsoft Silverlight 4 SQL Server Data Tools   Correct Answer: Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 31-40

EnsurepassQUESTION 31 You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the SorABCeyPosition property for a data flow. Which of the following represents the data type for this property?   Integer IDTSExternalMetadataColumn100 String Boolean   Correct Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 21-30

EnsurepassQUESTION 21 You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos. Which of the following suitably describes the effect? It prevents pending changes from more Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 11-20

EnsurepassQUESTION 11 You develop and deploy a SQL Server Integration Services (SSIS) package. The package is stored in the file system. You need to execute the package without importing it to the SSIS server. What should you use to execute the package? (Each correct answer presents a complete solution. Choose all that apply.)   catalog.start_package dtexec SQL Server Management Studio SQL Server Agent   Correct Answer: BD     QUESTION 12 You work as a senior database administrator Read more […]

New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 1-10

EnsurepassQUESTION 1 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. Read more […]