[100% Pass] Get Free Microsoft 70-463 283q Exam Dumps With New Update Exam Questions And Answers (61-75)

PassLeader helps you to get well prepared for the Microsoft 70-463 exam! Try PassLeader’s new 70-463 238q exam dumps with VCE test software or PDF braindumps now and you will get your 70-463 certification quickly. PassLeader’s 70-463 exam training kit with all new exam questions is the best study materials for preparing exam, we ensure that our full version 70-463 238q VCE and PDF dumps will help you 100 percent passing exam. First try the PassLeader valid 70-463 braindumps and first pass exam!

keywords: 70-463,70-463 exam,70-463 exam dumps,70-463 238q exam questions,70-463 pdf dumps,70-463 238q vce dumps,70-463 brain dumps,Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam

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

Answer:

QUESTION 62
You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load. The package and all three Execute SQL product tasks have their TransactionOption property set to Supported. You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes. What should you do?

A.    Change the TransactionOption property of the package to Required.
B.    Change the TransactionOption property of all three Execute SQL product tasks to Required.
C.    Move the three Execute SQL product tasks into a Foreach Loop container.
D.     Move the three Execute SQL product tasks into a Sequence container.

Answer: A

QUESTION 63
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.    a Data Conversion component
B.    an Execute SQL task that executes a MERGE statement on the database
C.    a Merge component
D.    an Expression task

Answer: C

QUESTION 64
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on Server A . The package includes a data flow and is executed on Server B. The destination table has its own identity column. The destination data load has the following requirements:
– The identity values from the source table must be used.
– Default constraints on the destination table must be ignored.
– Batch size must be 100,000 rows.
You need to add a destination and configure it to meet the requirements. Which destination should you use?

A.    OLE DB Destination with Fast Load
B.     SQL Server Destination
C.    ADO NET Destination without Bulk Insert
D.    ADO NET Destination with Bulk Insert
E.    OLE DB Destination without Fast Load

Answer: A

QUESTION 65
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT statement. The task has the following requirements:
– The INSERT statement must use the value of a string package variable. The variable name is StringVar.
– The Execute SQL task must use an OLE DB Connection Manager.
In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter. You must configure the SQLStatement property of the Execute SQL task. Which SQL statement should you use?

A.    INSERT INTO dbo.Table (variablevalue) VALUES (@StringVar)
B.    INSERT INTO dbo.Table (variablevalue) VALUES ($Project::StringVar)
C.    INSERT INTO dbo.Table (variablevalue) VALUES (?)
D.    INSERT INTO dbo.Table (variablevalue) VALUES ($Package::StringVar)

Answer: C

QUESTION 66
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package. You need to configure the package to accept the folder path from each job. Which package configuration should you use?

A.    Parent Package Variable
B.    XML Configuration File
C.    Environment Variable
D.    .dtsConfig file
E.    Registry Entry

Answer: C

QUESTION 67
Drag and Drop Question
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.

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

Answer:


http://www.passleader.com/70-463.html

QUESTION 68
You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database. The company’s auditing policies have the following requirements:
– An entry must be written to a dedicated SQL Server log table named OrderLog.
– The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements. Which event handler should you use?

A.    OnProgress
B.    Onlnformation
C.    OnPostExecute
D.    OnComplete

Answer: C

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

The Insert New Orders Data Flow task must meet the following requirements:
– Usage of the tempdb database should not be impacted.
– Concurrency should be maximized, while only reading committed transactions.
– If 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

QUESTION 70
Drag and Drop Question
You are building a fact table in a data warehouse. The table must have a columnstore index. The table cannot be partitioned. You need to design the fact table and load it with data. 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:

QUESTION 71
Drag and Drop Questions
You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record. In the current implementation, the DimProduct table must be scanned twice, once for the insert and again for the update. As a result, inserts and updates to the DimProduct table take longer than expected. You need to create a solution that uses a single command to perform an update and an insert. How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate answer choice from the list of options to the correct location or locations in the answer area. You may need to drag the split bar between panes or scroll to view content.)

Answer:

QUESTION 72
You are designing a data warehouse for a fresh food distribution business that stores sates by individual product. It stores sales targets by product category. Products are classified into subcategories and categories. Each product is included in only a single product subcategory, and each subcategory is included in only a single category. The data warehouse will be a data source for an Analysis Services cube. The data warehouse contains two fact tables:
– factSales, used to record daily sales by product
– factProductTarget, used to record the monthly sales targets by product category
Reports must be developed against the warehouse that reports product sales by product, category and subcategory, and product sales targets. You need to design the product dimension. The solution should use as few tables as possible while supporting all the requirements. What should you do?

A.    Create two product tables, dimProduct and dimProductCategory.
Connect factSales to dimProduct and factProductTarget to dimProductCategory with foreign key constraints.
Direct the cube developer to use key granularity attributes.
B.    Create one product table, dimProduct, which contains product detail, category, and subcategory columns.
Connect factSales to dimProduct with a foreign key constraint.
Direct the cube developer to use a non-key granularity attribute for factProductTarget.
C.    Create three product tables, dimProduct, dimProductCategory, and dimProductSubcategory, and a fourth bridge table that joins products to their appropriate category and subcategory table records with foreign key constraints.
Direct the cube developer to use key granularity attributes.
D.    Create three product tables, dimProduct, dimProductCategory, and dimProductSubcategory.
Connect factSales to all three product tables and connect factProductTarget to dimProductCategory with foreign key constraints.
Direct the cube developer to use key granularity attributes.

Answer: B

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

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

Answer: D

QUESTION 74
You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day.

The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table. You need to reduce the report processing time and minimize the growth of the database. What should you do?

A.    Create an indexed view over the fact table to sum orderTotal by month.
B.    Create a view over the fact table to sum orderTotal by month.
C.    Change the granularity of the fact table to month.
D.    Partition the fact table by productKey.

Answer: C

QUESTION 75
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?

A.    Create a conformed dimension for the geography dimension.
B.    Implement change tracking.
C.    Create a degenerate dimension for the geography dimension.
D.    Create a Type 2 slowly changing dimension for the geography dimension.

Answer: A


http://www.passleader.com/70-463.html

Welcome To Visit PassLeader