70-450 Exam Questions

You administer a SQL Server 2008 instance that hosts a large financial database. The database has the following backup strategies: - A full database backup is performed once a week...

You administer a SQL Server 2008 database solution. All data modifications are performed through stored procedures that use only the INSERT, UPDATE, or DELETE statements. You are d...

You administer a SQL Server 2008 instance that hosts a database. The backup strategy used by the database is as shown in the following table: You run a batch process on Saturday th...

You administer a SQL Server 2008 infrastructure. Several production databases use Transparent database encryption. You perform full database backups of the production databases as...

You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database. The database uses the simple-recovery model. The database contains the following three add...

You administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a ve...

You administer a SQL Server 2008 infrastructure. An instance hosts a business-critical database that must be continuously available to the users without data loss. The database inc...

You administer four SQL Server 2008 instances. Each instance hosts a single database application. You plan to migrate all four instances to a new SQL Server failover cluster. The f...

You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: - 275 GB for the database data file - 50 GB for the trans...

You administer a SQL Server 2008 infrastructure. An instance contains a database that includes a table named EmployeeData. The EmployeeData table has a column named Profile. The co...

You administer a SQL Server 2008 infrastructure. You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third p...

You administer a SQL Server 2008 infrastructure. Your company wants to enforce naming standards for the database objects. You need to design a solution to enforce naming standards...

You administer a SQL Server 2008 instance. You plan to deploy new SQL Server 2008 Integration Services (SSIS) packages that are created by the SQL Server Import and Export Wizard....

You administer a SQL Server 2008 infrastructure. A SQL Server instance contains a transactional database. You design a plan to back up and restore a database. The current transacti...

You administer a SQL Server 2008 infrastructure. There are two instances named Instance1 and Instance2. You plan to distribute the customer table data from Instance1 to Instance2 f...

You administer a SQL Server 2008 infrastructure. You want to monitor information on disk space growth of all the databases in every instance on a daily basis. You plan to design a...

You administer a SQL Server 2008 instance. The instance contains a large mission-critical database that experiences a high volume of DML activity. Users report that the application...

You administer a SQL Server 2008 instance that hosts a large database. The database has the following backup strategy: Full database backups are performed weekly. Differential back...

You are the administrator of a SQL Server 2008 instance with a database named DB1. In the Services schema there is a table named Service.Table. The Services.Table has to be moved f...

You maintain a default SQL Server 2008 instance. You plan to configure FILESTREAM data to meet the following requirements: - Enable FILESTREAM for file I/O streaming access. - Allo...

You configure a SQL Server 2008 instance that contains a database named Customers. The Customers database experiences deadlock problems. You need to capture the deadlock informatio...

You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have m...

You administer a SQL Server 2008 instance. You plan to design the security requirements for a new database application. The application uses a code segment that contains the follow...

You administer a SQL Server 2008 infrastructure. You plan to upgrade a Microsoft SQL Server 2005 instance to SQL Server 2008 by using an in- place upgrade. All user databases use t...

Your SQL Server 2008 server has only the SQL Server service running. All other SQL Services are disabled. You have a user named DBReportsUser. You need to restrict DBReportsUser to...

You administer a SQL Server 2008 instance. You plan to deploy a third-party database application to the instance. The application uses stored procedures that are developed by using...

You administer a SQL Server 2008 instance. The instance is one of three servers in a peer-to-peer transactional replication topology. The publication contains a table named Orders....

You are a professional level SQL Sever 2008 Database Administrator. A large database is hosted by the instance. High volumes of queries and transactions that areprocessor intensive...

You are a professional level SQL Sever 2008 Database Administrator. An authentication method should be designed for SSRS reports that SQL Server data connections are utilized. Sinc...

You administer a SQL Server 2008 instance. You plan to design the security requirements for a new database application that will be deployed to the instance. The new database conta...

You are a professional level SQL Sever 2008 Database Administrator. A database is hosted by the instance, and sensitive data is included in the database. A database backup strategy...

You are a professional level SQL Sever 2008 Database Administrator. A large database is hosted by the instance. The company utilizes the following backup strategy for the database....

One of the developers at your company has written a CLT stored procedures that's clever enough to call a web service and update database records based on local weather information....

When you schedule a SQL Server job you can configure which individuals are alerted about its completion. What is the correct term given to these people that can be alerted?

SQL Server Agent is commonly used to schedule work to be done automatically, such as backing up a database. A SQL Server Agent job contains the definition of the work to be done. W...

A developer in your organisation has added a new table to the company database called PERSON. However, he has forgotten the table structure and his manager needs to recreate the ta...

Side by side upgrades are a common choice when installing SQL 2008 alongside an older version of SQL Server such as 2000 or 2005. Which of the following is not an advantage of SQL...

The tempbd plays an even more important role than in previous versions of SQL Server. This includes DBCC operations, event notifications, large object variables and parameters. Its...

You are in the process of installing SQL 2008 as a a side-by-side upgrade. You want to migrate all databases from SQL 2005 to this new instance. Which method could you use to achie...

Your manager is trying to create a new SQL login using a T-SQL script. This is the command that he is trying to run: CREATE LOGIN users\temp1 FROM WINDOWS MUST CHANGE However, the...

You want to modify the server settings without using the Server properties screen from the Management Studio. Which stored procedure allows you to change server settings?

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs...

Someone from your organisation is complaining that they can't connect to the HR SQL Server using SQL Management Studio. However, they can open the Management Studio ok and other pe...

What is the name given to the process of replacing a table with multiple smaller tables. Each smaller table has the same format as the original table, but with a subset of the data...

What is the name given to the system database that records all the system-level information for an instance of SQL Server.? This includes instance-wide metadata such as login accou...

You are trying to restore a database using the SQL Management Studio but receive an error message stating that the database is in use. You did tell the users to stop using the data...

Stored procedures, triggers and functions can all be written in CLR compatible languages in SQL Server 2008. Why would someone want to use CLR store procedures rather than standard...

Which of the following is not a recommended optimization technique for SQL Server?

Your manager is testing your experience of SQL Server 2008 and stored procedures. He wants you to show him which active users are connected to the server, which tasks they are perf...

A member of staff has requested that you install a SQL tool for data mining. They want to use the tool to identify rules and patterns in the company data and determine why things h...