You need to design a solution to guarantee that a stored procedure is part of every transaction. What should you do?
A. Enable implicit transactions.
B. Enable Distributed Transaction Coordinator (DTC).
C. Set the NOCOUNT option to ON.
D Set the XACT_ABORT option to ON.
You need to design a database solution that meets the following requirements:
– Supports different types of databases
– Provides reliable messaging between databases
– Provides data workload distribution across several databases
Which SQL Server component should you use?
A. SQL Server Agent
B. SQL Mail
C. Notification Services
D. Service Broker
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database has a table named Sales. The Sales table contains 10 million rows. You discover that the following query takes a long time to execute.
FROM Sales AS s
JOIN Country AS c
ON s.Country_id = c.Country_id
AND c.Country_name = ‘USA’
A summary of the execution plan is as shown in the following code segment. |–Hash Match(Inner Join, HASH:
([s].[Country_id]) = ([c].[Country_id]) |–Clustered Index Scan(OBJECT:([Country].[PK_Country_Country_id] AS
[c]) |–Clustered Index Scan(OBJECT:([Sales].[PK_Sales_Sale_id] AS [s]))
You need to ensure that the query retrieves data in minimum possible time.
What should you do?
A. Modify the query to use a loop join hint.
B. Modify the query to use a merge join hint.
C. Create a nonclustered index in the Country_id column of the Sales table.
D. Create a nonclustered index in the Country_name column of the Country table.
You are designing a database table for a content management system. Users will store images and videos in the database.You need to ensure that the database can store files that are 20 MB or less. The solution must minimize the amount of space required to store the data. Which data type should you use?