Proper study guides for Improved Microsoft Implementing a SQL Data Warehouse (beta) certified begins with Microsoft 70-767 preparation products which designed to deliver the Realistic 70-767 questions by making you pass the 70-767 test at your first time. Try the free 70-767 demo right now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Microsoft 70-767 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-767 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/70-767-exam-dumps.html
Q1. 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. Natural
B. Explicit
C. Parent
D. Recursive
Answer: D
Explanation:
Reference: http://technet.microsoft.com/en-us/library/ff487006.aspx Reference: http://msdn.microsoft.com/en-us/library/ee633747.aspx Reference: http://technet.microsoft.com/en-us/library/ee633759.aspx
Q2. DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)
Answer:
Q3. You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?
A. Add a data tap on the output of a component in the package data flow.
B. Deploy the package by using an msi file.
C. Run the package by using the dtexecui.exe utility and the SQL Log provider.
D. uses the dtutil /copy command.
E. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
F. Create an OnError event handler.
G. uses the Project Deployment Wizard.
H. Use the gacutil command.
I. Create a reusable custom logging component.
J. Run the package by using the dtexec /rep /conn command.
K. Run the package by using the dtexec /dumperror /conn command.
Answer: A
Explanation:
Reference:
http://www.rafael-salas.com/2021/01/ssis-2021-quick-peek-to-data-taps.html
http://msdn.microsoft.com/en-us/library/hh230989.aspx http://msdn.microsoft.com/en-us/library/jj655339.aspx
Q4. HOTSPOT
You are developing a data flow to load sales data into a fact table. In the data flow, you configure a Lookup Transformation in full cache mode to look up the product data for the sale.
The lookup source for the product data is contained in two tables.
You need to set the data source for the lookup to be a query that combines the two tables. Which page of the Lookup Transformation Editor should you select to configure the query?
To answer, select the appropriate page in the answer area.
Answer:
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx http://msdn.microsoft.com/en-us/library/ms189697.aspx
Q5. DRAG DROP
You are building a fact table in a data warehouse.
The table must have a columnstore index. The table cannot be partitioned. You need to design the fact table and load it with data.
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.)
Answer:
Q6. HOTSPOT
You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools.
A package Connection Manager has been parameterized with project scope.
You need to display the parameters that have been generated for the Connection Manager.
What should you use? To answer, select the appropriate setting or settings in the answer area.
Answer:
Q7. CORRECT TEXT
You administer a Microsoft SQL Server 2021 database. The database contains a table that has the following definition:
You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
✑ The first row of the file contains the first row of data.
✑ Each record is of the same length.
✑ The date follows the U.S. date format.
✑ The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area
that you would configure.)
Answer:
Tick the “Unicode” checkbox. Set the Format option to “Fixed Width”
Untick the “Column names in the first data row” checkbox.
Explanation:
Each record is of the same length = Fixed Width. The file supports international characters = Unicode.
The date follows the U.S. date format = Locale (already configured).
The first row of the file contains the first row of data = Uncheck “Column names in the first data row”
Q8. 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. Change the similarity threshold to 0.55.
C. Change the similarity threshold to 0.40.
D. Increase the maximum number of matches per lookup.
Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms137786.aspx
Q9. You are developing a SQL Server Integration Services (SSIS) package.
You need to design a package to change a variable value during package execution by using the least amount of development effort.
What should you use?
A. Expression task
B. Script task
C. Execute SQL task
D. Execute Process task
E. Term Extraction transformation
Answer: A
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/hh213137.aspx
Q10. DRAG DROP
You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist domain in the knowledge base. The values in the Song column in the dataset can be a close match with the values in the Song domain.
You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to identify duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the answer area.)
Answer:
