70-450 Exam Questions

You administer a SQL Server 2008 instance. The instance hosts a database configured by using high-safety mirroring operation mode along with a witness server. The witness server is...

You administer a SQL Server 2008 instance that hosts a database solution in a production environment. The database solution uses several SQL Server Agent jobs to periodically trans...

You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated. You need to ensure the successful recovery of any si...

You administer a SQL Server 2008 infrastructure. Your company requires capacity planning information. You need to design a long-term infrastructure monitoring strategy. Which two t...

You administer a SQL Server 2008 instance. Customers report server performance degradation because of a newly implemented process. You use Dynamic Management Views to verify that t...

You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a Windows Server 2008 64-bit server. The awe enabled option is enabled. The instance will exper...

You administer a SQL Server 2008 infrastructure. You discover that an instance experiences performance degradation for the following reasons: - Excessive CPU usage - Server process...

You administer a SQL Server 2008 instance. You plan to design a monitoring solution for the instance to monitor object usage statistics. The solution must identify a list of first...

You administer a SQL Server 2008 infrastructure. A financial application uses several instances across multiple servers. The majority of queries require distributed transactions ac...

You administer a SQL Server 2008 infrastructure. The instance contains a database required for the day-to-day business of your company. Users experience slow response time when the...

You administer a SQL Server 2008 infrastructure. You plan to design a maintenance strategy for a mission-critical database that includes a large table named Orders. The design plan...

You administer a SQL Server 2008 infrastructure. An instance contains a database that includes a large table named OrderDetails. The application queries only execute DML statements...

You administer a SQL Server 2008 infrastructure. Humongous Insurance has 20 branch offices that store customer data in SQL Server 2008 databases. Customer data that is stored acros...

You administer a SQL Server 2008 infrastructure. Developers in your company have rights to author policies. A test server is used to develop and test the policies. The Policy-Based...

You administer a SQL Server 2008 infrastructure. You plan to design a solution to obtain hardware configurations, such as the number of processors on a computer and the processor t...

You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators. A team of application developers create SQL Server 2008 Integration...

You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application. The application has the following requirements: - Users can connect to...

You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the Sales database, and Instance2 contains the Accounts database. A procedure in the...

You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests. The sales te...

You are planning to upgrade a database application that uses merge replication. The table currently has a column type of UNIQUEIDENTIFIER and has a DEFAULT constratin that uses the...

You administer a SQL Server 2008 infrastructure. You plan to deploy a new SQL Server 2008 multi-node failover cluster. The failover cluster uses a storage area network (SAN) that w...

You administer a SQL Server 2005 instance. The instance is configured to use the named pipes network communication protocol. You plan to upgrade the instance to SQL Server 2008. Yo...

You administer a SQL Server 2008 instance. Your company security policy is designed to prevent changes to the server to the server configuration. You plan to use Policy-Based Manag...

You administer a SQL Server 2008 infrastructure. The infrastructure contains SQL Server 2008 servers across four sites. All sites are connected via a WAN link. All sites use the sa...

You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A tabl...

You administer SQL Server 2008 instances at three site. All sites share a mission-critical database. The business requirements specify that users at each site must be able to perfo...

You deploy a new database application to a SQL Server 2008 instance on a server that has 4 processor cores and 64 GB of RAM. The application uses partitioned tables. During testing...

You administer a SQL Server 2008 instance. You plan to design a high-availability solution by using database mirroring. The current application includes programming logic that will...

You administer a SQL Server 2008 instance. The instance hosts a new database application. You plan to design the data security strategy for the application. You will use Snapshot r...

You are a professional level SQL Sever 2008 Database Administrator. A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01. There is a sa...

You are a professional level SQL Sever 2008 Database Administrator. A solution will be implemented to have hardware configurations obtained. The hardware configuration obtained sho...

You are a professional level SQL Sever 2008 Database Administrator. A database is hosted by the instance. You can see the backup strategy utilized by the database from table listed...

You are a professional level SQL Sever 2008 Database Administrator. The largest table in a database is partitioned into four equal-sized parts. The first two partitions are seldom...

You are a professional level SQL Sever 2008 Database Administrator. The capacity planning information is required by your company. A long-term infrastructure monitoring strategy sh...

You are a professional level SQL Sever 2008 Database Administrator. It is on a four-processor, quad-core server. CPU pressure is regularly experienced by the server. An extremely l...

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:...

You are a professional level SQL Sever 2008 Database Administrator. A business-critical database is hosted by the instance, and the database must be constantly available to the use...

You are a professional level SQL Sever 2008 Database Administrator. New SQL Server 2008 Integration Services (SSIS) packages will be deployed, and the packages are created by the S...

You are a professional level SQL Sever 2008 Database Administrator. A new database named Engineering is deployed. Large documents are managed by the Engineering database, and the d...

You are a professional level SQL Sever 2008 Database Administrator. A monitoring solution should be designed for the instance to have object utilization statistics monitored. A lis...

You are a professional level SQL Sever 2008 Database Administrator. A thirdparty database application will be deployed to the instance. Stored procedures are utilized by the applic...

You are designing the storage scheme for a new SQL Server 2008 database application The application will primarily be used to query data. The database will be initially populated w...

You are the database administrator for a SQL Server that hosts an application defined as follows: The database consists of 4 data files and one log file. The physical server has 16...

You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. Th...

You are designing a new SQL Server instance that will support a Web application. The Web application is hosted on a Web farm that contains 32 nodes. The server has 128 GB of memory...

You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses sto...

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 i...

You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks: You need to ensure that an e-mail message is sent to the...

You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Insta...

You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail s...