SIMULATION -You have a table named Cities that has the following two columns: CityID and CityName. The CityID column uses the int data type, and CityName uses nvarchar(max).You have a table named RawSurvey. Each row includes an identifier for a question and the number of persons that responded to that question from each of four cities. The table contains the following representative data:A reporting table named SurveyReport has the following columns: CityID, QuestionID, and RawCount, where RawCount is the value from the RawSurvey table.You need to write a Transact-SQL query to meet the following requirements:✑ Retrieve data from the RawSurvey table in the format of the SurveyReport table.✑ The CityID must contain the CityID of the city that was surveyed.✑ The order of cities in all SELECT queries must match the order in the RawSurvey table.✑ The order of cities in all IN statements must match the order in the RawSurvey table.Construct the query using the following guidelines:✑ Use one-part names to reference tables and columns, except where not possible.✑ ALL SELECT statements must specify columns.✑ Do not use column or table aliases, except those provided.Do not surround object names with square brackets.Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.
DRAG DROP -You create three tables by running the following Transact-SQL statements:For reporting purposes, you need to find the active user count for each role, and the total active user count. The result must be ordered by active user count of each role. You must use common table expressions (CTEs).Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.Select and Place:
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 in this series. Information and details provided in a question apply only to that question.You have a database that contains tables named Customer_CRMSystem and Customer_HRSystem. Both tables use the following structure:The tables include the following records:Customer_CRMSystem -Customer_HRSystem -Records that contain null values for CustomerCode can be uniquely identified by CustomerName.You need to display a list of customers that do not appear in the Customer_HRSystem table.Which Transact-SQL statement should you run?A.B.C.D.E.F.G.H.
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 in this series. Information and details provided in a question apply only to that question.You have a database that contains tables named Customer_CRMSystem and Customer_HRSystem. Both tables use the following structure:The tables include the following records:Customer_CRMSystem -Customer_HRSystem -Records that contain null values for CustomerCode can be uniquely identified by CustomerName.You need to display customers who appear in both tables and have a proper CustomerCode.Which Transact-SQL statement should you run?A.B.C.D.E.
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 in this series. Information and details provided in a question apply only to that question.You have a database that contains tables named Customer_CRMSystem and Customer_HRSystem. Both tables use the following structure:The tables include the following records:Customer_CRMSystem -Customer_HRSystem -Records that contain null values for CustomerCode can be uniquely identified by CustomerName.You need to display a Cartesian product, combining both tables.Which Transact-SQL statement should you run?A.B.C.D.E.F.G.H.
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 create a table named Products by running the following Transact-SQL statement:You have the following stored procedure:You need to modify the stored procedure to meet the following new requirements:✑ Insert product records as a single unit of work.✑ Return error number 51000 when a product fails to insert into the database.✑ If a product record insert operation fails, the product information must not be permanently written to the database.Solution: You run the following Transact-SQL statement:Does the solution meet the goal?
