Proper study guides for Rebirth Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012 certified begins with Microsoft exam 70 463 preparation products which designed to deliver the Validated 70 463 training kit pdf questions by making you pass the 70 463 pdf test at your first time. Try the free 70 463 exam demo right now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Microsoft 70-463 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-463 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/70-463-exam-dumps.html
Q31. 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 table in the data flow output. The Conditional Split transformation inspects the destination columns and directs data flow to either insert new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)
Answer:
Q32. You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job.
You make changes to the package that should improve performance.
You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal.
What should you do?
A. After 10 executions, view the job history for the SQL Server Agent job.
B. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the project.
C. Enable logging to the Application Event Log in the package control flow for the Onlnformation event. After 10 executions, view the Application Event Log.
D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10 executions, view the XML file.
Answer: B
Explanation: The All Executions Report displays a summary of all Integration Services executions that have been performed on the server. There can be multiple executions of the sample package. Unlike the Integration Services Dashboard report, you can configure the All Executions report to show executions that have started during a range of dates. The dates can span multiple days, months, or years.
The report displays the following sections of information.
* Filter
Shows the current filter applied to the report, such as the Start time range.
* Execution Information
Shows the start time, end time, and duration for each package execution.You can view a
list of the parameter values that were used with a package execution, such as values that
were passed to a child package using the Execute Package task.
Q33. You are designing a data warehouse that contains a customer dimension.
The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved.
The customer dimension design must:
Support a Type 3 Slowly Changing Dimension (SCD) process
Minimize the total storage consumed
You need to design a solution that meets these requirements.
What should you do?
A. Design two tables. One table will hold the original customer surrogate key and attributes. The other table will hold the most recent customer surrogate key and attributes.
B. Design a table as a Type 2 SCD dimension that holds the surrogate key for each customer and its attributes. Limit the number of records per customer within the table to two.
C. Design a table to hold the surrogate key for each customer and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.
D. Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.
Answer: D
Q34. You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server has been set up. The DQS databases are restored to a new server. All the appropriate permissions are granted.
DQS users are experiencing issues connecting to the new Data Quality Server.
You need to enable users to connect to the new server.
Which Surface Area Configuration property should you enable?
A. AdHocRemoteQueriesEnabled
B. SoapEndpointsEnabled
C. ClrIntegrationEnabled
D. RemoteDacEnabled
E. OleAutomationEnabled
F. XpCmdShellEnabled
Answer: C
Q35. You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.
The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?
A. Decrease the maximum number of matches per lookup.
B. Change the similarity threshold to 0.55.
C. Change the Exhaustive property to True.
D. Increase the maximum number of matches per lookup.
Answer: B
Reference: http://msdn.microsoft.com/en-us/library/ms137786.aspx
Q36. 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: B
Q37. 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.)
A. Partition the fact table by month, and compress each partition.
B. Partition the fact table by week.
C. Partition the fact table by year.
D. Partition the fact table by day, and compress each partition.
Answer: D
Q38. You are implementing a SQL Server Integration Services (SSIS) 2012 package that loads data from various flat files and a Windows Azure SQL Database database.
Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate variable as the transaction date.
You need to set the CurrentDate variable to the date stored in a control table of the Windows Azure SQL Database database when the package starts. You need to achieve this goal by using the least amount of development effort.
What should you use to set the variable?
A. an Expression task
B. an Execute SQL task
C. a Script component
D. a Script task
Answer: B
Q39. You are deploying a new SQL Server Integration Services (SSIS) package to five servers.
The package must meet the following requirements:
. .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled. . The Connection Managers used in the package must be configurable without
editing and redeploying the package.
. The deployment procedure must be automated as much as possible.
. Performance must be maximized.
You need to set up a deployment strategy that meets the requirements.
What should you do?
A. Add an OnError event handler to the SSIS project.
B. Use an msi file to deploy the package on the server.
C. Open a command prompt and run the gacutil command.
D. Open a command prompt and run the dtutil /copy command.
E. Open a command prompt and run the dtexec /rep /conn command.
F. Open a command prompt and run the dtexec /dumperror /conn command.
G. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
H. Create a reusable custom logging component and use it in the SSIS project.
I. Configure the SSIS solution to use the Project Deployment Model.
J. Configure the output of a component in the package data flow to use a data tap.
K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
Answer: D
Q40. You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?
A. SQL Server Configuration Manager
B. SQL Server Agent
C. SSIS Upgrade Wizard in SQL Server Management Studio
D. SQL Server DTExecUI utility (dtexecui.exe)
Answer: C
Explanation:
Use the SSIS Package Upgrade Wizard to migrate packages that were developed in SQL Server 2005 Integration Services (SSIS) and SQL Server 2008 Integration Services (SSIS) to the package format that the current release of Integration Services uses.
Reference: SSIS Upgrade Wizard (SSIS Package Upgrade Wizard)
