This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Sun Apr 28 22:49:12 2024 / +0000 GMT ___________________________________________________ Title: [2016 Feb-UPDATED]Free Braindump2go Microsoft 70-463 VCE Exam Questions and Answers Download --------------------------------------------------- 2016 Feburary NEW ADDED 70-463 Exam Questions RELEASED Today!Exam Code: 70-463 Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012 Certification Provider: Microsoft Corresponding Certifications: MCSA, MCSA: SQL Server 2012, MCSE, MCSE: Business Intelligence, MCSE: Data Platform 2016 NEW 70-463 Exam Topics: 1.Design and implement a data warehouse2.Extract and transform data3.Load data4.Configure and deploy SSIS solutions5.Build data quality solutions ATTENTION: 2016 NEW ADDED 70-463 Exam Questions are the most IMPORTANT! QUESTION 231Which of the following statements about simple and complex data movements are true? (Choose all that apply.) A.    Simple data movements only have a single data source and a single data destination.B.    Complex data movements require data to be transformed before it can be stored at the destination.C.    In simple data movements, data transformations are limited to data type conversion.D.    In complex data movements, additional programmatic logic is required to merge source data with destination data. Answer: BD QUESTION 232Which of the following statements are true? (Choose all that apply.) A.    An SSIS package can contain one or more SSDT solutions, each performing a specific data management operation.B.    An SSIS project can contain one or more SSIS packages.C.    An SSIS project can contain exactly one SSIS package.D.    SSIS packages contain programmatic logic used in data movements and data transformation operations. Answer: BD QUESTION 233You are designing a data warehouse that uses SQL Server 2012.The data warehouse contains a table named factSales that stores product sales. The table has a clustered index on the primary key, four foreign keys to dimension tables, and an aggregate column for sales totals. All key columns use the INT data type, and the aggregate column uses the MONEY data type.You need to increase the speed of data retrieval from the factSales table.Which index type should you add to the table? A.    Full textB.    SpatialC.    Non-clusteredD.    Clustered Answer: C QUESTION 234You 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? A.    AuditB.    DQS CleansingC.    CDC SplitterD.    Pivot Answer: CExplanation: 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 operationshttp://msdn.microsoft.com/en-us/library/hh758656.aspx QUESTION 235You are developing a SQL Server Integration Services (SSIS) package.You need to design a package to change a variable value during package execution by using the least amount of development effort.What should you use? A.    Express on taskB.    Data Cleansing transformationC.    Fuzzy Lookup transformationD.    Term Lookup transformationE.    Data Profiling task Answer: A QUESTION 236You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model.The project will contain 10 packages. All the packages must connect to the same data source and destination.You need to define and reuse the connection managers in all the packages by using the least development effort.What should you do? A.    Implement parent package variables.B.    Copy and paste connection managers from one package to the others.C.    Implement project connection managers.D.    Implement package connection managers. Answer: C QUESTION 237Hotspot QuestionYou are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database.The package is allowed to connect to only one database. An Environment variable contains the name of the database.The OLE DB project connection manager has been parameterized.You need to configure the connection manager property to accept the value of the Environment variable.Which property should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.) Answer:   QUESTION 238You 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.    MulticastB.    Conditional SplitC.    Script TaskD.    Data Conversion Answer: BExplanation: We use Conditional Split to split the source data into separate processing streams.A Script Component (Script Component is the answer to another version of this question)could be used but this is not the same as a Script Task.QUESTION 239Your company uses a proprietary encryption algorithm to secure sensitive data. A custom cryptographic assembly was developed in Microsoft .NET and is used in several applications.A SQL Server Integration Services (SSIS) package is importing data into a Windows Azure SQL Database database. Some of the data must be encrypted with the proprietary encryption algorithm.You need to design the implementation strategy to meet the requirements while minimizing development and deployment effort and maximizing data flow performance.What should you do? A.    Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to encrypt the data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.B.    Use an SSIS Script transformation that uses the custom assembly to encrypt the data when inserting it.C.    Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to encrypt the data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.D.    Use an SSIS Script task that uses the custom assembly to encrypt the data when inserting it. Answer: B 2016 Feburary NEW Added 70-463 Exam Questions 238Q Full Version Free Shared By Braindump2go Today! http://www.braindump2go.com/70-463.html --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2016-02-23 06:01:17 Post date GMT: 2016-02-23 06:01:17 Post modified date: 2016-02-23 06:01:17 Post modified date GMT: 2016-02-23 06:01:17 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com