Microsoft 70-767 Online Practice Questions and Exam Preparation

Microsoft 70-767 Online Questions & Answers

• Question 261:

  To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements:

  A. Deploy the package by using an msi file.
  B. Use the gacutil command.
  C. Create an OnError event handler.
  D. Create a reusable custom logging component.
  E. Use the dtutil /copy command.
  F. Use the Project Deployment Wizard.
  G. Run the package by using the dtexec /rep /conn command.
  H. Add a data tap on the output of a component in the package data flow.
  I. Run the package by using the dtexec /dumperror /conn command.
  J. Run the package by using the dtexecui.exe utility and the SQL Log provider.

  J. Run the package by using the dtexecui.exe utility and the SQL Log provider.

  ---

  http://msdn.microsoft.com/en-us/library/ms140246.aspx http://msdn.microsoft.com/en-us/library/ms180378(v=sql.110).aspx

• Question 262:

  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
  B. Recursive

• Question 263:

  HOTSPOT

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

  You need to edit the Script task that has an expression defined.

  Which task should you select? To answer, select the appropriate setting or settings in the answer area.

  Hot Area:

  

  

• Question 264:

  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. Create a time mapping table.
  B. Partition the fact tables by day.
  C. Create a time dimension that can join to both fact tables at their respective granularity.
  D. Join the two fact tables.
  C. Create a time dimension that can join to both fact tables at their respective granularity.

• Question 265:

  DRAG DROP

  A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2016 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 266:

  You are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model.

  Orders are stored in a table named Factorder. The addresses that are associated with all orders are stored in a fact table named FactAddress. A key in the FoctAddress table specifies the type of address for an order. You need to ensure that business users can examine the address data by either of the following:

  

  shipping address and billing address

  

  shipping address or billing address type Which data model should you use?

  A. star schema
  B. snowflake schema
  C. conformed dimension
  D. slowly changing dimension (SCD)
  E. fact table
  F. semi-additive measure
  G. non-additive measure
  H. dimension table reference relationship
  H. dimension table reference relationship

• Question 267:

  You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.

  In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain.

  You need to complete the mapping of the Group column.

  What should you do?

  A. Map a composite domain to the source column.
  B. Create a composite domain that includes the Group column.
  C. Add a domain for the Group column.
  D. Add a column mapping for the Group column.
  C. Add a domain for the Group column.

• Question 268:

  HOTSPOT

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

  You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job.

  You make changes to the package that should improve performance.

  You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal.

  What should you do?

  A. Enable logging to an XML file in the package control flow for the Onlnformation event. After 10 executions, view the XML file.
  B. After 10 executions, view the job history for the SQL Server Agent job.
  C. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package.
  D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10 executions, view the XML file.
  C. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package.

• Question 270:

  You have a data warehouse that contains all of the sales data for your company.

  You need to design a SQL Server Integration Services (SSIS) package that reports the average value for the one of the columns in a data flow.

  What should you add to the package?

  A. Data profiling tasks that have a Column Null profile.
  B. Data profiling tasks that have Column value Distribution Profile.
  C. Data Profiling tasks that have Column Statistics profile.
  D. the Data Mining Query task.
  B. Data profiling tasks that have Column value Distribution Profile.