CertBus provides the most up to date and accurate preparing materials of the MCSE 70-463 certification exam Q and A , testing software, exam PDF and VCE files to help you prepare your MCSE 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 exam. What training you are looking for? Come to visit our site and choose CertBus online certification materials, you will get a quick and cost-efficient way to become a Microsoft MCSE certified professional in IT industry.
We CertBus has our own expert team. They selected and published the latest 70-463 preparation materials from Microsoft Official Exam-Center: http://www.certgod.com/70-463.html
QUESTION NO:7
DRAG DROP
You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive
property. You need to create a project parameter and configure it so that its value is encrypted
when it is deployed to the SSIS catalog. 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:
QUESTION NO:46
You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a
master list of products. An attribute must be added to the Product entity to define the sales
manager responsible for each product. You need to create an attribute in the Product entity that
prevents users from entering invalid sales manager values. Which type of attribute should you
create?
A. Recursive
B. Explicit
C. Domain-based
D. User-defined
E. Derived
F. Parent
Answer: C
Explanation:
References:
http://msdn.microsoft.com/en-us/library/bb190163.aspx
http://msdn.microsoft.com/en-us/library/ee633737.aspx
http://msdn.microsoft.com/en-us/library/ee633759.aspx
http://msdn.microsoft.com/en-us/library/ee633745.aspx
http://msdn.microsoft.com/en-us/library/ee633724.aspx
http://msdn.microsoft.com/en-us/library/ee633733.aspx
http://msdn.microsoft.com/en-us/library/ff487058.aspx
QUESTION NO:44
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data
mart. The package uses a Lookup transformation to find matches between the source and
destination.
The data flow has the following requirements:
New rows must be inserted.
Lookup failures must be written to a flat file.
In the Lookup transformation, the setting for rows with no matching entries is set to Redirect rows
to no match output. You need to configure the package to direct data into the correct destinations.
How should you design the data flow outputs? (To answer, drag the appropriate transformation
from the list of answer options to the correct location in the answer area.)
Answer:
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/bb895366.aspx
QUESTION NO:6
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. SSIS Upgrade Wizard in SQL Server 2008 BIDS
B. SSIS Upgrade Wizard in SQL Server Data Tools
C. SQL Server DTExecUI utility (dtexecui.exe)
D. SQL Server dtexec utility (dtexec.exe)
Answer: B
QUESTION NO:35
You are developing a SQL Server Integration Services (SSIS) package to load data into a data
warehouse.
You need to establish the correct order for loading each table to maximize parallel processing. Which
order should you use?
A. 1. DimCurrency, DimScenario, DimAccount in parallel
2. DimOrganization
3. FactFinance
B. l. DimCurrency, DimOrganization in parallel
2. DimScenario, DimAccount in parallel
3. FactFinance
C. 1. DimCurrency, FactFinance in parallel
2. DimOrganization, DimScenario, DimAccount in parallel
D. 1. FactFinance
2. DimOrganization, DimScenario, DimAccount in parallel
3. DimCurrency
E. 1. DimCurrency
2. DimOrganization
3. DimScenario, DimAccount in parallel
4. FactFinance
Answer: A
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms139892.aspx
http://msdn.microsoft.com/en-us/library/ms141261.aspx
QUESTION NO:16
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging
methodology is put in place. The methodology has the following requirements:
The deployment process must be simplified.
All the logs must be centralized in SQL Server.
Log data must be available via reports or T-SQL.
Log archival must be automated.
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. Open a command prompt and run the gacutil command.
B. Open a command prompt and execute the package by using the SQL Log provider and running the
dtexecui.exe utility.
C. Add an OnError event handler to the SSIS project.
D. Use an msi file to deploy the package on the server.
E. Configure the output of a component in the package data flow to use a data tap.
F. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in
SQL Server.
G. Open a command prompt and run the dtexec /rep /conn command.
H. Open a command prompt and run the dtutil /copy command.
I. Open a command prompt and run the dtexec /dumperror /conn command.
J. Configure the SSIS solution to use the Project Deployment Model.
K. Create a reusable custom logging component and use it in the SSIS project.
Answer: J
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
QUESTION NO:4
DRAG DROP
A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor
data feed. The package is executed several times a day, either as part of other packages\’ control flow
or by itself. The external data feed is unreliable because network failures and slow response times
are frequent. The package is currently deployed on the file system. To analyze the reliability of the
external data feed, you must collect execution data. Every time the DataFeed package is executed,
the following information must be logged:
Start Time
End Time
Execution Result
Execution Duration
You need to design a logging solution that meets the requirements by using the least amount of
administrative and development effort. 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 NO:9
You are reviewing the design of an existing fact table named factSales, which is loaded from a SQL
Azure database by a SQL Server Integration Services (SSIS) package each day. The fact table has
approximately 1 billion rows and is dimensioned by product, sales date, and sales time of day.
The database administrator is concerned about the growth of the database. Users report 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. Partition the table by product type.
B. Create a view over the fact table to aggregate sales by month.
C. Change the granularity of the fact table to month.
D. Create an indexed view over the fact table to aggregate sales by month.
Answer: C
QUESTION NO:1
You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages.
The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP
site to download sales transaction data. You create project parameters to store the username and
password that are used to access the FTP site. You need to ensure that the username and password
values are encrypted when they are deployed. What should you do?
A. set the Sensitive property of the parameters to True.
B. Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.
C. Change the parameters to package parameters.
D. Change the project to the Legacy Deployment model.
Answer: A
QUESTION NO:14
You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is
named Quotes. The table has no indexes and consists of seven columns:
[ID]
[QuoteDate]
[Open]
[Close]
[High]
[Low]
[Volume]
Each of the following queries must be able to use a columnstore index:
SELECT AVG ([Close]) AS [AverageClose] FROM Quotes WHERE [QuoteDate] BETWEEN
\’20100101\’ AND \’20101231\’.
SELECT AVG([High] – [Low]) AS [AverageRange] FROM Quotes WHERE [QuoteDate]
BETWEEN \’20100101\’ AND \’20101231\’.
SELECT SUM([Volume]) AS [SumVolume] FROM Quotes WHERE [QuoteDate] BETWEEN \’20100101\’
AND \’20101231\’.
You need to ensure that the indexing strategy meets the requirements. The strategy must also
minimize the number and size of the indexes. What should you do?
A. Create one columnstore index that contains [ID], [Close], [High], [Low], [Volume], and
[QuoteDate].
B. Create three coiumnstore indexes:
One containing [QuoteDate] and [Close]
One containing [QuoteDate], [High], and [Low]
One containing [QuoteDate] and [Volume]
C. Create one columnstore index that contains [QuoteDate], [Close], [High], [Low], and [Volume].
D. Create two columnstore indexes:
One containing [ID], [QuoteDate], [Volume], and [Close]
One containing [ID], [QuoteDate], [High], and [Low]
Answer: C
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/gg492088.aspx
Reference: http://msdn.microsoft.com/en-us/library/gg492153.aspx
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 70-463 exam successfully with our Microsoft materials. CertBus Implementing a Data Warehouse with Microsoft SQL Server 2012 exam PDF and VCE are the latest and most accurate. We have the best Microsoft in our team to make sure CertBus Implementing a Data Warehouse with Microsoft SQL Server 2012 exam questions and answers are the most valid. CertBus exam Implementing a Data Warehouse with Microsoft SQL Server 2012 exam dumps will help you to be the Microsoft specialist, clear your 70-463 exam and get the final success.
70-463 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1ma0UzTU1tcmMzdWM/view?usp=sharing
70-463 Microsoft exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/70-463.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.
 |  |  |  |  | |
|---|---|---|---|---|---|
 |  | | |  | |
| Brand | Certbus | Testking | Pass4sure | Actualtests | Others |
| Price | $45.99 | $124.99 | $125.99 | $189 | $69.99-99.99 |
| Up-to-Date Dumps |  |  | | | |
| Free 365 Days Update | | | | | |
| Real Questions | | | | | |
| Printable PDF | | | | | |
| Test Engine | | | | | |
| One Time Purchase | | | | | |
| Instant Download | | | | | |
| Unlimited Install | | | | | |
| 100% Pass Guarantee | | | | | |
| 100% Money Back | | | | | |
| Secure Payment | | | | | |
| Privacy Protection | | | | | |