|
Related Questions |
View Answer |
|
You have just upgraded your SQL Server 2000 instance on Windows 2000 to SQL Server 2005. You are looking to begin implementing encryption capabilities and need to choose an algorithm for your data. Which of the following is not available to you?
|
View Answer
|
|
What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
|
View Answer
|
|
Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database
|
View Answer
|
|
Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
|
View Answer
|
|
What does the DEALLOCATE statement do in SQL Server 2005?
|
View Answer
|
|
When you install SQL Server 2005 and create a new database, is a Database Master Key created?
|
View Answer
|
|
You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
|
View Answer
|
|
Where can you view the list of server-scoped DDL triggers?
|
View Answer
|
|
You are setting up a native XML web service on your SQL Server 2005 to respond to inventory requests. How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?
|
View Answer
|
|
You have a few new SQL Server 2005 server instances and you want to be sure that SQL authenticated logins must abide by the password policy. On this platforms can you enforce this?
|
View Answer
|
|
Which protocols support Kerberos authentication on SQL Server 2005?
|
View Answer
|
|
What algorithm is used to encrypt the Database Master Key when it is created?
|
View Answer
|
|
How many users can be added to an application role in SQL Server 2005?
|
View Answer
|
|
You accidently delete an application from an instance of SQL Server 2005 Notification Services. However you have not removed the database, nor the application objects. Can you re-associate the application with the same SSNS instance?
|
View Answer
|
|
Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
|
View Answer
|
|
Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
|
View Answer
|
|
After you've completed a backup for your Sales server to disk, you want to be sure that this backup is intact and able to be used for restores before writing it to tape. What command will help you here?
|
View Answer
|
|
Which utility is used to administer SQL Server 2005 Notification Services instances?
|
View Answer
|
|
You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?
|
View Answer
|
|
Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
|
View Answer
|