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 the series. Information and details provided in a question apply only to that question.
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
- Return a value of 0 if data is inserted successfully into the Customers table.
- Return a value of 1 if data is not inserted successfully into the Customers table.
- Support logic that is written by using managed code.
- Support TRY...CATCH error handling.
What should you create?

• A. DML trigger
• B. scalar-valued function
• C. DDL trigger
• D. CLR procedure
• E. table-valued function
• F. extended procedure
• G. user-defined procedure

You have two databases with the following settings:

You run the following Transact -SQL statements:

You need to select data from DiskTable and insert the data into MemTable. You must complete the insertion operation into MemTable as an explicit transaction without immediate durability.
Which four Transact-SQL segments should you use? 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.

Your database contains a table named Invoices with a unique identifier column named InvoiceID.
You have a batch update process that reads data from an input file and updates the table.
You create a clustered columnstore index on the table and must update the configuration to meet the following requirements:
* The table must remain online.
* Perform analytic queries during business hours.
* Each row must have a unique key.
You need to configure the index to optimize performance.
Which three 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.

You have a view that includes an aggregate.
You must be able to change the values of columns in the view. The changes must be reflected in the tables that the view uses.
You need to ensure that you can update the view.
What should you create?

• A. a partitioned view
• B. a DML trigger
• C. table-valued function
• D. a schema-bound view

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 independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are a database developer for a company. The company has a server that has multiple physical disks. The disks are not part of a RAID array. The server hosts three Microsoft SQL Server instances. There are many SQL jobs that run during off-peak hours.
You must monitor and optimize the SQL Server to maximize throughput, response time, and overall SQL performance.
You need to identify previous situations where a modification has prevented queries from selecting data in tables.
What should you do?

• A. Create a sp_configure 'max server memory'query.
• B. Create an Extended Event.
• C. Create a Performance Monitor Data Collector Set.
• D. Create a sys.dm_exec_sessions query.
• E. Create a sys.dm_os_memory_objects query.
• F. Create a sys.dm_os_waiting_tasks query.
• G. Create a sys.dm_os_wait_stats query.
• H. Create a SQL Profiler trace.