Câu 26: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

DRAG DROP -You develop a Microsoft SQL Server database. The database contains a table named Status that is defined by the following Transact-SQL statement: There are thousands of rows in the Status table, with significant duplication of data in the Color column. Ninety percent of the rows in the table have Color="Red", and the remaining 10 percent have Color="Green".You want to normalize the Color information in this table. You create a table named Colors that is defined by the following DDL: You populate the new Colors table by using the following Transact-SQL statement:INSERT Colors (ColorName) SELECT DISTINCT Color FROM StatusYou need to ensure that the following requirements are met: ✑ The Status table uses only colors that exist in the Colors table. ✑ Data redundancy in the Status table is reduced. ✑ Data integrity is enforced during the normalization process. Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segment from the list of Transact-SQL segments to the answer area and arrange them in the correct order. Select and Place:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại