we provide Simulation Microsoft 70-463 testing engine which are the best for clearing 70-463 test, and to get certified by Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012. The 70-463 Questions & Answers covers all the knowledge points of the real 70-463 exam. Crack your Microsoft 70-463 Exam with latest dumps, guaranteed!

Check 70-463 free dumps before getting the full version:

NEW QUESTION 1
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 Integration Services Deployment Wizard
  • B. SQL Server Configuration Manager
  • C. SSIS Upgrade Wizard in SQL Server Management Studio
  • D. SSIS Upgrade Wizard in SQL Server 2008 BIDS

Answer: C

Explanation:
You can upgrade packages that were created in earlier versions of Integration Services to the Integration Services format that SQL Server 2012 uses. SQL Server provides the SSIS Package Upgrade Wizard to help in this process. Because you can configure the wizard to backup up your original packages, you can continue to use the original packages if you experience upgrade difficulties.
You can run the SSIS Package Upgrade Wizard from SQL Server Data Tools (SSDT), from SQL Server Management Studio, or at the command prompt.
Note:
* When you upgrade an instance of SQL Server 2005 or SQL Server 2008 to the current release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL Server Integration Services uses. You
will have to select an upgrade method and manually upgrade your packages.

NEW QUESTION 2
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database 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 procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 3
You are the data steward for a Business Intelligence project.
You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.
You need to produce the CSV file with the least amount of development effort. What should you do?

  • A. Create an Integration Services package and use a Data Profiling transform.
  • B. Create a custom .NET application based on the Knowledgebase class.
  • C. Create a data quality project.
  • D. Create a CLR stored procedure based on the Knowledgebase class.
  • E. Create a Master Data Services (MDS) business rule.

Answer: C

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/hh213052.aspx

NEW QUESTION 4
You are implementing a new 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 current execution date 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. A Script component
  • C. A Script task
  • D. An Execute SQL task

Answer: A

Explanation:
Ref: http://msdn.microsoft.com/en-us/library/ms141214.aspx http://blog.sqltechie.com/2012/11/expression-task-in-ssis-2012.html

NEW QUESTION 5
You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met.
What should you install?

  • A. Microsoft SharePoint Foundation 2010 SP1
  • B. SQL Server 2012 Enterprise (64-bit) x64 on the database server
  • C. SQL Server 2012 Data Center (64-bit) x64 on the database server
  • D. SQL Server 2008 Enterprise (64-bit) x64 on the database server

Answer: B

Explanation:
* Master Data Services is a new feature introduced in SQL Server 2008 R2 and further enhanced in SQL Server 2012.
* SQL Server 2012 Enterprise features include Master Data Services:
70-463 dumps exhibit
Note:
* Microsoft SQL Server Master Data Services is a Master Data Management (MDM) product from Microsoft, which will ship as a part of the Microsoft SQL Server database.Originally code-named Bulldog, Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007. Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications as well as some new features. Master Data Services first shipped with Microsoft SQL Server 2008 R2.

NEW QUESTION 6
You are developing a SQL Server Integration Services (SSIS) package.
The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.
You need to create a separate data flow path for data that has been modified since it was last processed.
Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)

  • A. Multicast
  • B. Data Conversion
  • C. Lookup
  • D. Slowly Changing Dimension
  • E. Aggregate

Answer: AC

Explanation:
A: The transformation that distributes data sets to multiple outputs. The transformation that distributes data sets to multiple outputs. C: Lookup Transformation
The transformation that looks up values in a reference table using an exact match. Note:
* SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean dat
A. Destinations load data into data stores or create in-memory datasets. Incorrect:
Not B: Data Conversion Transformation
The transformation that converts the data type of a column to a different data type. Not D: Slowly Changing Dimension Transformation
The transformation that configures the updating of a slowly changing dimension.
Not E: The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across.

NEW QUESTION 7
You have Master Data Services (MDS) in a SQL Server deployment. You need to deploy a model that contains data to the MDS repository. What should you use?

  • A. the Model Deployment Wizard
  • B. the MDSModelDeploy tool
  • C. the Master Data Services Configuration Manager tool
  • D. the Integration Services Deployment Wizard

