Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 141:

  You work as a senior 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 running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the use of Slowly Changing Dimension Transformation Outputs. One of the output options are used to update the record in the lookup

  table.

  Which of the following is the output option?

  A. Unchanged Output
  B. Inferred Member Updates Output
  C. Historical Attributes Inserts Output
  D. Fixed Attribute Output
  E. Changing Attributes Updates Output
  E. Changing Attributes Updates Output

• Question 142:

  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.
  B. Change the similarity threshold to 0.55.

  ---

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

• Question 143:

  You manage a SQL Server Master Data Services (MDS) environment.

  A new application requires access to the product data that is available in the MDS repository.

  You need to design a solution that gives the application access to the product data with the least amount of development effort.

  What should you do?

  A. Use sp_addlinkedserver to add a linked server to access the MDS database tables directly.
  B. Create a Subscription View in MDS.
  C. Use transactional replication for data synchronization.
  D. Create an OLE DB connection string that sets the Provider property to MDS.
  B. Create a Subscription View in MDS.

  ---

  You create a subscription view to export Master Data Services data to a subscribing system such as SQL Server. You use the subscribing system to view the data in the Master Data Services database. References: https://docs.microsoft.com/en-us/sql/master-data-services/overview-exporting-data-master-data-services?view=sql-server-2017

• Question 144:

  You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a SQL Azure database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.

  You have the following requirements:

  The fact table must populate a column named TotalCost that computes the sum of the price and tax columns.

  Before the sum is calculated, any records that have a price of zero must be discarded.

  You need to create the SSIS package in SQL Server Data Tools.

  In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 145:

  You have a SQL Server Integration Services (SSIS) package named Package1.

  You discover that the Data Flow task for Package1 runs slower than expected.

  You need to reduce the amount of time required to run the Data Flow task.

  Which two actions should you perform? Each correct answer presents part of the solution.

  A. Modify the DefaultBufferMaxRows package setting.
  B. Configure the package to run by using the CallerInfooption.
  C. Modify the ForceExecutionResult package setting.
  D. Configure the package to run by using the MaxConcurrent option.
  E. Modify the DefaultBufferSize package setting.
  A. Modify the DefaultBufferMaxRows package setting.
  E. Modify the DefaultBufferSize package setting.

  ---

  References: https://msdn.microsoft.com/en-us/library/ms141031(v=sql.110).aspx

• Question 146:

  You are creating a SQL Server Master Data Services (MDS) model for a company.

  The source data for the company is stored in a single table that contains the manager-to-subordinate relationships.

  You need to create a hierarchy representing the organizational structure of the company.

  Which hierarchy type should you use?

  A. Organizational
  B. Recursive
  C. Non-Mandatory Explicit
  D. Many-to-Many
  E. Natural
  F. Explicit
  G. Parent
  B. Recursive

  ---

  References: http://technet.microsoft.com/en-us/library/ff487006.aspx http://msdn.microsoft.com/en-us/library/ee633747.aspx http://technet.microsoft.com/en-us/library/ee633759.aspx

• Question 147:

  You work as a senior 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 running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the use of Slowly Changing Dimension Transformation Outputs. One of the output options causes Derived Column transformations to

  create columns for the expired row and the current row indicators.

  Which option is the output that causes this?

  A. Unchanged Output
  B. Inferred Member Updates Output
  C. Historical Attributes Inserts Output
  D. Fixed Attribute Output
  E. Changing Attributes Updates Output
  C. Historical Attributes Inserts Output

• Question 148:

  You have a SQL Server Integration Services (SSIS) package that is configured as shown in the exhibit. (Click the Exhibit button.)

  

  You need to recommend changes to the package to reduce load times.

  Which two changes should you recommend? Each correct answer presents part of the solution.

  A. Remove the OLE DB command and use a Script task.
  B. Add an Execute SQL task that batch-updates changed rows.
  C. Set the ValidateExternalMetadata property to False.
  D. Add an Execute SQL task that truncates and reloads the table.
  E. Remove the OLE DB command and use an OLE DB destination.
  B. Add an Execute SQL task that batch-updates changed rows.
  E. Remove the OLE DB command and use an OLE DB destination.

  ---

  If the OLE DB destination uses a fast-load data access mode, you can specify the following fast load options in the user interface, OLE DB Destination Editor, for the destination:

  Keep identity values from the imported data file or use unique values assigned by SQL Server.

  Retain a null value during the bulk load operation.

  Check constraints on the target table or view during the bulk import operation.

  Acquire a table-level lock for the duration of the bulk load operation.

  Specify the number of rows in the batch and the commit size.

  References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/ole-db-destination?view=sql-server-2017#fast-load-options

• Question 149:

  You are the administrator for a Master Data Services (MDS) environment.

  A user who is not an administrator must be able to access Master Data Manager.

  You need to assign permissions to the user.

  Which function should you use?

  A. Explorer
  B. System Administration
  C. Version Management
  D. User and Group Permissions
  E. Integration Management
  D. User and Group Permissions

  ---

  In the User and Group Permissions functional area, administrators can grant permission to functional areas, to attributes (on the Models tab), and to members (on the Hierarchy Members tab). Overlapping permissions are resolved to determine a user's permission to each individual attribute.

  References: https://docs.microsoft.com/en-us/sql/master-data-services/user-and-group-permissions-functional-area-master-data-manager?view=sql-server-2017

• Question 150:

  You plan to design an SQL Server Integration Services (SSIS) package to move data from a source system to an SQL Server database named Warehouse.

  You need to implement a data loading strategy for the package. The solution must ensure that if a failure occurs, the connection automatically resumes from the point of failure.

  How should you configure each package property? To answer, select the appropriate options in the answer area.

  Hot Area: