Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 211:

  A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.

  To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma-separated values (CSV) file that contains one row per currency.

  You need to download the CSV file to the environment.

  What should you use to retrieve the document from the website?

  A. a Script component
  B. a Web Service task
  C. a Web Service source
  D. a Script task
  D. a Script task

• Question 212:

  You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.

  Referential integrity must be enforced declaratively.

  You need to design a solution that can join a single time dimension to both fact tables.

  What should you do?

  A. Join the two fact tables.
  B. Partition the fact tables by day.
  C. Create a surrogate key for the time dimension.
  D. Create a time dimension that can join to both fact tables at their respective granularity.
  D. Create a time dimension that can join to both fact tables at their respective granularity.

  ---

  Microsoft SQL Server Analysis Services, a time dimension is a dimension type whose attributes represent time periods, such as years, semesters, quarters, months, and days. The periods in a time dimension provide time-based levels of granularity for analysis and reporting. The attributes are organized in hierarchies, and the granularity of the time dimension is determined largely by the business and reporting requirements for historical data

  References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/database-dimensions-create-a-date-type-dimension

• Question 213:

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

  OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by using SQL Server Management Studio.

  You need to execute the package and minimize the number of event types that are logged.

  Which setting should you use? (To answer, change the appropriate setting in the answer area.)

  Hot Area:

  

  

• Question 214:

  You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source and destination. You need to define and reuse the connection managers in all the packages by using the least development effort. What should you do?

  A. Implement parent package variables.
  B. Copy and paste connection managers from one package to the others.
  C. Implement project connection managers.
  D. Implement package connection managers.
  C. Implement project connection managers.

• Question 215:

  A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog.

  To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed.

  You need to create these output files with the least amount of administrative and development effort.

  Which three stored procedures should you execute 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 216:

  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 have been instructed to install the SQL Server Data Quality Services (DQS). The SQL Server Data Quality Services (DQS) is made up of the Data Quality Server and Data Quality Client components.

  Which of the following describes the minimum requirements for installing the Data Quality Client?

  A. 2 GB RAM.
  B. .NET Framework 4.0.
  C. SQL Server 2012 Database Engine.
  D. Internet Explorer 6.0 SP1 or later.
  B. .NET Framework 4.0.
  D. Internet Explorer 6.0 SP1 or later.

• Question 217:

  You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.

  Products for each distributor source must be combined for insertion into a single product table destination.

  You need to select the appropriate data flow transformation to meet this requirement.

  Which two transformations can you use to achieve the goal? Each correct answer presents a complete solution.

  A. Multicast
  B. Merge Join
  C. Term Extraction
  D. union All
  E. Merge
  F. Slowly Changing Dimension
  G. pivot
  H. Lookup
  D. union All
  E. Merge

  ---

  D: The Union All transformation combines multiple inputs into one output. For example, the outputs from five different Flat File sources can be inputs to the Union All transformation and combined into one output.

  E: The Merge transformation combines two sorted datasets into a single dataset. The rows from each dataset are inserted into the output based on values in their key columns.

  By including the Merge transformation in a data flow, you can perform the following tasks:

  * Merge data from two data sources, such as tables and files.

  Etc.

  Incorrect:

  The other commands cannot be used to combine data from two different sources.

  References:

  https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/merge-transformation?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/union-all-transformation?

  view=sql-server-2017

• Question 218:

  A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time errors.

  You need to edit the package to log specific error messages.

  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 219:

  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.

  

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

  Select and Place:

  

  

• Question 220:

  You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog.

  You need to add the Environment to the project.

  Which stored procedure should you use?

  A. catalog.set_environment_reference_type
  B. catalog.set_environment_property
  C. catalog.create_environment_reference
  D. catalog.create_environment
  C. catalog.create_environment_reference

  ---

  Environments (Test, Production etc) are associated with projects by creating references to the environments in the projects.