Answer: B

Explanation:
https://msdn.microsoft.com/en-us/library/ff486956.aspx

NEW QUESTION 8
DRAG DROP
You need to design a data load strategy for a data warehouse fact table. The solution must use an ordered data load.
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.
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 9
Your team is creating SQL Server Integration Services (SSIS) packages that have several dependencies. The packages use parameters for configuration purposes.
Your company's IT policies include the following change control requirements:
After a package is ready for deployment, your team must hand over the process to junior IT personnel.
The process must guarantee that when a package has been validated, that same package (and all its
dependencies) is deployed to production.
The process must be repeatable and reliable and must be executed with the least administrative and training effort by junior IT personnel.
You need to use the most appropriate deployment unit to satisfy the company policies, while minimizing issues such as incorrect version or configuration.
Which type of deployment unit should you use?

  • A. dtsx
  • B. SSIS deployment manifest
  • C. msi
  • D. ispac

Answer: D

NEW QUESTION 10
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012.
The package fails when executed on the production server.
You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal.
What should you do?

  • A. Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
  • B. Enable Address Windowing Extensions (AWE) for the local SQL Server instance.
  • C. Replace the SSIS Excel source with a SSIS Flat File source.
  • D. Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.

Answer: D

Explanation:
XLSX files, the new file type in Excel 2007/2010 cannot be opened with Excel Source/Destination in SSIS. To use XLSX in SSIS we need to install ACE driver and use OLE DB Source/Destination to read read/write data in XLSX files.
ACE is a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel 7 (*.xls, *.xlsx, and *.xlsb) files to Microsoft SQL Server. If the SQL Server or your development box does not have ACE driver then install that 1st.
Note:
* The most efficient way to link to SQL Server is using an OLEDB connection manager. Incorrect:
Not B:
* Address Windowing Extensions (AWE) is a Microsoft Windows application programming interface that allows a 32-bit software application to access more physical memory than it has virtual address space.
* Address Windowing Extensions (AWE) is a set of extensions that allows an application to quickly manipulate physical memory greater than 4GB. Certain data-intensive applications, such as database management systems and scientific and engineering software, need access to very large caches of dat
A. In the case of very large data sets, restricting the cache to fit within an application's 2GB of user address space is a severe restriction.

NEW QUESTION 11
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?

  • A. Use the Expression task.
  • B. Use the Script task.
  • C. Develop a custom task.
  • D. Use the Script component,
  • E. Develop a custom component.

Answer: C

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms135965.aspx http://msdn.microsoft.com/en-us/library/ms345161.aspx

NEW QUESTION 12
DRAG DROP
A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse.
The SSIS catalog includes two Environments:
✑ Development
✑ QA
Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the development or QA data warehouses. You need to be able to execute deployed packages by using either of the defined Environments.
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.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 13
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. .dtsConfig file
  • B. Registry Entry
  • C. Environment Variable
  • D. Parent Package Variable
  • E. XML Configuration File

Answer: C

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms345179.aspx http://msdn.microsoft.com/en-us/library/ms141708.aspx http://msdn.microsoft.com/en-us/library/hh213214.aspx http://msdn.microsoft.com/en-us/library/hh213296.aspx http://msdn.microsoft.com/en-us/library/hh213293.aspx

NEW QUESTION 14
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

NEW QUESTION 15
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

NEW QUESTION 16
To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package.
The following requirements must be met:
All the user information for a given Active Directory group must be downloaded to a SQL Server table. The download process must traverse the Active Directory hierarchy recursively.
You need to configure the package to meet the requirements by using the least development effort. What should you use?

  • A. script component
  • B. custom component
  • C. XML source
  • D. script task

Answer: A

