EnsurepassQUESTION 121 You are designing a CLR stored procedure that will access a remote Web service. You need to ensure that the CLR stored procedure can access the remote Web service. Which two actions should you perform? (Each correct answer…
Read more
EnsurepassQUESTION 111 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…
Read more
EnsurepassQUESTION 101 You have a server that runs SQL Server 2008. The server supports an online application. New products are constantly being added to a database stored on the server. You identify the following: – Searches often take too…
Read more
EnsurepassQUESTION 91 You are a database developer. You develop solutions by using SQL Server 2008 in an enterprise environment. You plan to create a stored procedure that queries a sales table and produces forecast data. You do not have administrative…
Read more
EnsurepassQUESTION 81 You need to provide a developer the ability to create and modify database diagrams from an existing database by using SQL Server Management Studio. The solution must minimize the amount of permissions assigned to the developer. What should…
Read more
EnsurepassQUESTION 71 Your company has four offices. Each office contains a server that runs SQL Server 2008. All corporate data is stored in a central location. You need to create a reporting solution. The solution must meet the following requirements:…
Read more
EnsurepassQUESTION 61 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…
Read more
EnsurepassQUESTION 51 You have a table that contains 5 million rows. The table has a clustered index. You plan to add an additional index on a column that contains 80 percent null values. The column is used extensively in WHERE…
Read more
EnsurepassQUESTION 41 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…
Read more
EnsurepassQUESTION 31 You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Employee_Vacation. You are given an updated list of employee vacations used. The list is in…
Read more
EnsurepassQUESTION 21 You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database. What should you create? A. a CHECK constraint B….
Read more
EnsurepassQUESTION 11 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…
Read more