Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 191:

  Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series.

  Information and details provided in a question apply only to that question.

  You are developing a SQL Server Integration Services (SSIS) package.

  To process complex scientific data originating from a Microsoft Azure SQL Database database, a custom task component is added to the project.

  You need to ensure that the custom component is deployed on a test environment correctly.

  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.
  C. Open a command prompt and run the gacutil command.

  ---

  References: http://msdn.microsoft.com/en-us/library/ms403356.aspx

• Question 192:

  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.

  

  Support several packages with different configuration settings.

  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.

  Hot Area:

  

  

• Question 193:

  You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

  You are in the process of creating a SQL Server Integration Services (SSIS) project. You have created an initial package that is configured to include a connection manager that was created at the package level. The connection manager is

  used to access a flat file. Subsequent to creating more packages within the project, you change the package Connection Manager in the initial package to a project Connection Manager.

  Which of the following is a reason for doing so?

  A. It allows all packages in the project to access the flat file.
  B. It only allows the initial package in the project to access the flat file.
  C. It only allows the additional packages in the project to access the flat file.
  D. It prevents all packages in the project from accessing the flat file.
  A. It allows all packages in the project to access the flat file.

• Question 194:

  You are developing a data flow transformation to merge two data sources. One source contains product data and the other source contains data about the country in which the product was manufactured. Both data sources contain a two-character CountryCode column and both use SQL Server. Both data sources contain an ORDER BY clause to sort the data by the CountryCode column in ascending order.

  You use a Merge Join transformation to join the data.

  

  You need to ensure that the Merge Join transformation works correctly without additional transformations. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  A. Change the ORDER BY clause on the product source to order by ProductName.
  B. Change the Merge Join transformation to a Merge transformation.
  C. Set the appropriate SortKeyPosition properties on the data sources.
  D. Set the IsSorted property on both data sources.
  E. Set the ValidateExternalMetaData property on the Merge Join transformation to True.
  F. Set the MaxBuffersPerlnput property on the Merge Join transformation to 2.
  C. Set the appropriate SortKeyPosition properties on the data sources.
  D. Set the IsSorted property on both data sources.

  ---

  References: http://msdn.microsoft.com/en-us/library/ms141775.aspx http://msdn.microsoft.com/en-us/library/ms137653.aspx http://siddhumehta.blogspot.com/2009/05/validateexternalmetadata-property.html http://msdn.microsoft.com/en-us/library/ms135950.aspx

• Question 195:

  You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).

  You need to complete the post-installation configuration.

  What should you do?

  A. Run the dbimpexp.exe command
  B. Install the data provides that are used for data refresh
  C. Run the Data Quality Server Installer
  D. Run the Configuration component in the Data Quality Client
  C. Run the Data Quality Server Installer

  ---

  After you complete the SQL Server installation wizard, you must perform additional steps mentioned in this section to complete your Data Quality Server installation, configure it, and then use it.

  To complete the Data Quality Server installation, run the DQSInstaller.exe file.

  References: http://msdn.microsoft.com/en-us/library/gg492277.aspx http://msdn.microsoft.com/en-us/library/ff877917.aspx

• Question 196:

  A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012 packages. The environment that you are deploying the packages to has the following constraints:

  The operating system is Windows Server 2008 R2.

  The SSIS packages are stored in the SSIS catalog.

  Some of these SSIS packages use 32-bit custom components.

  You need to install only the components that are required to deploy and run the packages on the new server.

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

  Select and Place:

  

  

• Question 197:

  You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. The SSIS package has the following requirements:

  

  Every night, a very large amount of data is imported into the staging database.

  

  Package processing time must be minimized.

  

  The package must run on its own dedicated server when it is deployed to production.

  

  Transaction log activity when data is imported must be minimized.

  You need to design the package to meet the requirements. Which destination component should you use?

  A. Raw File
  B. ODBC
  C. Bulk Insert
  D. OLE DB
  D. OLE DB

• Question 198:

  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
  B. SQL Server 2012 Enterprise (64-bit) x64 on the database server

  ---

  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:

  

  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.

• Question 199:

  You are designing a data warehouse for a fresh food distribution business that stores sales 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. ConnectfactSales 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.
  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.

• Question 200:

  You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012.

  The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter.

  You need to create a solution to meet the requirements by using the least amount of administrative effort and maximizing data flow performance.

  What should you do?

  A. Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it.
  B. Use an SSIS Script transformation that uses the custom assembly to parse the text data when inserting it.
  C. Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
  D. Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
  A. Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it.