NEW QUESTION 17
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages.
All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed. You need to develop this project with the least amount of development effort.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  • A. Set the Sensitive property of the parameter to True.
  • B. Edit each package Connection Manage
  • C. Set the ServerName property to@[$Project::ServerParam].
  • D. Edit the project Connection Manager in Solution Explore
  • E. Set the ServerName property to@[$Project::ServerParam].
  • F. Create a project parameter named ServerName.
  • G. Create a package parameter named ServerName in each package.
  • H. Set the Required property of the parameter to True.

Answer: CDF

Explanation:
C: From question: "
The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed."
D: SSIS 2012 has introduced the concept of Project level connection managers. An SSIS project is generally more than one package. To simplify lives, the SSIS team now allows for the sharing of common resources across projects, connection managers being one of those resources.
F: When a parameter is marked as required, a server value or execution value must be specified for that parameter. Otherwise, the corresponding package does not execute. Although the parameter has a default value at design time, it will never be used once the project is deployed.
Note:
* Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package
parameters at the package level. Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package.
Reference: Integration Services (SSIS) Parameters

NEW QUESTION 18
DRAG DROP
You are building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL Azure database to a data warehouse. Before the product data is loaded, you create a batch
record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful.
70-463 dumps exhibit
You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products task fails.
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.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141003.aspx http://msdn.microsoft.com/en-us/library/ms141261.aspx http://msdn.microsoft.com/en-us/library/ms141722.aspx http://msdn.microsoft.com/en-us/library/ms139895.aspx

NEW QUESTION 19
Which of the following T-SQL functions is not very useful for capturing lineage information?

  • A. APP_NAME()
  • B. USER_NAME()
  • C. DEVICE_STATUS()
  • D. SUSER_SNAME()

Answer: C

NEW QUESTION 20
HOTSPOT
You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Force packages to load all settings in the configuration. Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration. Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 21
DRAG DROP
A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse.
The SSIS catalog includes two Environments:
Test
Production
Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the test or production data warehouses. You need to execute deployed packages by using either of the defined Environments.
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.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
We need to add references to the Test and Production environments to the project. Then we can map the variables in the project to the environment variables defined in the environments.
When you execute a package in a project that references multiple environments (Test and Production in this case), we can select which environment the package runs under.

NEW QUESTION 22
You have a secured database that contains all of the customer data for your company. You plan to use a project deployment model.
You need to create a SQL Server Integration Services (SSIS) package that connects to the database by using a dedicated username and password. The solution must ensure that the password used for the connection string is encrypted.
Which two actions should you perform? Each correct answer presents part of the solution.

  • A. Modify the set_execution_parameter_value stored procedure.
  • B. Set the package protection level to EncryptSensitiveWithPassword.
  • C. Select the Sensitive check box for the catalog environment.
  • D. Set the sensitive property of the package parameter to True.
  • E. Set the package protection level to EncryptSensitiveWithUserKe

Answer: BD

NEW QUESTION 23
HOTSPOT
You are the Master Data Services (MDS) administrator at your company.
An existing user must be denied access to a certain hierarchy node for an existing model. You need to configure the user's permissions.
Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 24
Your company uses a proprietary encryption algorithm to secure sensitive dat

  • A. 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 databas
  • B. Some of the data must be encrypted with the proprietary encryption algorith
  • C. 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?
  • D. 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.
  • E. Use an SSIS Script transformation that uses the custom assembly to encrypt the data when inserting it.
  • F. 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.
  • G. Use an SSIS Script task that uses the custom assembly to encrypt the data when inserting i

Answer: B

NEW QUESTION 25
DRAG DROP
You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom functionality that is implemented in Microsoft Visual C#.
The implementation of the custom functionality changes overtime. The design of the package allows you to deploy new releases of the custom functionality without redeploying the entire package.
You need to implement and deploy an update to the custom functionality without requiring package redeployment.
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.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 26
DRAG DROP
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 appropriate transformation from the list of options to the correct location or locations in the answer area.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 27
......

Thanks for reading the newest 70-463 exam dumps! We recommend you to try the PREMIUM Dumpscollection.com 70-463 dumps in VCE and PDF here: https://www.dumpscollection.net/dumps/70-463/ (270 Q&As Dumps)