DRAG DROP A company is designing a database storage strategy. The company wants to segment online transaction processing (OLTP) and analytic workloads. You need to design the workload. Which index types should you use? To answer, drag the appropriate index…
DRAG DROP Note: This question is part of a series of questions that present 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…
DRAG DROP Note: This question is part of a series of questions that present 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…
HOTSPOT You are the administrator of a database that hosts tables for a data warehouse. The table named Fact1 has data from the start of calendar year 2011 through the end of 2017. The table contains at least 20 million…
HOTSPOT You manage the data warehouse for a large retail company. The company has many store locations. Each location runs their own independent sales systems. They report daily sales and receipt information to a central system every night. You plan…
HOTSPOT You have a data warehouse that includes three databases named DB1, DB2, and DB3 respectively. The data warehouse no longer meets the needs of users. You plan to modify the design of the data warehouse. The dimensions in the…
HOTSPOT You have a database that includes a table named dbo.Sales. The table contains two billion rows. You created the table by running the following Transact-SQL statement: You run the following queries against the dbo.Sales. All the queries perform poorly.…
HOTSPOT You are using Microsoft SQL Server data Tools (SSID) to create a SQL Server Information Services (SSIS) package. The package contains a single Data Flow task as shown in the Data Flow exhibit. (Click the Data Flow tab.) Project…
HOTSPOT Note: This question is part of a series of questions that present 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…
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions…