Online Access Free 070-767 Exam Questions

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 have an on-premises Microsoft SQL Server instance and a Microsoft Azure SQL Data Warehouse instance. You move data from the on-premises database to the data warehouse once each day by using a SQL Server Integration Services (SSIS) package.
You observe that the package no longer completes within the allotted time.
You need to determine which tasks are taking a long time to complete.
Solution: You enable package logging within SSIS.
Does the solution meet the goal?

• A.No
• B.Yes

You need to build a knowledge base in Data Quality Services (DQS).
You need to ensure that the data is validated by using a third-party data source before DQS processes the data.
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.

Correct Answer:

Explanation

Building a DQS knowledge base involves the following processes and components:
Step 1: Perform Knowledge Discovery
A computer-assisted process that builds knowledge into a knowledge base by processing a data sample Step 2: Perform Domain Management An interactive process that enables the data steward to verify and modify the knowledge that is in knowledge base domains, each of which is associated with a data field. This can include setting field-wide properties, creating rules, changing specific values, using reference data services, or setting up term-based or cross-field relationships.
Step 3: Configure reference Data Services
A process of domain management that enables you to validate your data against data maintained and guaranteed by a reference data provider.
Step 4: Configure a Matching Policy
A policy that defines how DQS processes records to identify potential duplicates and non-matches, built into the knowledge base in a computer-assisted and interactive process.
References: https://docs.microsoft.com/en-us/sql/data-quality-services/dqs-knowledge-bases-and-domains

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in the series.
Start of repeated scenario
Contoso. Ltd. has a Microsoft SQL Server environment that includes SQL Server Integration Services (SSIS).
a data warehouse, and SQL Server Analysis Services (SSAS) Tabular and multi-dimensional models.
The data warehouse stores data related to your company sales, financial transactions and financial budgets. All data for the data warehouse originates from the company's business financial system.
The data warehouse includes the following tables:

You must implement a partitioning scheme for the fact. Transaction table to move older data to less expensive storage. Each partition will store data for a single calendar year, as shown in the exhibit (Click the Exhibit button.) You must align the partitions.

The company plans to use Microsoft Azure to store older records from the data warehouse. You must modify the database to enable the Stretch Database capability.
End of repeated scenario
You need to perform the first step to partition the fact .Transaction table.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.

Correct Answer:

Explanation
CREATE PROCEDURE
[DateRange] (INT) AS RANGE LEFT

You have Microsoft Azure SQL Database instances named DB1 and DB2.
The databases are hosted in different regions and contain different tables.
You must allow Transact-SQL queries in DB1 to access data in DB2.
You need to configure DB1 to ensure that you can run queries that join tables from DB1 and DB2.
What should you do?

• A.Configure a linked server connection on remotely. Configure the linked server RPC Out option to TRUE.
• B.Use the CREATE EXTERNAL DATA SOURCE statement to form an external data source for DB1.
  The LOCATION statement must reference the URL for
• C.Create a global shard map on DB2 to the shard map.
• D.Create an elastic database pool. Place into the elastic database pool.

You have a data warehouse that includes a table named [Fact]. [sales]. The table has four partitions. There are no foreign keys defined on the [Fact].[sales] table.
You identify an issue with the first partition. You must reload the data for the first partition as quickly as possible.
You need to prepare the partition for reloading data.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Correct Answer: