|
|
Microsoft 70-028: Administering Microsoft SQL Server 7.0
|
#1. You restore the db from tape backup - upon 50% you have a tape drive failure - you replace the drive and want to finish your restore - what now?
|
|
#2. Joe uses a Windows 95 computer and sometimes a UNIX computer to connect to SQL Server 7.0. You have created a login for Joe's NT user account and also a SQL Server login that has the same name and password as his NT username and password. If Joe uses a trusted connection to access the SQL server what are his effective permissions.
|
|
#3. Maria preceded you as administrator for Microsoft Windows NT Server and SQL Server. Maria created SQL Server logins and passwords matching users Windows NT accounts. When users logon to the Windows NT Server domain they obtain access to the SQL Server. Which permissions do users receive to access SQL Server by using a trusted connection?
|
|
#4. You are a member of fixed server role serveradmin. You create a job which backup up the database and then copies the backup file on a network drive. When you do the individual steps, they run okay. However, when executed as a job, it backs up the database but fails to copy to the network drive. Why?
|
|
#5. Installing SQL on a network, there are Windows 95, NT Workstations and NETWARE clients. All must be able to connect. (Choose all that apply):
|
|
#6. SQL server is configured with a Net-Library with TCP/IP socket 1450 which is non-standard port setting How to connect clients?
|
|
#7. Replication. NY ( NY1----T1-----------NY2) -----56kbps------------>( Seattle-----T1----SanFrancisco----T1---Los Angeles)
|
|
#8. Three Users ANITA, CARMEN, PHILIPPE all have db_owner roles currently for the FINANCE database. You want PHILIPPE to continue to manage the Db as before, Anita to ONLY create users accounts and grant permissions for users, Carmen should be ONLY able to create tables, views, indexes and other objects, (choose 2)
|
|
#9. Arbor Shoes has 100 store. Their Pricing database resides on the corporate server. The pricing database server has limited space. The pricing database contains a price table. The price table has a high frequency of updates. The in-store checkout application requires an up-to-date local price table in order to ensure accurate pricing which type of SQL Server replication should you use to replicate the price table to the in-store computers?
|
|
#10. You company has five call centers that are located worldwide. These call centers manage the reservations for an airline. The reservation application has a customer table on the corporate server. The customer table is read locally and can be updated locally but the updates must maintain consistency across all five locations. Which type of SQL Server replication should you implement?
|
|
|
|
 gen. 0.067
|
Server date 13:08 12-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
70-028 certification
70-028 master dump