Microsoft 70-767 Online Practice Questions and Exam Preparation

Microsoft 70-767 Online Questions & Answers

• Question 211:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  Each night you receive a comma separated values (CSV) file that contains different types of rows. Each row type has a different structure. Each row in the CSV file is unique. The first column in every row is named Type. This column identifies

  the data type.

  For each data type, you need to load data from the CSV file to a target table. A separate table must contain the number of rows loaded for each data type. Solution: You create a SQL Server Integration Services (SSIS) package as shown in the exhibit. (Click the Exhibit tab.)

  

  Does the solution meet the goal?

  A. Yes
  B. No
  B. No

  ---

  The conditional split must be before the count.

• Question 212:

  HOTSPOT

  You are the Master Data Services (MDS) administrator at your company. An existing user needs to integrate data from other systems into MDS.

  You need to give the user permissions to integrate data.

  Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

  Hot Area:

  

  

• Question 213:

  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. Install the Analysis Services OLE DB Provider.
  B. Run the DQSInstaller.exe command.
  C. Run the Configuration component in the Data Quality Client.
  D. Make the data available for DQS operations.
  B. Run the DQSInstaller.exe command.

• Question 214:

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

  Which item should you use?

  A. Script task
  B. Script component configured as a transformation
  C. Script component configured as a source
  D. Script component configured as a destination
  C. Script component configured as a source

• Question 215:

  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 view on the sales table.
  B. Partition the fact tables by day.
  C. Create a surrogate key for the time dimension.
  D. Change the level of granularity in both fact tables to be the same.
  D. Change the level of granularity in both fact tables to be the same.

• Question 216:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen.

  You are the administrator of a Microsoft SQL Server Master Data Services (MDS) instance. The instance contains a model named Geography and a model named customer. The Geography model contains an entity named countryRegion.

  You need to ensure that the countryRegion entity members are available in the customer model.

  Solution: In the Customer model, add a domain-based attribute to reference the CountryRegion entity in the Geography model.

  Does the solution meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 217:

  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. Change the Exhaustive property to True.
  B. Decrease the maximum number of matches per lookup.
  C. Change the similarity threshold to 0.85.
  D. Increase the maximum number of matches per lookup.
  C. Change the similarity threshold to 0.85.

• Question 218:

  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 Team Type, does not yet have a domain. You need to complete the mapping of the Team Type column.

  What should you do?

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

  ---

  Explanation: References:

  http://msdn.microsoft.com/en-us/library/ff877917.aspx http://msdn.microsoft.com/en-us/library/hh213015.aspx http://msdn.microsoft.com/en-us/library/gg524799.aspx

• Question 219:

  You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company's auditing policies have the following requirements:

  A. OnPostExecute
  B. OnWarning
  C. OnExecStatusChanged
  D. OnVariableValueChanged

  A. OnPostExecute

  ---

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

• Question 220:

  You are designing a SQL Server Integration Services (SSIS) 2016 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