70-228 Exam
Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
- Exam Number/Code : 70-228
- Exam Name : Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
- Questions and Answers : 209 Q&As
- Update Time: 2011-09-21
- Price:
$ 119.00$ 69.00
Free 70-228 Demo Download
Test4pass offers free demo for MCSE 2003 70-228 exam (Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Exam Description
It is well known that 70-228 exam test is the hot exam of Microsoft certification. Test4pass offer you all the Q&A of the 70-228 real test . It is the examination of the perfect combination and it will help you pass 70-228 exam at the first time!
Why choose Test4pass 70-228 braindumps
Quality and Value for the 70-228 Exam
100% Guarantee to Pass Your 70-228 Exam
Downloadable, Interactive 70-228 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.
Microsoft MCSE 2003 70-228 exam braindumps questions and answers
¡¡
¡¡
Exam : Microsoft 70-228
Title : Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
1. You are the administrator of a SQL Server 7.0 computer. Developers in your company use this server to create client/server applications. You want to install SQL Server 2000 on this server. You want to ensure that developers can begin migrating their applications to the server. You need to maintain the SQL Server 7.0 installation until the migration is complete.
You need to install SQL Server 2000 to support the migration. What are two possible ways of installing SQL Server 2000 to achieve your goal? (Each correct answer presents a complete solution. Choose two.)
A. as a named instance
B. as the default instance
C. on a second computer
D. on a separate partition
E. in the C:MSSQL7 folder
Answer: AC
2. You are the database administrator for a university. You are migrating a database from an old database management system to SQL Server 2000. You export student data from the database to a text file. All students have unique ID numbers. In the file, the student data is ordered according to these ID numbers.
On the server, you create a table named Students. You create indexes on the Students table as shown in the following output.
index_description index_keys
nonclustered lastName, firstName
clustered, unique, primary key studentID
You want to load the student data into the new database as quickly as possible by using the BULK INSERT statement. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)
A. Specify an ORDER clause.Sort the student ID numbers in ascending order.
B. Specify an ORDER clause.Sort the student ID numbers in descending order.
C. Drop both indexes from the Students table before using the BULK INSERT statement.Re-create the indexes when the data load is complete.
D. Drop the nonclustered index from the Students table before using the BULK INSERT statement.Re-create the nonclustered index when the data load is complete.
E. Drop the clustered index from the Students table before using the BULK INSERT statement.Re-create the clustered index when the data load is complete.
Answer: AD
3. You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit. (Click the <<ItemExhibitName>> button.)
The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log.You want to optimize database performance. What should you do?
A. Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F.
B. Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F.
C. Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive F.
D. Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E.
Answer: A
4. You are the administrator of a SQL Server 2000 computer. When you arrive at work, you learn that power to the server has been interrupted.You need to find out whether the power loss damaged the databases on the server. You also need to correct any damage that occurred as quickly as possible. You have valid backups of each database previous to the power loss.What should you do?
A. Select the torn page detection option for each database.If torn pages are detected, execute the DBCC CHECKDB statement, and specify the REPAIR_FAST option.
B. Execute the Sp_table_validation stored procedure for all tables in each database.If errors are detected, restore each damaged database from the most recent backup.
C. Execute the DBCC CHECKDB statement, and specify the PHYSICAL_ONLY option.If errors are detected, execute the DBCC DBREPAIR statement for each damaged database.
D. Execute the DBCC CHECKDB statement, and specify the PHYSICAL_ONLY option.If errors are detected, restore the database from the most recent backup.
Answer: D
5. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales that has two data files and one transaction log file. Each data file is located on its own hard disk and exists in its own filegroup.You perform full database, differential, and transaction log backups on a regular basis. All backups made during a single week are striped across three disk backup devices. A portion of the header information for the current week's backups is shown in the following table.
BackupName BackupType BackupFinishDate
----------------------- --------------- ---------------------------
sales_db_20000625 1 2000-06-25 21:57:04.000
sales_tl_20000626_1 2 2000-06-26 11:04:22.000
sales_tl_20000626_2 2 2000-06-26 15:06:33.000
sales_df_20000626 5 2000-06-26 21:15:48.000
sales_tl_20000627_1 2 2000-06-27 11:03:39.000
sales_tl_20000627_2 2 2000-06-27 15:04:59.000
sales_df_20000627 5 2000-06-27 21:31:13.000
sales_tl_20000628_1 2 2000-06-28 11:05:16.000
On June 28, 2000, at 1:47 P.M., the hard disk that contains the PRIMARY filegroup fails. You want to recover as much data as possible.What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Backup the transaction log by using the NO_LOG option.
B. Backup the transaction log by using the NO_TRUNCATE option.
C. Restore the most recent full database backup.
D. Restore the most recent differential backup.
E. Restore all differential backups in sequence.
F. Restore all transaction log backups in sequence.
G. Restore all transaction logs since the most recent differential backup.
Answer: BCDG
6. You are the administrator of a SQL Server 2000 computer named CorpSql. The server is a member of a Microsoft Windows NT domain named CORPDOMAIN. CorpSql is configured for Windows Authentication and contains three databases named Sales Finance and Research Sophie is an administrative assistant in your company. She uses a suite of client/server applications to access all three databases on CorpSql. Sophie transfers to a different department within the company and requires access only to the Research database. Her former manager requests that you remove Sophie's access to the Sales And Finance databases.
You need to configure the appropriate permissions for Sophie. Which batch of Transact-SQL statements should you execute?
A. USE Finance
GO
EXEC sp_revokedbaccess Sophie
USE Sales
GO
EXEC sp_revokedbaccess Sophie
B. USE Finance
GO
EXEC sp_addrolemember 'db_denydatareader','Sophie'
USE Sales
GO
EXEC sp_addrolemember 'db_denydatareader','Sophie'
C. USE Master
GO
EXEC sp_droplogin 'CorpDomainSophie'
GO
D. USE Finance
GO
EXEC sp_denylogin 'Sophie'
USE Sales
GO
EXEC sp_grantlogin 'Sophie'
Answer: A
7. You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.
During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL Server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.
You contact the application vendor and discover that the Financials application requires the SQL_Latin1_General_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.
What should you do?
A. Rerun SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B. Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C. Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D. Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
Answer: C
8. You are the administrator of a Microsoft Windows 2000 Advanced Server computer. The server is used to run only SQL Server 2000. Users report that database performance slows each day at 10:00 A.M. You use System Monitor to examine the server's performance and receive the results shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You need to discover why database performance is slow. What should you do?
A. Configure disk quotas on the file system, and track each database user's disk utilization.
B. Configure SQL Profiler to trace all queries that are submitted to the server.
C. Use the Sp_who stored procedure to discover who is using the database.
D. Use the Sessions folder in the Computer Management console to discover who is connected to the server.
Answer: B
9. You are the administrator of a Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.Your company contains a variety of client computers that will connect to the SQL Server 2000 computer by using a specific Net-Library, as shown in the following table.
You need to allow the client computers to connect to the SQL Server computer. You also want to minimize the number of configuration changes required on the client computers.
Which three actions should you take? (Each correct answer presents part of the solution. Choose three.)
A. Install SQL Server 2000 as a named instance.
B. Install SQL Server 2000 as the default instance.
C. Configure the new instance for Mixed Mode authentication.
D. Configure the new instance for Windows Authentication.
E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.
F. Configure the server to use the Multiprotocol Net-Library.
Answer: BCE
10. You are the administrator of a SQL Server 2000 computer. You import a large amount of data into the Contracts database. After the import, you perform a full database backup. You examine the hard disk and discover that the log file has grown from 200 MB to 800 MB.
You want to recover disk space as quickly as possible without losing backup information. Which two Transact-SQL statements should you execute? (Each correct answer presents part of the solution. Choose two.)
A. BACKUP LOG Contracts WITH no_log
B. BACKUP LOG Contracts WITH truncate_only
C. BACKUP LOG Contracts To disk='E:SQLBackupContracts_Log.bkp'
D. ALTER DATABASE Contracts
(Name=Contract_Log.ldf,
FILENAME='E:DataContracts.ldf',
SIZE=200)
E. DBCC ShrinkDatabase (Contracts, 200)
F. DBCC ShrinkFile (Contracts_Log, 200)
Answer: CF
11. You are the administrator of a SQL Server 2000 computer at your company's warehouse. All product orders are shipped from this warehouse. Orders are received at 30 sales offices. Each sales office offers a range of products specific to its region.Each sales office contains one SQL Server 2000 computer. These servers connect to the warehouse through dial-up connections as needed, typically once a day. Each sales office needs data pertaining only to its region.You need to replicate inventory data from the server at the warehouse to the servers at the sales offices. You want to minimize the amount of time needed to replicate the data.
Which three actions should you take? (Each correct answer presents part of the solution. Choose three.)
A. Create one publication for each Subscriber.
B. Create one publication for all Subscribers.
C. Enable horizontal filtering.
D. Enable vertical filtering.
E. Use pull subscriptions.
F. Use push subscriptions.
Answer: ACE
12. You are the administrator of a SQL Server 2000 computer. The server is used in your company's research department to store confidential information about projects. The ResearchProjects table is configured as shown in the exhibit. (Click the <<ItemExhibitName>> button.)
The statisticians in your company need to review information about completed projects. The statisticians belong to a database role named StatUsers.
You need to allow the statisticians to access the information on completed projects, while protecting the information on projects that are still in progress. The statisticians must not be able to modify any data.
Which batch of Transact-SQL statements should you execute?
A. CREATE VIEW StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
GO
GRANT SELECT ON StatView TO StatUsers
B. CREATE VIEW StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
WHERE ProjectComplete = 1
GO
GRANT SELECT ON StatView TO StatUsers
C. CREATE PROCEDURE StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
WHERE ProjectComplete = 1
GO
GRANT SELECT ON StatView TO StatUsers
D. CREATE PROCEDURE StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
GO
GRANT SELECT ON StatView TO StatUsers
Answer: B
13. You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.hen parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You want the database to update the InStock field automatically. What should you do?
A. Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B. Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C. Use a view that creates an InStock field as part of an aggregate query.
D. Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table.Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.
Answer: A
14. You are the administrator of a SQL Server 2000 computer. You configure the SQLServerAgent service as shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You configure several SQL Server Agent jobs to perform maintenance tasks. These jobs delete old database records and copy files from the server to file servers on your network.
You discover that none of the jobs will execute. You use SQL Server Enterprise Manager to check the jobs and discover that the SQLServerAgent service will not start.
You need to allow the SQLServerAgent service to start and execute the jobs. What should you do?
A. Configure the SQLServerAgent service to start by using the local system account.
B. Grant the SQLAgent domain user account the Logon as a service rights.
C. Add the SQLAgent domain user account as a Microsoft Windows login on the server.
D. Configure permissions on the master database to allow full access to the SQLAgent user account.
Answer: B
Click Online chat to talk with us , get more informations about Microsoft MCSE 2003 70-228 practice exam study guides questions and answers
¡¡
Exam : Microsoft 70-228
Title : Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
1. You are the administrator of a SQL Server 7.0 computer. Developers in your company use this server to create client/server applications. You want to install SQL Server 2000 on this server. You want to ensure that developers can begin migrating their applications to the server. You need to maintain the SQL Server 7.0 installation until the migration is complete.
You need to install SQL Server 2000 to support the migration. What are two possible ways of installing SQL Server 2000 to achieve your goal? (Each correct answer presents a complete solution. Choose two.)
A. as a named instance
B. as the default instance
C. on a second computer
D. on a separate partition
E. in the C:MSSQL7 folder
Answer: AC
2. You are the database administrator for a university. You are migrating a database from an old database management system to SQL Server 2000. You export student data from the database to a text file. All students have unique ID numbers. In the file, the student data is ordered according to these ID numbers.
On the server, you create a table named Students. You create indexes on the Students table as shown in the following output.
index_description index_keys
nonclustered lastName, firstName
clustered, unique, primary key studentID
You want to load the student data into the new database as quickly as possible by using the BULK INSERT statement. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)
A. Specify an ORDER clause.Sort the student ID numbers in ascending order.
B. Specify an ORDER clause.Sort the student ID numbers in descending order.
C. Drop both indexes from the Students table before using the BULK INSERT statement.Re-create the indexes when the data load is complete.
D. Drop the nonclustered index from the Students table before using the BULK INSERT statement.Re-create the nonclustered index when the data load is complete.
E. Drop the clustered index from the Students table before using the BULK INSERT statement.Re-create the clustered index when the data load is complete.
Answer: AD
3. You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit. (Click the <<ItemExhibitName>> button.)
The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log.You want to optimize database performance. What should you do?
A. Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F.
B. Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F.
C. Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive F.
D. Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E.
Answer: A
4. You are the administrator of a SQL Server 2000 computer. When you arrive at work, you learn that power to the server has been interrupted.You need to find out whether the power loss damaged the databases on the server. You also need to correct any damage that occurred as quickly as possible. You have valid backups of each database previous to the power loss.What should you do?
A. Select the torn page detection option for each database.If torn pages are detected, execute the DBCC CHECKDB statement, and specify the REPAIR_FAST option.
B. Execute the Sp_table_validation stored procedure for all tables in each database.If errors are detected, restore each damaged database from the most recent backup.
C. Execute the DBCC CHECKDB statement, and specify the PHYSICAL_ONLY option.If errors are detected, execute the DBCC DBREPAIR statement for each damaged database.
D. Execute the DBCC CHECKDB statement, and specify the PHYSICAL_ONLY option.If errors are detected, restore the database from the most recent backup.
Answer: D
5. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales that has two data files and one transaction log file. Each data file is located on its own hard disk and exists in its own filegroup.You perform full database, differential, and transaction log backups on a regular basis. All backups made during a single week are striped across three disk backup devices. A portion of the header information for the current week's backups is shown in the following table.
BackupName BackupType BackupFinishDate
----------------------- --------------- ---------------------------
sales_db_20000625 1 2000-06-25 21:57:04.000
sales_tl_20000626_1 2 2000-06-26 11:04:22.000
sales_tl_20000626_2 2 2000-06-26 15:06:33.000
sales_df_20000626 5 2000-06-26 21:15:48.000
sales_tl_20000627_1 2 2000-06-27 11:03:39.000
sales_tl_20000627_2 2 2000-06-27 15:04:59.000
sales_df_20000627 5 2000-06-27 21:31:13.000
sales_tl_20000628_1 2 2000-06-28 11:05:16.000
On June 28, 2000, at 1:47 P.M., the hard disk that contains the PRIMARY filegroup fails. You want to recover as much data as possible.What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Backup the transaction log by using the NO_LOG option.
B. Backup the transaction log by using the NO_TRUNCATE option.
C. Restore the most recent full database backup.
D. Restore the most recent differential backup.
E. Restore all differential backups in sequence.
F. Restore all transaction log backups in sequence.
G. Restore all transaction logs since the most recent differential backup.
Answer: BCDG
6. You are the administrator of a SQL Server 2000 computer named CorpSql. The server is a member of a Microsoft Windows NT domain named CORPDOMAIN. CorpSql is configured for Windows Authentication and contains three databases named Sales Finance and Research Sophie is an administrative assistant in your company. She uses a suite of client/server applications to access all three databases on CorpSql. Sophie transfers to a different department within the company and requires access only to the Research database. Her former manager requests that you remove Sophie's access to the Sales And Finance databases.
You need to configure the appropriate permissions for Sophie. Which batch of Transact-SQL statements should you execute?
A. USE Finance
GO
EXEC sp_revokedbaccess Sophie
USE Sales
GO
EXEC sp_revokedbaccess Sophie
B. USE Finance
GO
EXEC sp_addrolemember 'db_denydatareader','Sophie'
USE Sales
GO
EXEC sp_addrolemember 'db_denydatareader','Sophie'
C. USE Master
GO
EXEC sp_droplogin 'CorpDomainSophie'
GO
D. USE Finance
GO
EXEC sp_denylogin 'Sophie'
USE Sales
GO
EXEC sp_grantlogin 'Sophie'
Answer: A
7. You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.
During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL Server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.
You contact the application vendor and discover that the Financials application requires the SQL_Latin1_General_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.
What should you do?
A. Rerun SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B. Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C. Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D. Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
Answer: C
8. You are the administrator of a Microsoft Windows 2000 Advanced Server computer. The server is used to run only SQL Server 2000. Users report that database performance slows each day at 10:00 A.M. You use System Monitor to examine the server's performance and receive the results shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You need to discover why database performance is slow. What should you do?
A. Configure disk quotas on the file system, and track each database user's disk utilization.
B. Configure SQL Profiler to trace all queries that are submitted to the server.
C. Use the Sp_who stored procedure to discover who is using the database.
D. Use the Sessions folder in the Computer Management console to discover who is connected to the server.
Answer: B
9. You are the administrator of a Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.Your company contains a variety of client computers that will connect to the SQL Server 2000 computer by using a specific Net-Library, as shown in the following table.
You need to allow the client computers to connect to the SQL Server computer. You also want to minimize the number of configuration changes required on the client computers.
Which three actions should you take? (Each correct answer presents part of the solution. Choose three.)
A. Install SQL Server 2000 as a named instance.
B. Install SQL Server 2000 as the default instance.
C. Configure the new instance for Mixed Mode authentication.
D. Configure the new instance for Windows Authentication.
E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.
F. Configure the server to use the Multiprotocol Net-Library.
Answer: BCE
10. You are the administrator of a SQL Server 2000 computer. You import a large amount of data into the Contracts database. After the import, you perform a full database backup. You examine the hard disk and discover that the log file has grown from 200 MB to 800 MB.
You want to recover disk space as quickly as possible without losing backup information. Which two Transact-SQL statements should you execute? (Each correct answer presents part of the solution. Choose two.)
A. BACKUP LOG Contracts WITH no_log
B. BACKUP LOG Contracts WITH truncate_only
C. BACKUP LOG Contracts To disk='E:SQLBackupContracts_Log.bkp'
D. ALTER DATABASE Contracts
(Name=Contract_Log.ldf,
FILENAME='E:DataContracts.ldf',
SIZE=200)
E. DBCC ShrinkDatabase (Contracts, 200)
F. DBCC ShrinkFile (Contracts_Log, 200)
Answer: CF
11. You are the administrator of a SQL Server 2000 computer at your company's warehouse. All product orders are shipped from this warehouse. Orders are received at 30 sales offices. Each sales office offers a range of products specific to its region.Each sales office contains one SQL Server 2000 computer. These servers connect to the warehouse through dial-up connections as needed, typically once a day. Each sales office needs data pertaining only to its region.You need to replicate inventory data from the server at the warehouse to the servers at the sales offices. You want to minimize the amount of time needed to replicate the data.
Which three actions should you take? (Each correct answer presents part of the solution. Choose three.)
A. Create one publication for each Subscriber.
B. Create one publication for all Subscribers.
C. Enable horizontal filtering.
D. Enable vertical filtering.
E. Use pull subscriptions.
F. Use push subscriptions.
Answer: ACE
12. You are the administrator of a SQL Server 2000 computer. The server is used in your company's research department to store confidential information about projects. The ResearchProjects table is configured as shown in the exhibit. (Click the <<ItemExhibitName>> button.)
The statisticians in your company need to review information about completed projects. The statisticians belong to a database role named StatUsers.
You need to allow the statisticians to access the information on completed projects, while protecting the information on projects that are still in progress. The statisticians must not be able to modify any data.
Which batch of Transact-SQL statements should you execute?
A. CREATE VIEW StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
GO
GRANT SELECT ON StatView TO StatUsers
B. CREATE VIEW StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
WHERE ProjectComplete = 1
GO
GRANT SELECT ON StatView TO StatUsers
C. CREATE PROCEDURE StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
WHERE ProjectComplete = 1
GO
GRANT SELECT ON StatView TO StatUsers
D. CREATE PROCEDURE StatView AS
SELECT ProjectID, ProjectName, StartDate, ProjectLeader, LastModified FROM ResearchProjects
GO
GRANT SELECT ON StatView TO StatUsers
Answer: B
13. You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.hen parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You want the database to update the InStock field automatically. What should you do?
A. Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B. Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C. Use a view that creates an InStock field as part of an aggregate query.
D. Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table.Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.
Answer: A
14. You are the administrator of a SQL Server 2000 computer. You configure the SQLServerAgent service as shown in the exhibit. (Click the <<ItemExhibitName>> button.)
You configure several SQL Server Agent jobs to perform maintenance tasks. These jobs delete old database records and copy files from the server to file servers on your network.
You discover that none of the jobs will execute. You use SQL Server Enterprise Manager to check the jobs and discover that the SQLServerAgent service will not start.
You need to allow the SQLServerAgent service to start and execute the jobs. What should you do?
A. Configure the SQLServerAgent service to start by using the local system account.
B. Grant the SQLAgent domain user account the Logon as a service rights.
C. Add the SQLAgent domain user account as a Microsoft Windows login on the server.
D. Configure permissions on the master database to allow full access to the SQLAgent user account.
Answer: B
Click Online chat to talk with us , get more informations about Microsoft MCSE 2003 70-228 practice exam study guides questions and answers
Test4pass 70-228 Exam Features
Quality and Value for the 70-228 Exam
Test4pass Practice Exams for Microsoft 70-228 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your 70-228 Exam
If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the MCSE 2003 70-228 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
Microsoft 70-228 Downloadable, Printable Exams (in PDF format)
Our Exam 70-228 Preparation Material provides you everything you will need to take your 70-228 Exam. The 70-228 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.
70-228 Downloadable, Interactive Testing engines
We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Microsoft 70-228 Exam will provide you with free 70-228 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 70-228 Exam:100% Guarantee to Pass Your MCSE 2003 exam and get your MCSE 2003 Certification.
Test4pass 70-228 examTest4pass 70-228 pdf exam
Test4pass 70-228 braindumps
Test4pass 70-228 study guides
Test4pass 70-228 trainning materials
Test4pass 70-228 simulations
Test4pass 70-228 testing engine
Test4pass 70-228 vce
Test4pass 70-228 torrent
Test4pass 70-228 dumps
free download 70-228
Test4pass 70-228 practice exam
Test4pass 70-228 preparation files
Test4pass 70-228 questions
Test4pass 70-228 answers
http://www.test4pass.com/70-228-exam.html The safer.easier way to get MCSE 2003 Certification
MCSE Certification
MCSA 2003 Certification
MCSA Certification
MCDBA Certification
.
