70-450 Exam Questions
152 real 70-450 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #101
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...
- Question #102
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...
- Question #103
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...
- Question #104
You administer a SQL Server 2008 infrastructure. Several production databases use Transparent database encryption. You perform full database backups of the production databases as...
- Question #105
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...
- Question #106
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...
- Question #107
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...
- Question #108
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...
- Question #109
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...
- Question #110
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...
- Question #111
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...
- Question #112
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...
- Question #113
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....
- Question #114
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...
- Question #115
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...
- Question #116
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...
- Question #117
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...
- Question #118
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...
- Question #119
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...
- Question #120
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...
- Question #121
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...
- Question #122
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...
- Question #123
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...
- Question #124
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...
- Question #125
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...
- Question #126
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...
- Question #127
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....
- Question #128
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...
- Question #129
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...
- Question #130
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...
- Question #131
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...
- Question #132
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....
- Question #133
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....
- Question #134
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?
- Question #135
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...
- Question #136
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...
- Question #137
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...
- Question #138
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...
- Question #139
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...
- Question #140
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...
- Question #141
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?
- Question #142
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...
- Question #143
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...
- Question #144
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...
- Question #145
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...
- Question #146
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...
- Question #147
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...
- Question #148
Which of the following is not a recommended optimization technique for SQL Server?
- Question #149
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...
- Question #150
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...