|
| |
| |
|
|
|
Da Notes -
70-028 - W
Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender. |
Passing Score: 680, Questions: 52, Time: 90 Minutes
|
Da Notes Index
|
|
|
What to Study
|
Develop a security strategy
Develop a SQL Server capacity plan
Develop a data availability solution
Develop a migration plan
Develop a replication strategy
Install SQL Server 7.0
Configure SQL Mail.
Configure default American National Standards Institute (ANSI) settings.
Implement full-text searching
Assign SQL Server access through Windows NT accounts, SQL Server logins, and built-in administrator logins
Assign database access to Windows NT accounts, SQL Server logins, the guest user account, and the dbo user account
Create and assign SQL Server roles. Server roles include fixed server, fixed database, public, user-defined database, and application
Grant to database users and roles the appropriate permissions on database objects and statements
Audit server and database activity
Create data files, filegroups, and transaction log files.
Specify growth characteristics.
Load data by using various methods. Methods include the INSERT statement, the SELECT INTO statement, the bcp utility, Data Transformation Services (DTS), and the BULK INSERT statement.
Back up system databases and user databases by performing a full database backup, a transaction log backup, a differential database backup, and a
file group backup.
Restore system databases and user databases from a full database backup, a transaction log backup, a differential database backup, and a
file group backup.
Manage replication.
Automate administrative tasks.
Enable access to remote data.
Monitor SQL Server performance.
Tune and optimize SQL Server.
Troubleshooting
|
|
|
|
|
