2018 May New Microsoft 70-767 Exam Dumps with PDF and VCE Just Updated Today! Following are some new 70-767 Real Exam Questions:
1.|2018 Latest 70-767 Exam Dumps (PDF & VCE ) 287Q Download:
https://www.braindump2go.com/70-767.html
2.|2018 Latest 70-767 Exam Questions & Answers Download:
https://drive.google.com/drive/folders/0B75b5xYLjSSNN1RSdlN6Z0VwRjg?usp=sharing
QUESTION 157
Hotspot Questions
You are developing a SQL Server Integration Services (SSIS) package.
The data source for the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
– The output must include metadata columns that indicate which source columns have changed.
– The output must return only one change row per source row that is modified in the current CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
Answer:
QUESTION 158
Hotspot Questions
You are developing a SQL Server Integration Services (SSIS) package.
The package must run a parameterized query against a Windows Azure SQL Database.
You need to use the least amount of development effort to meet the package requirement.
Which task should you use? (To answer, select the appropriate task in the answer area.)
Answer:
QUESTION 159
Drag and Drop Questions
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ADO object source variable that holds a result set that was returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.
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:
QUESTION 160
You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night.
The Windows Azure SQL Database 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 similarity threshold to 0.40.
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.
Answer: C
Explanation:
– Similarity threshold
Set the similarity threshold at the component level by using the slider.
The closer the value is to 1, the closer the resemblance of the lookup value to the source value must be to qualify as a match. Increasing the threshold can improve the speed of matching since fewer candidate records need to be considered.
Incorrect:
– Maximum number of matches to output per lookup
Specify the maximum number of matches the transformation can return for each input row.
The default is 1.
QUESTION 161
Hotspot Questions
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads rows from a source system and compares them to rows in a destination system. New rows will be inserted and changed rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation.
The Lookup transformation joins the source and destination table on the business key, and includes all columns from the destination table in the data flow output.
The Conditional Split transformation inspects the destination columns and directs data flow to either insert new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)
Answer:
QUESTION 162
Hotspot Questions
You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model-The model consists of two entities: one named Customer and one named State.
You opened the Customer entity.
Currently, data stewards can enter any text value in the Customer entity’s State attribute.
You must restrict the entry of values in the State attribute to members defined in the State entity. You need to configure the State attribute of the Customer entity.
Which command should you use? (To answer, select the appropriate command in the answer area.)
Answer:
QUESTION 163
You maintain a SQL Server Integration Services (SSIS) package.
The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?
A. SQL Server Integration Services Deployment Wizard
B. SQL Server Configuration Manager
C. SSIS Upgrade Wizard in SQL Server Management Studio
D. SSIS Upgrade Wizard in SQL Server 2008 BIDS
Answer: C
Explanation:
You can upgrade packages that were created in earlier versions of Integration Services to the Integration Services format that SQL Server 2012 uses.
SQL Server provides the SSIS Package Upgrade Wizard to help in this process.
Because you can configure the wizard to backup up your original packages, you can continue to use the original packages if you experience upgrade difficulties.
You can run the SSIS Package Upgrade Wizard from SQL Server Data Tools (SSDT), from SQL Server Management Studio, or at the command prompt.
Note:
– When you upgrade an instance of SQL Server 2005 or SQL Server 2008 to the current release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL Server Integration Services uses. You will have to select an upgrade method and manually upgrade your packages.
QUESTION 164
You are preparing to install SQL Server 2012 Master Data Services (MDS).
You need to ensure that the database requirements are met.
What should you install?
A. Microsoft SharePoint Foundation 2010 SP1
B. SQL Server 2012 Enterprise (64-bit) x64 on the database server
C. SQL Server 2012 Data Center (64-bit) x64 on the database server
D. SQL Server 2008 Enterprise (64-bit) x64 on the database server
Answer: B
Explanation:
– Master Data Services is a new feature introduced in SQL Server 2008 R2 and further enhanced in SQL Server 2012.
– SQL Server 2012 Enterprise features include Master Data Services:
Description: Feature Selection
Note:
– Microsoft SQL Server Master Data Services is a Master Data Management (MDM) product from Microsoft, which will ship as a part of the Microsoft SQL Server database.
Originally code-named Bulldog, Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007.
Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications as well as some new features.
Master Data Services first shipped with Microsoft SQL Server 2008 R2.
QUESTION 165
You are installing the Data Quality Server component of Data Quality Services.
You need to provision the hardware and install the software for the server that runs the Data Quality Server.
You must ensure that the minimum Data Quality Server prerequisites are met.
What should you do?
A. Install SQL Server 2012 Database Engine.
B. Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot.
C. Make sure the server has at least 4 GB of RAM.
D. Install Microsoft Internet Explorer 6.0 SP1 or later.
Answer: A
Explanation:
Data Quality Server Minimum System Requirements
– SQL Server 2012 Database Engine.
– Memory (RAM):
Minimum: 2 GB
Recommended: 4 GB or more
Note: SQL Server Data Quality Services (DQS) is a new feature in SQL Server 2012 that contains the following two components: Data Quality Server and Data Quality Client.
QUESTION 166
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database.
The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012.
The package fails when executed on the production server.
You need to ensure that the package can load the Excel workbook data without errors.
You need to use the least amount of administrative effort to achieve this goal.
What should you do?
A. Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
B. Enable Address Windowing Extensions (AWE) for the local SQL Server instance.
C. Replace the SSIS Excel source with a SSIS Flat File source.
D. Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.
Answer: D
Explanation:
XLSX files, the new file type in Excel 2007/2010 can’t be open with Excel Source/Destination in SSIS. To use XLSX in SSIS we need to install ACE driver and use OLE DB Source/Destination to read read/write data in XLSX files.
ACE is a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel 7 (*.xls, *.xlsx, and *.xlsb) files to Microsoft SQL Server.
If the SQL Server or your development box does not have ACE driver then install that 1st.
Note:
– The most efficient way to link to SQL Server is using an OLEDB connection manager.
Incorrect:
Not B:
– Address Windowing Extensions (AWE) is a Microsoft Windows application programming interface that allows a 32-bit software application to access more physical memory than it has virtual address space.
– Address Windowing Extensions (AWE) is a set of extensions that allows an application to quickly manipulate physical memory greater than 4GB. Certain data-intensive applications, such as database management systems and scientific and engineering software, need access to very large caches of data. In the case of very large data sets, restricting the cache to fit within an application’s 2GB of user address space is a severe restriction.
QUESTION 167
Drag and Drop Questions
Your company is evaluating the data cleansing capabilities of SQL Server Data Quality Services (DQS).
A stand-alone server will be used to host DQS, as well as all related services necessary to run this service.
You need to install the DQS components on the server by using the minimum amount of steps possible.
You also need to grant permissions to a login named DataStewards to enable DataStewards to edit and execute DQS projects.
Which four 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:
!!!RECOMMEND!!!
1.|2018 Latest 70-767 Exam Dumps (PDF & VCE ) 287Q Download:
https://www.braindump2go.com/70-767.html
2.|2018 Latest 70-767 Study Guide Video:
