70-761

You have a database that tracks orders and deliveries for customers in North America. The database contains the following tables: Application. Cities Sales. CustomerCatagories The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code...

You have a database that tracks orders and deliveries for customers in North America. System versioning is enabled for all tables. The database contains the Sales.Customers, Application. Cities, and Sales. CustomerCategories tables. Details for the Sales.Customers table are shown in the following table: Details for the Application.Cities table are shown...

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 Customer Name. You need to display a list of customers...

DRAG DROP You have a database that stored information about servers and application errors. The database contains the following tables. Servers Errors You are building a webpage that shows the three most common errors for each server. You need to return the data for the webpage. How should you complete...

You create a table by running the following Transact-SQL statement: You need to audit all customer data. Which Transact-SQL statement should you run?A . B . C . D . E . F . G . H . View AnswerAnswer: B

HOTSPOT You need to develop a Transact-SQL statement that meets the following requirements: - The statement must return a custom error when there are problems updating a table. - The error number must be value 50555. - The error severity level must be 14. - A Microsoft SQL Server alert...

You have a database that is denormalized. Users make frequent changes to data in a primary table. You need to ensure that users cannot change the tables directly, and that changes made to the primary table also update any related tables. What should you implement?A . the COALESCE functionB ....

You create a table named Customer by running the following Transact-SQL statement: You must insert the following data into the Customer table: You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?A ....

HOTSPOT You have the following Transact-SQL query: What type of functions are used in the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

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 Customer Name. You need to create a list of all...