SQLServer

Determining Collation Setting

2009-06-03T19:24:00.000-07:00

You define the default collation for a SQL Server 2005 instance at installation time
during setup. SQL Server uses the collation setting to determine how non-Unicode
character data is stored and how to sort and compare Unicode and non-Unicode data.
To understand SQL Server 2005 collations, you need to start with the Windows OS.
When you install a Windows OS, you install a version for the language you want to
use, such as English, Greek, or Russian. These various language versions require dif-
ferent characters and different code pages to support the character sets and associated
keyboard layouts. A Windows locale is also set, based on the version of the Windows
OS that you have installed. This Windows locale determines the settings for numbers,
currencies, times, and dates on the server.
Although this process might initially seem complicated, determining the Windows col-
lation to use for SQL Server 2005 is generally straightforward. You should let the
Microsoft SQL Server Installation Wizard determine the default Windows collation
based on the Windows locale of the Windows OS unless one of the following condi-
tions exists:
■ The primary language supported by the SQL Server 2005 instance you are
installing is different from the Windows locale of the computer on which you are
installing SQL Server 2005.
■ The SQL Server 2005 instance you are installing will participate in a replication
scheme with SQL Server 2005 instances supporting a different language.

What Is Capacity Planning?

2009-05-21T21:33:00.000-07:00

What Is Capacity Planning?

The term capacity planning refers to the process of forecasting and preparing for future hardware needs. Capacity planning involves performing tests to measure how well a Web, application, or database server scales with existing hardware, to predict when new hardware will be needed, and then to design the hardware systems needed to run critical applications in the future. For database servers in particular, capacity planning involves, above all, determining the performance requirements of database applications for your business and then analyzing data trends to help ensure that these performance requirements can be met in the future.

Capacity planning can be divided into two main areas: preconfiguration capacity planning (or sizing) and postconfiguration capacity planning. Preconfiguration capacity planning involves anticipating the hardware you will need to process a given workload at the level of quality agreed to either in a service level agreement (SLA) or elsewhere. Postconfiguration capacity planning involves running performance studies on the hardware in place, analyzing trends, and projecting growth rates with a view to predicting when you will need to upgrade or replace this existing hardware.

Conducting Capacity Planning Interviews

Before you begin to estimate the hardware needed to support a database server, you

need to know certain things that—if you don’t know them already—are best determined in interviews with stakeholders.

Technical Environment

The most important step of sizing a database server is to collect information about the database workload and the environment in which it will be processed. Few organizations have the budget to size a database server simply by testing this workload against a prototype server; for all other organizations, you need to determine essential information to size accurately, and interviews with technical personnel offer the best opportunity to learn this information.

The information you might need to extract from technical interviews includes historical baseline data for the current production server, details about the number of disk reads and writes generated by the database application, growth in database usage rates, and total storage requirements of the database (including associated space for tempdb, indexes, text files, and—potentially—backup files).

Business Requirements

Those who perform capacity planning must meet with management personnel to determine the goals and expectations of the capacity planning study itself and also to extract key information to be used in the planning. This information might include customer needs, operational needs, budget constraints, growth in the number of

employees, and the estimation period for which the new hardware outlined in the plan will meet the stated performance requirements.

Technical Requirements

The technical requirements of the planned installation can be learned in interviews with either technical or management personnel. For example, after meeting with operations managers, you might determine that the company’s business operations require database response times of no more than five seconds. According to these managers, any new hardware purchases must be justified by meeting this operational requirement for three years from the day of implementation.

Planning a Database Server Infrastructure

2009-05-19T21:12:00.000-07:00

Before you deploy a database server, you need to collect as much information as pos

sible about the database server environment. This information includes the business

and technical requirements driving the deployment as well as information about the

database workload and the database itself. After you’ve gathered this information, you

can begin to predict with some accuracy the hardware and software the database will

need to meet the demands of its environment.

Exam objectives in this chapter:

¦ Design for capacity requirements.

? Analyze storage requirements.
? Analyze network requirements.
? Analyze CPU requirements.
? Analyze the current configuration.
? Analyze memory requirements.
? Forecast and incorporate anticipated growth requirements into the capac
ity requirements.

¦ Specify software versions and hardware configurations.
? Choose a version and edition of the operating system.
? Choose a version of SQL Server 2005.
? Choose a CPU type.
? Choose memory options.
? Choose a type of storage.

¦ Design physical storage.
? Design transaction log storage.
? Decide where to install the operating system.
? Decide where to place SQL Server service executables.
? Specify the number and placement of files to create for each database.

Downloading and Installing SQL Server 2008 Express

2009-01-04T17:07:00.000-08:00

Downloading and Installing SQL Server 2008 Express

Download and install any edition of SQL Server Express and the prerequisite components with a single tool.

Download and run the SQL Server Express Install Wizard
Select the edition of SQL Server Express to install
Click Install

Which edition of SQL Server 2008 Express is right for you?

SQL Server 2008 Express is available in the following 3 editions (each is available from the Install Wizard):

SQL Server 2008 Express with Tools
- SQL Server database engine - create, store, update and retrieve your data
- SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
SQL Server 2008 Express with Advanced Services
- SQL Server database engine - create, store, update and retrieve your data
- SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
- Full-text Search - powerful, high-speed engine for searching text-intensive data
- Reporting Services - integrated report creation and design environment to create reports
SQL Server 2008 Express (Runtime Only)
- SQL Server database engine - create, store, update and retrieve your data

Register Your Copy

FREE SQL Server Express eBook!
FREE developer resources and how-to articles
Royalty-free images and icons that can be included with your applications
Product update and release notifications
Helpful resource links including community forums and team blogs
Click here to register SQL Server 2008 Express and receive all these benefits today!

Additional Resources

System Requirements

Supported Operating Systems: Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista, Windows XP Service Pack 2
Physical Limitations: 1 CPU, 1 GB Memory, 4 GB of user data per database

SQL Server 2008 Enterprise Evaluation (Advanced Professional users)

Microsoft 70-431 Braindump #2

2008-12-28T02:56:00.000-08:00

QUESTION NO: 11

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.

You want to add two new message types to the existing service. In each database, you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first?

A. Create a queue on each database with the ACTIVATION argument set to DataManager.dbo.ProcessReport.

B. Create a conversation between the databases by using the following statement.BEGIN DIALOG FROM SERVICE 'ProcessReport' TO SERVICE 'SendResult'

C. Create a contract between the services by using the following statement.CREATE CONTRACT ProcessData (ProcessReport SENT BY INITIATOR, SendResult SENT

BY TARGET)

D. Create services for each database by using the following statement.CREATE SERVICE DataManager ON QUEUE ProcessReport

Answer: C

QUESTION NO: 12

You work at the regional sales office. You are responsible for importing and exporting data in SQL Server 2005 databases. The main office asks you to send them a text file that contains updated contact information for the customers in your region. The database administrator in the main office asks that the data be sorted by the StateProvince, Surname, and FirstName columns.

You need to satisfy these requirements by using the least amount of effort. What should you do?

A. Specify StateProvince, Surname, and FirstName in the ORDER hint in the bcp out command.

B. Create a format file for the export operation.

C. Specify StateProvince, Surname, and FirstName in the ORDER BY clause in the bcp queryout command.

D. Copy the data into a new table that has a clustered index on StateProvince, Surname, and FirstName. Export the data.

Answer: C

QUESTION NO: 13

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Both

servers take part in replication. SQL1 is both the Publisher and its own Distributor of a

publication named Pub1. Pub1 is the only publication on SQL1, and SQL2 is the only

Subscriber. Your supervisor requests a status report about the replication latencies. Using

Replication Monitor on SQL1, you need to find out the current latencies between the

Publisher and Distributor as well as between the Distributor and Subscriber.

What should you do?

A. Select the Subscription Watch List tab for SQL1. View the Latency column for the

SQL2 subscription.

B. Select the All Subscriptions tab for the Pub1 publication. View the Latency column

for the SQL2 subscription.

C. Select the Tracer Tokens tab for the Pub1 publication. Select the Insert Tracer option

and wait for the requested latency values for the SQL2 subscription to appear.

D. Select the Subscription Watch List tab for SQL1. Double-click the SQL2 subscription.

View the duration details on the Publisher to Distributor History tab as well as on the

Distributor to Subscriber History tab.

Answer: C

QUESTION NO: 14

Exhibit:

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A database named DB1 is located on SQL1. DB1 contains a table named TestKing4. TestKing4 is replicated to a database named DB1Repl, which is located on SQL2. Full-Text Search is not being used. Users report that the queries they run against TestKing4 in DB1Repl are very slow. You investigate and discover that only the clustered index of TestKing4 is replicated. All other indexes in DB1Repl are missing. You examine the TestKing4 article properties. The current TestKing4 article properties are shown in the exhibit.

You need to change the article properties so that all indexes of TestKing4 in DB1 are replicated when the subscription is reinitialized. Which two article properties should you change? (Each correct answer presents part of the solution. Choose two.)

A. Copy clustered index

B. Copy nonclustered indexes

C. Copy extended properties

D. Copy unique key constraints

E. Copy index partitioning schemes

F. Copy XML indexes

Answer: B,F

QUESTION NO: 15

You are creating an HTTP endpoint that will be used to provide customer data to external applications. Your SQL Server 2005 computer is named SQL1. You create a stored procedure named dbo.usp_GetPersonData to retrieve the data in the TestKing database.

You create the endpoint by using the following code.

CREATE ENDPOINT SQLEP_AWPersons AS HTTP (PATH = '/AWpersons',

AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = 'SQL1') FOR

SOAP (WEBMETHOD 'PersonData' (NAME='TestKing.dbo.usp_GetPersonData'),

BATCHES = DISABLED, WSDL = DEFAULT, DATABASE = 'TestKing',

NAMESPACE = 'http://Adventure-Works/Persons')

The first users to connect to the endpoint tell you that they do not get any data. You connect to the endpoint and discover that it is not responding. You need to modify the endpoint so that data is returned as expected. What should you do?

A. Change the AUTHENTICATION property to KERBEROS.

B. Specify BATCHES = ENABLED.

C. Specify STATE = Started.

D. Specify WSDL = 'pr_GetPersonData'.

Answer: C

QUESTION NO: 16

You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name. You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report, ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a

presentation.

You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do?

A. Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.

B. Use the SQL Server Import and Export Wizard to copy the data from the Buenos Aires database into new tables, specifying the same collation as the Dublin database.

C. Modify the format file to specify the same collation as the Dublin database. Import the table again.

D. Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query, specify the same collation as the Dublin database.

Answer: D

QUESTION NO: 17

You work for a company that sells books. You are creating a report for a SQL Server 2005 database. The report will list sales representatives and their total sales for the current month. The report must include only those sales representatives who met their sales quota for the current month. The monthly sales quota is $2,000. The date parameters are passed in variables named @FromDate and @ToDate.

You need to create the report so that it meets these requirements. Which SQL query should you use?

A. SELECT s.AgentName, SUM(ISNULL(o.OrderTotal,0.00))AS SumOrderTotalFROM

SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate

BETWEEN @FromDate AND @ToDateGROUP BY s.AgentName

B. SELECT s.AgentName, SUM(ISNULL (o.OrderTotal,0.00))AS

SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID =

o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate AND

o.OrderTotal >= 2000GROUP BY s.AgentName

C. SELECT s.AgentName, SUM(ISNULL (o.OrderTotal,0.00)) AS

SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentID

WHERE o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY

s.AgentNameHAVING SUM(o.OrderTotal) >= 2000

D. SELECT s.AgentName, SUM(ISNULL(o.OrderTotal,0.00)) AS

SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID =

o.AgentIDWHERE o.ordertotal = 2000 AND o.OrderDate BETWEEN @FromDate

AND @ToDateGROUP BY s.AgentNameHAVING SUM(o.OrderTotal) >= 2000

Answer: C

QUESTION NO: 18

You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur.

BEGIN TRY

BEGIN TRANSACTION

DELETE FROM Person.Contact

WHERE ContactID = @ContactID

COMMIT TRANSACTION

END TRY

BEGIN CATCH

DECLARE @ErrorMessage nvarchar(2000) DECLARE @ErrorSeverity int DECLARE

@ErrorState int SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity =

ERROR_SEVERITY(), @ErrorState = ERROR_STATE() RAISERROR

You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do?

A. Add a COMMIT TRANSACTION command to the CATCH block.

B. Remove the COMMIT TRANSACTION command from the TRY block.

C. Add a ROLLBACK TRANSACTION command to the CATCH block.

D. Add a ROLLBACK TRANSACTION command to the TRY block.

Answer: C

QUESTION NO: 19

You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.

You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do?

A. Add an XML index to the table that contains the product data.

B. Add the XSINIL argument to the ELEMENTS directive in the query.

C. Add a HAVING clause to the query.

D. Add the replace value of clause to the query.

Answer: B

QUESTION NO: 20

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings.

You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?

A. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.

B. On SQL1, change the schedule type for the transaction log backup to Start automatically when SQL Server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.

C. On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.

D. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.

Answer: D

Microsoft 70-431 Braindump #1

2008-12-28T02:45:00.000-08:00

QUESTION NO: 1

Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data.

You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do?

A. Join the two servers by using the four-part syntax of server.database.schema.table.

B. Reference SQL2 by using an alias.

C. Add SQL2 as a remote server to SQL1.

D. Add SQL2 as a linked server to SQL1.

Answer: D

QUESTION NO: 2

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.

Which two protocols can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A. Named Pipes

B. TCP/IP

C. Shared Memory

D. Virtual Interface Adapter (VIA)

E. Multiprotocol

Answer: A,B

QUESTION NO: 3

You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance.

You need to identify the most likely cause of the connection issues. What should you do first?

A. Ensure that port 1433 is open in your firewall.

B. Ensure that port 443 is open in your firewall.

C. Ensure that client computers connect by using Shared Memory protocol.

D. Ensure that the server is not paused.

Answer: A

QUESTION NO: 4

TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.

You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do?

A. Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.

B. Configure SQL2 as a remote server. Write the query on SQL1.

C. Configure SQL2 as a linked server to impersonate the remote login.

D. Configure SQL2 as a distributed server. Use pass-through authentication.

Answer: C

QUESTION NO: 5

TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date.

You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use? (Each correct answer presents part of the solution. Choose two.)

A. DBCC CHECKTABLE

B. ALTER INDEX REORGANIZE

C. UPDATE STATISTICS

D. CREATE STATISTICS

E. DBCC SHOW_STATISTICS

F. DBCC UPDATEUSAGE

Answer: C,D

QUESTION NO: 6

You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month.

You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do?

A. Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.

B. Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code.

C. Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs.

D. Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.

Answer: A

QUESTION NO: 7

You discover that the msdb database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share, but the file names do not clearly indicate which databases are in each file.

You need to locate the correct backup file as quickly as possible. The first file in the list is named DB_Backup.bak. Which Transact-SQL statement should you use?

A. RESTORE LABELONLYFROM DISK = N\\Server1\Backup\DB_Backup.bak

B. RESTORE HEADERONLYFROM DISK = N\\Server1\Backup\DB_Backup.bak

C. RESTORE VERIFYONLYFROM DISK = N\\Server1\Backup\DB_Backup.bak

D. RESTORE DATABASE MSDBFROM DISK = N\\Server1\Backup\DB_Backup.bak

Answer: B

QUESTION NO: 8

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table.

You need to achieve this goal without affecting the availability of other data in the database. What should you do?

A. Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.

B. Back up the current transaction log. Restore the database to the point just before the data loss.

C. Restore the database from the existing backup files to a time just before the data loss.

D. Restore the database to the point of the last full backup.

Answer: A

QUESTION NO: 9

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located.

You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

A. Execute DBCC CHECKFILEGROUP for each filegroup.

B. Execute DBCC CHECKCATALOG.

C. Execute DBCC CHECKDB.

D. Execute DBCC CHECKTABLE for each table.

Answer: C

QUESTION NO: 10

You are responsible for importing data into SQL Server 2005 databases. Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.

You need to import the files into the sales database. What should you do?

A. Create a custom format file, specifying a semicolon as the row terminator.

B. Use the bcp command, specifying a semicolon as the field terminator.

C. Use the bcp command with the default arguments.

D. Use the BULK INSERT statement with the default arguments.

Answer: B

MCDBA Certification

2008-12-26T18:16:00.000-08:00

MCDBA Certification
70-306	Developing Windows-based Applications with Microsoft Visual Basic .NET
70-215	Installing, Configuring and Administering Microsoft Windows 2000
70-216	Implementing and Administering a Microsoft Windows 2000 Network
70-228	Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
70-229	Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
70-431	Microsoft SQL Server 2005 Implementation & Maintenance
70-290	Managing and Maintaining a Microsoft Windows Server 2003 Environment
70-291	Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
70-305	Developing and Implementing Web Applications with Microsoft Visual Basic.NET
70-310	XML Web Services and Server Components with Visual Basic.NET
70-315	Developing and Implementing Web Applications with Microsoft Visual C# .NET
70-316	Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET
70-320	XML Web Services and Server Components with C#.NET

Braindumps provide the most comprehensive MCDBA training - through our online virtual MCDBA bootcamps. MCDBA certification has never been easier to study for, and complete with MCDBA notes, you are sure to pass your MCDBA exams. Each complete MCDBA course in our MCDBA bootcamp cover the next MCDBA exam, provide a complete MCDBA practice exam, and ensure your MCDBA test success with an MCDBA study guide.

Combining our detailed MCDBA braindumps with our proved MCDBA boot camps, is certain to provide you with the MCDBA training required for you to pass the MCDBA tests. There is no more complete and comprehensive method for MCDBA course preparation, than a Braindumps MCDBA boot camp.

What is an MCDBA braindump? MCDBA braindumps are an actual inside look at the MCDBA test material, providing you with advanced knowledge through our MCDBA study guide, MCDBA notes, MCDBA practice exams - all to give the best MCDBA tests and MCDBA exam preparation.

Start today with our MCDBA braindump. With so many MCDBA braindumps to choose from, you have a virtual MCDBA boot camp available to you for your best MCDBA exams study. MCDBA bootcamps, and the MCDBA boot camps at Braindumps are specially designed to allow MCDBA certification ease of preparation. Select your MCDBA bootcamp with confidence that your MCDBA training for your MCDBA tests and MCDBA exams are backed by the quality MCDBA notes, MCDBA practice exams, and MCDBA study guides.

Start down the road to MCDBA test success utilizing all of the benefits found on our MCDBA certification and MCDBA course - MCDBA bootcamp. One place, one stop, only one MCDBA braindump.

SQL Server 2008 - Choose the Right Edition for Your Needs

2008-12-26T17:54:00.000-08:00

Business today demands a different kind of data management solution—one that offers excellent performance, scalability, and reliability, but is also easy to use and maintain. SQL Server 2008 delivers on this by providing a Trusted, Productive and Intelligent Data Platform that can solve your data management needs.

SQL Server 2008 is available in many editions to help meet the needs of your organization.

	Core Editions		Specialized Editions			Free Editions
	Enterprise	Standard	Workgroup	Web *	Developer **	Express	Compact 3.5
Target Scenarios	Enterprise workloads that need redundancy and built-in Business Intelligence	Shared data scenarios in departments and small to large businesses	Remote offices that need local instances of company data	For web application hosting	Full featured edition for development and testing only	Entry level database, ideal for learning and ISV redistribution	Embedded database for developing desktop and mobile applications
CPU	OS Maximum	4 CPU	2 CPU	4 CPU	OS Maximum	1 CPU	OS Maximum
Memory	OS Maximum	OS Maximum	4 GB	OS Maximum	OS Maximum	1 GB	OS Maximum
DB Size	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	4 GB	4 GB
Additional Resources	Learn More	Learn More	Learn More	Learn More	Learn More	Learn More	Learn More
How to get it	How to Buy \| Try it now					Download now	Download now
Pricing & Licensing	See our Pricing overview page for more details					Free Editions.

* Web Edition is only available for web workloads. Please see the licensing section for more details.

** Developer Edition to be used for Application Development and Testing only. Please see the licensing section for more details.

Ultimate guide for upgrading to SQL Server 2008

2008-12-26T17:40:00.000-08:00

Last week, our SQL Server engineering team in association with Solid Quality Mentors released an unprecedented 490-page free whitepaper called SQL Server 2008 Upgrade Technical Reference Guide that provides in-depth information on how to upgrade to SQL Server 2008. The guide can be downloaded from here, and the following is a listing of topics covered in each chapter:

Chapter 1 (Pages 17-68)

Overview of technical issues and decisions involved in upgrading to SQL Server 2008, as well as recommendations for planning and deploying an upgrade.

Chapter 2 (Pages 69-90)

Addresses issues related to upgrading to SQL Server 2008 Management Tools.

Chapters 3-8 (Pages 92-243)

Upgrade issues for SQL Server relational databases.

Chapter 3: Relational Databases (Pages 92-117)
Chapter 4: High Availability (Pages 118-181)
Chapter 5: Security (Pages 182-198)
Chapter 6: Full-Text Search (Pages 199-210)
Chapter 7: Service Broker (Pages 211-216)
Chapter 8: Transact-SQL Queries (Pages 217-243)
Chapter 9: Notification Services (Pages 244-251)

Chapter 10 (Pages 252-270)

Upgrading to SQL Server 2008 Express

Chapters 11-14

Upgrading to SQL Server 2008 Business Intelligence components: Analysis Services, Data Mining, Integration Services, and Reporting Services.

Chapter 11: Analysis Services (Pages 271-302)
Chapter 12: Data Mining (Pages 303-329)
Chapter 13: Analysis Services (Pages 330-420)
Chapter 14: Reporting Services (Pages 421-468)

Chapter 15 (Pages 469-477)

Implications of upgrading to SQL Server 2008 for other Microsoft applications and platforms.

Appendix 1

Detailed table of allowed SQL Server 2008 version and edition upgrade paths.

Appendix 2

Upgrade planning checklist.

Additional Resources

Download the SQL Server 2008 Upgrade Technical Reference Guide
Microsoft Assessment and Planning Tool
Free toolkit from Microsoft that finds computers on a network and performs detailed inventory of software running on those computers
How to upgrade to SQL Server 2008 (on MSDN)
Solid Quality Mentors

SQL Server Function Examples

2008-12-23T14:45:00.000-08:00

You commonly use functions when converting date data from the format of one country to that of another.


	Note: To change date formats, you should use the CONVERT function with the style option to determine the date format that will be returned.

Example 1

This example demonstrates how you can convert dates to different styles.

SELECT 'ANSI:' AS Region,
CONVERT (varchar(30), GETDATE(), 102) AS Style
UNION
SELECT 'European:', CONVERT(varchar(30), GETDATE(), 113)
UNION
SELECT 'Japanese:', CONVERT(varchar(30), GETDATE(), 111)

Result

		Region		Style

		ANSI:		2000.03.22

		European:		22 Mar 2000 14:20:00:010

		Japanese:		2000/03/22

Example 2

This example uses the DATEFORMAT option of the SET statement to format dates for the duration of a connection. This setting is used only in the interpretation of character strings as they are converted to date values and has no effect on the display of date values.

SET DATEFORMAT dmy
GO
DECLARE @vdate datetime
SET @vdate = '29/11/00'
SELECT @vdate

Result



		2000-11-29 00:00:00.000

		(1 row(s) affected)

Example 3

This example returns the current user name and the application that the user is using for the current session or connection. The user in this example is a member of the sysadmin role.

USE Northwind
SELECT user_name(), app_name()

Result



		dbo		2000-11-29 00:00:00.000

		(1 row(s) affected)

Example 4

This example determines whether the FirstName column in the Employees table of the Northwind database allows null values.

A result of zero (false) means that null values are not allowed, and a result of one (true) means that null values are allowed. Notice that the OBJECT_ID function is embedded in the COLUMNPROPERTY function. This allows you to retrieve the object id of the Employees table.

USE Northwind
SELECT COLUMNPROPERTY(OBJECT_ID('Employees'), 'FirstName',
'AllowsNull')

Result



		0

		(1 row(s) affected)

SQL Server Functions

2008-12-23T14:31:00.000-08:00

Transact-SQL provides many functions that return information. Functions take input parameters and return values that can be used in expressions. The Transact-SQL programming language provides three types of functions, aggregate, scalar, and rowset.

Aggregate Functions

Aggregate functions operate on a collection of values but return a single, summarizing value.

Example 1

This example determines the average of the UnitPrice column for all products in the Products table.

SELECT AVG(UnitPrice) FROM Products

Result

		Products

		28.8663

		(1 row(s) affected)

Scalar Functions

Scalar functions operate on a single value and then return a single value. You can use these functions wherever an expression is valid. You can group scalar functions into the categories in the following table.

		Function category		Description

		Configuration		Returns information about the current configuration

		Cursor		Returns information about cursors

		Date and Time		Performs an operation on a date and time input value and returns a string, numeric, or date and time value

		Mathematical		Performs a calculation based on input values provided as parameters to the function and then returns a numeric value

		Metadata		Returns information about the database and database objects

		Security		Returns information about users and roles

		String		Performs an operation on a string (char or varchar) input value and returns a string or numeric value

		System		Performs operations and returns information about values, objects, and settings in SQL Server

		System Statistical		Returns statistical information about the system

		Text and Image		Performs an operation on a text or image input value or column and returns information about the value

Example 2

This metadata function example returns the name of the database currently

in use.

SELECT DB_NAME() AS 'database'

Result

		Database

		Northwind

		(1 row(s) affected)

Rowset Functions

Rowset functions can be used like table references in a Transact-SQL statement.

Example 3

This example performs a distributed query to retrieve information from the EMP table.

SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT ENAME, EMPNO FROM
SCOTT.EMP')

Operator Precedence Levels

2008-12-23T05:44:00.000-08:00

Operator Precedence Levels

If you use multiple operators (logical or arithmetic) to combine expressions, SQL Server processes the operators in order of their precedence, which may affect the resulting value. The following table shows the precedence level of operators (levels go from highest to lowest).

Type	Operator	Symbol

Grouping	Primary grouping	()

Arithmetic	Multiplicative	*/%

Arithmetic	Additive	-+

Other	String concatenation	+

Logical	NOT	NOT

Logical	AND	AND

Logical	OR	OR

SQL Server handles the most deeply nested expression first. In addition, if all arithmetic operators in an expression share the same level of precedence, the order is from left to right.

Additional Language Elements - Operators

2008-12-23T05:18:00.000-08:00

Operators are symbols that perform mathematical computations, string concatenations, and comparisons between columns, constants, and variables. You can combine them and use them in search conditions. When you combine them, the order in which SQL Server processes the operators is based on a predefined precedence.

Partial Syntax

{constant | column_name | function | (subquery)}
[{arithmetic_operator | string_operator |
AND | OR | NOT}
{constant | column_name | function | (subquery)}…]

Types of Operators

SQL Server supports four types of operators: arithmetic, comparison, string concatenation, and logical

Arithmetic

Arithmetic operators perform computations with numeric columns or constants. Transact-SQL supports multiplicative operators, including multiplication (*), division (/), and modulo (%)-the integer remainder after integer division-and the addition (+)
and subtraction (-) additive operators.

Comparison

Comparison operators compare two expressions. You can make comparisons between variables, columns, and expressions of similar type. The following table defines the comparison operators in Transact-SQL.

		Operator		Meaning

		=		Equal to

		>		Greater than

		<		Less than

		>=		Greater than or equal to

		<=		Less than or equal to

		<>		Not equal to

String Concatenation

The string concatenation operator (+) concatenates string values. String functions handle all other string manipulation.

Logical

The logical operators AND, OR, and NOT connect search conditions in WHERE clauses.

Local Variables

2008-12-23T05:00:00.000-08:00

Variables are language elements with assigned values. You can use local variables in Transact-SQL.

You define a local variable in a DECLARE statement and then assign it an initial value with either the SET or SELECT statement. Use the SET statement when the desired value is known. Use the SELECT statement when you must look up the desired value in a table. After you establish the value of the variable, you can use it in the statement, batch, or procedure in which it was declared. A batch is a set of Transact-SQL statements that are submitted together and executed as a group. A local variable is shown with one at sign (@) preceding its name.

Syntax

DECLARE {@local_variable data_type} [,...n]

SET @local_variable_name = expression

Example

The following example declares two variables. It uses the SET statement to establish the value of the @vLastName variable and the SELECT statement to look up the value of the @vFirstName variable. It then prints both variables.

DECLARE @vLastName char(20),
@vFirstName varchar(11)
SET @vLastName = 'Dodsworth'
SELECT @vFirstName = FirstName
FROM Northwind..Employees
WHERE LastName = @vLastName
PRINT @vFirstName + ' ' + @vLastNameGO

Result

Anne Dodsworth

Master Dump for Microsoft 70-215 #4

2008-12-22T17:18:00.000-08:00

#73. You are a recently hired network administrator at Awesome Computer. Awesome Computer has an office in New York and Toronto. Company network configured as:

Toronto Office: Windows 2000 Domain Controller Monitor1 with community name of AwesomeA WebServer with community name of AwesomeA

New York Office:Windows 2000 domain Controller Monitor2 with community name of AwesomeB ApplicationServer with community name of AwesomeB

These two offices are linked to two routers with Internet between the routers.You are responsible for monitoring all servers from Monitor1.

Monitor1 and Monitor2 are configured with Management Console running third party network management software. ApplicationServer and WebServer are configured as SNMP agents. You discovered that you are unable to manage ApplicationServer from Monitor1.

What should you do?

A . Relocate the ApplicationServer to Toronto office.
B . Move ApplicationServer computer account to Toronto domain.
C . Add AwesomeA to the list of accepted community names on ApplicationServer.
D . Add public to the list of accepted community names on ApplicationServer.
E . Remove all community names from ApplicationServer.
F . Remove all community names from Monitor2.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . YES 2 View

D . no 0 View

E . no 0 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	1	View
B .	no	0	View
C .	YES	2	View
D .	no	0	View
E .	no	0	View
F .	no	0	View

#74. You create a stand-alone Dfs root on a computer running Windows 2000 Server. You want to attach links to the Dfs root.

What share-level permission must you have for each shared folder that you use to define a Dfs link?

A . Change
B . Full Control
C . Read
D . No permission is needed

Answer Winner # of Votes Explanation

A . no 0 View

B . no 1 View

C . no 0 View

D . YES 3 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	1	View
C .	no	0	View
D .	YES	3	View

#75. You have six physical disks, disks 0-5, attached to a computer running Windows 2000 Server.

Disk 0 contains drive C:, which has the Windows 2000 system files Disk 1 contains Drive D:, which has the Windows 2000 boot files Disks 2-5 comprise a stripe set with parity

For best performance, where should you place the page file?

A . Place the page file on Drive D
B . Place the page file on the stripe set with parity
C . Create a page file on both the stripe set with parity and on drive C
D . Place the page file on drive C

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 6 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	6	View
C .	no	0	View
D .	no	0	View

#76. Gary is creating a stripe set with parity using four physical disk drives on a computer running Windows 2000 Server. Each disk has free space available, and the least amount of free space on any disk is 250Mb.

What will be the data storage capacity of this stripe set with parity?

A . 250Mb
B . 750Mb
C . 500Mb
D . 1000Mb

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 10 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	1	View
B .	YES	10	View
C .	no	0	View
D .	no	0	View

#77. Gerry has several types of computers with a variety of adapter cards on his Windows 2000 based network. The Windows-based computers are configured to use NWLink, and the non-Windows computers are configured to use IPX/SPX.

The drivers on each machine are compatible with the protocols in use on that machine, but one of the computers cannot connect to the network. You have checked the cabling and connectors on the computer, and they appear to be good.

What is the most likely cause of the problem?

A . IRQ conflicts
B . Protocol mismatch
C . Data speed mismatch
D . Frame type mismatch

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 1 View

C . no 0 View

D . YES 1 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	1	View
C .	no	0	View
D .	YES	1	View

#78. You manage a Help Desk for your company. You decide to install Terminal Services on one of your company's computers running Windows 2000 Server (SrvRC) to allow your help desk personnel to assist users via remote control. The users and the help desk personnel work on computers running Windows 98. In addition to installing the Terminal Services client on the user's computers, what steps should you take to provide the remote control capability?

A . Install Terminal Services on SrvRC and configure it to use the Application Server mode. Have the Help Desk personnel manage client computers from the terminal server's console.
B . Install Terminal Services on SrvRC and configure it to use the Remote Administration mode. Install the Terminal Services client on the computers used by the Help Desk personnel.
C . Install Terminal Services on SrvRC and configure it to use the Application Server mode. Install the Terminal Services client on the computers used by the Help Desk personnel.
D . Install Terminal Services on SrvRC and configure it to use the Remote Administration mode. Have the Help Desk personnel manage client computers from the terminal server's console.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 2 View

C . no 1 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	2	View
C .	no	1	View
D .	no	0	View

#79. Your department has a custom application that your manager wants you to install on a computer running Terminal Services.

What steps should you take when you configure this application to run on the Terminal Services server?

A . Enable the RDP connection while you set up the application. After installing the application, run the command "change user / install", and edit the necessary settings in the User Interface of the application.
B . Enable the RDP connection while you set up the application. After installing the application, run the command "change user / execute", and edit the necessary settings in the User Interface of the application.
C . Disable the RDP connection while you set up the application. After installing the application, run the command "change user / install", and edit the necessary settings in the User Interface of the application.
D . Disable the RDP connection while you set up the application. After installing the application, run the command "change user / execute", and edit the necessary settings in the User Interface of the application.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 1 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	1	View
C .	no	0	View
D .	no	0	View

#80. You create a new folder named CorpInfo on a computer running Windows 2000 Server. You share the folder. You assign the following share permissions to the folder:

"h CorpDataAdmin Full Control "h CorpDataEntry Change "h Joe Read

Joe belongs to the global group Support. Support is a member of the domain local groups CorpDataAdmin, CorpDataEntry and CorpUpdate.

What is Joe's effective permission to the shared folder CorpInfo?

A . Access is denied
B . Change
C . Full Control
D . Read

Answer Winner # of Votes Explanation

A . no 0 View

B . no 1 View

C . YES 3 View

D . YES 3 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	1	View
C .	YES	3	View
D .	YES	3	View

#81. The X.25 link between your office and a branch office of your company is inaccessible. Both offices also have T1 lines to local Internet Service Providers (ISPs). You need to update configuration parameters for the default web site on a computer running Internet Information Services (IIS) at the branch office.

What parameter must you include in the Uniform Resource List (URL) in order to administer the site using your web browser?

A . The host header of the administration web site
B . The port number of the administration web site
C . The home page of the administration web site
D . Port 433

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 2 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	2	View
C .	no	0	View
D .	no	0	View

#82. You are testing a custom application on a computer running Windows 2000 Server. The application (AppA) starts 4 child processes (Proc1, Proc2, Proc3 and Proc4). Proc2 starts 2 child processes (Proc2a and Proc2b). You also have 3 other applications running on the server. You notice that the processor queue has grown to 4, and you want to eliminate the custom application.

What steps should you take to eliminate the application as quickly as possible?

A . On the Application tab in Task Manager, select the custom application. From the context menu of the application, select Go To Process From the context menu of that process, set the priority to AboveNormal
B . On the Processes tab in Task Manager, select each process of the application that has a child process (AppA and Proc2). From the context menu of AppA and Proc2, select End Process
C . On the Application tab in Task Manager, select the custom application. From the context menu of the application, select Go To Process From the context menu of that process, select End Process
D . On the Application tab in Task Manager, select the custom application. From the context menu of the application, select Go To Process From the context menu of that process, select End Process Tree

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 0 View

D . YES 5 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	0	View
C .	no	0	View
D .	YES	5	View

#83. You enable RRAS on a computer running Windows 2000 Server. You want to configure a Virtual Private Network (VPN) using only Layer 2 Tunneling Protocol (L2TP), and disable the Point-to-Point Tunneling Protocol (PPTP).

What 3 steps should you take? (Choose three)

A . In the appropriate properties dialog box of the Ports node, set the Remote Access Connection (Inbound Only) check box for PPTP
B . In the properties dialog box of the Ports node, clear the Demand Dial Routing Connections (Inbound and Outbound) check box for PPTP
C . In the properties dialog box of the Ports node, set the Demand Dial Routing Connections (Inbound and Outbound) check box for PPTP
D . Set the number of PPTP ports to 1
E . In the properties dialog box of the Ports node, clear the Remote Access Connection (Inbound Only) check box for PPTP
F . Set the number of PPTP ports to 0

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 3 View

C . no 1 View

D . no 2 View

E . YES 3 View

F . YES 3 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	1	View
B .	YES	3	View
C .	no	1	View
D .	no	2	View
E .	YES	3	View
F .	YES	3	View

#84. You enable Routing and Remote Access (RRAS) on six computers running Windows 2000 Server in your enterprise. These computers belong to a Windows 2000 domain. You also configure one computer running Windows 2000 Server as an Internet Authentication Service (IAS) server to centralize the authentication of remote access users for the domain. You plan to govern the use of remote access by implementing remote access policies.

How should you create these policies?

A . Use the Group Policy editor to create the policies in the default domain policy.
B . Use the Group Policy editor to create the policies in a Group Policy object linked to an organizational unit (OU) that contains the computer objects for the remote access and IAS servers.
C . Use the Routing and Remote Access snap-in to create policies on the IAS server.
D . Use the Routing and Remote Access snap-in to create policies on each remote access server.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 3 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	0	View
C .	YES	3	View
D .	no	0	View

#85. You enable Routing and Remote Access (RRAS) on a computer running Windows 2000 Server. You plan to use IP packet filters to manage the protocols available to remote access clients. What component of the Routing and Remote Access snap-in can you use to implement the IP packet filters?

A . The profile of a remote access policy.
B . The Properties dialog box of the remote access server.
C . The conditions of a remote access policy.
D . The Properties dialog box of the remote access ports.

Answer Winner # of Votes Explanation

A . YES 3 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	3	View
B .	no	0	View
C .	no	0	View
D .	no	0	View

#86. You want a user to manage a computer running Windows 2000 Server on which Terminal Services are enabled in Remote Administration mode. The computer is a member of a Windows 2000 domain. You do not want this user to be a member of the Domain Admins group.

What should you do to enable the user to perform basic tasks using Terminal Services?

A . Add the user to the Server Operators group.
B . Use Terminal Services Configuration to modify the permissions of the RDP-TCP connection object.
C . Use Local Security Policy to assign rights for that computer to the user.
D . Use Terminal Services Configuration to modify the Permission Capability setting for the server.

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 2 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	1	View
B .	YES	2	View
C .	no	0	View
D .	no	0	View

#87. You manage a computer running Windows 2000 Server and Exchange Server 5.5. You want to optimize the performance of the server.

Which setting should you enable for the File and Print Sharing for Microsoft Networks in the properties of the local area connection of the computer?

A . Maximize data throughput for network applications.
B . Minimize memory used.
C . Balance.
D . Maximize data throughput for file sharing.

Answer Winner # of Votes Explanation

A . YES 2 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	2	View
B .	no	0	View
C .	no	0	View
D .	no	0	View

#88. You implement Internet Printing on a computer running Windows 2000 Server.

When a user attempts to connect to a printer using Internet Explorer 4.0, what protocol will the client computer use first?

A . Remote Procedure Call (RPC)
B . Server Message Block (SMB)
C . Internet Printing Protocol (IPP)
D . Hypertext Transport Protocol (HTTP)

Answer Winner # of Votes Explanation

A . YES 5 View

B . no 0 View

C . no 4 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	5	View
B .	no	0	View
C .	no	4	View
D .	no	0	View

#89. You create a stand-alone Distributed File System (Dfs) root on Srv1, a computer running Windows 2000 Server. You then add two links to the root. The links refer to shares on computers running Windows 2000 Server that are members of the same workgroup as Srv1. The servers hosting the links are named SrvA and SrvB. You want to replicate the content of the Dfs link on SrvA to SrvB.

What step or steps should you take?

A . You should create the link replica on SrvB and manually copy the contents of the share on SrvA to replica.
B . You should enable the File Replication Service on Srv1, SrvA, and SrvB
C . You should enable the File Replication Service on SrvA and SrvB
D . You should create a replica of the Dfs root on SrvB

Answer Winner # of Votes Explanation

A . YES 3 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	3	View
B .	no	0	View
C .	no	0	View
D .	no	0	View

#90. A user named Kathy belongs to four global groups in Corp, a Windows 2000 domain that you manage. The global groups are GGApps, GGData, GGMgr and GGDB. The group GGApps is a member of the domain local group Apps. The group GGData is a member of the domain local group Data-Access. The group GGDB is a member of the domain local group DB-Access.

You create and share a folder on a member server of the domain. You allow the share permission Full Control for the group DB-Access, the share permission Read for the group Apps, and the share permission Change for the group Data-Access. Kathy uses a computer running Windows 2000 Professional that is a member of Corp.

What is the effective permission for Kathy when she connects to the shared folder from her computer?

A . Access is denied
B . Read
C . Change
D . Full Control

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 0 View

D . YES 4 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	0	View
C .	no	0	View
D .	YES	4	View

#91. Your win2000 server computer contains four 16-gb hard disks. Disk 0 is configured as a basic disk. Disk 0 has a single 16-gb partition that contains the os files. Disk 1,2, and 3 are configured as dynamic disk in a raid-5 volume. The entire server is backed up to a tape drive each night. During your daily review of the server’s event logs, you discover that disk 1 has failed. You shut down the server and replace disk 1 with a new hard disk. When you restart the server win2000 starts normally but the data on the raid-5 volumn is inaccessible. Disk management indicates that disk 2 has failed also. You replace disk 2 with a new hard disk. Now you need to recover the data on the raid-5 volume as quickly as possible.

What should you do ?

A . use disk manager to rebuild raid-5 partition
B . delete and recreate the raid-5 partition.redtore the contents of raid-5 partition from the most recent tape back-up
C . use win2000 backup to restore the contents of disk2. Use disk manager to rebuild the raid-5 partition on disk 1
D . delete and recrate the raid-5 partition . setart the server by using win2000 setup cd, and select the repair option

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 2 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	2	View
C .	no	0	View
D .	no	0	View

#92. Which of the following sections in unattend.txt contains the ComputerName?

A . Unattended
B . UserData
C . Networking
D . Identification
E . Data

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 3 View

C . no 0 View

D . no 0 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	3	View
C .	no	0	View
D .	no	0	View
E .	no	0	View

#93. What should you use for installing multiple Windows 2000 servers with Dissimilar hardware?

A . SMS
B . Sysprep
C . Syspart
D . RIS

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 8 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	0	View
C .	YES	8	View
D .	no	1	View

#94. What service is responsible for answering client computer network service requests during the OS installation using RIS?

A . TFTPD
B . BINLSVC
C . RIS service
D . DHCP
E . Active Directory

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 5 View

C . no 0 View

D . no 0 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	5	View
C .	no	0	View
D .	no	0	View
E .	no	0	View

#95. You are having problems starting one of your Windows 2000 domain controllers, so you want to start the system using the Advanced Startup options.

Which two options will be unavailable when you choose Advanced Startup Options? (Choose two)

A . Safe Mode
B . Debugging Mode
C . Safe Mode with Networking
D . Last Known Good Configuration.
E . Safe Mode with Command Prompt .

Answer Winner # of Votes Explanation

A . YES 0 View

B . no 0 View

C . no 0 View

D . no 0 View

E . YES 3 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	0	View
B .	no	0	View
C .	no	0	View
D .	no	0	View
E .	YES	3	View

#96. You create and share a folder on a computer running Windows 2000 Server. The folder will be used to store documents that define corporate standards. Most employees use these files frequently. You set the shared folder permissions to allow Read access for Authenticated Users. You set the read-only attribute of each file in this folder.

How should you configure the offline folder setting for this shared folder to minimize network traffic?

A . Clear the setting Allow Caching of files in this shared folder
B . Manual Caching for Documents
C . Automatic Caching for Programs
D . Automatic Caching for Documents

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 3 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	0	View
C .	YES	3	View
D .	no	1	View

#97. You are the administrator of Windows 2000 Server computer. Volume D is formatted as NTFS. Volume D contains folders that are shared by departments within your company. You want to limit the amount of disk space that the shared folders can store. a user named Richard has stored 10GB of files in the shared folders. Richards files are using more disk space on the shared folders than any other users files. You enable disk quotas on Volume D and create a default quota entry. You set the quota limit to 1.1 BG and select the Deny disk space to users exceeding quota limit check box. When Richard attempts to encrypt the files in his home folder be using the encrypted file system he receives the following error messages There is insufficient disk space to complete the operation You need to allow Richard to encrypted the files in his home folder.

You also need to maintain Which three actions must you have? (Choose Three)

A . Create a quota entry for Richard, and select the Do not limit disk space check box.
B . Instruct Richard to encrypt the files in his home folder.
C . Run the Cipher.exe/d command
D . Enable the compression attribute on Richard’s home folder.
E . Set the Richards quota limit to equal the amount of disk space used by the files in his home directory.
F . Set the default quota entry on volume D to 12GB, and clear the Deny disk space too users exceeding quota limit check box.

Answer Winner # of Votes Explanation

A . YES 7 View

B . YES 7 View

C . no 1 View

D . no 1 View

E . YES 7 View

F . no 1 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	7	View
B .	YES	7	View
C .	no	1	View
D .	no	1	View
E .	YES	7	View
F .	no	1	View

Master Dump for Microsoft 70-215 #3

2008-12-22T17:14:00.000-08:00

#49. Melissa is monitoring the behaviours of one of the servers on her company's network. She notices that disk space on the D: drive is getting low. In order to remedy this, she decides to extend the volume to add additional free space. However when she attempts to perform this action she is unsuccessful. The computer has the following configuration:

-Windows 2000 Server (upgraded from NT 4.0 Server) -One Dynamic disk (converted from a basic disk) -Two simple volumes (C: and D:) both formatted with the NTFS file system (converted from the FAT file system) -C: drive is the active partition and the boot partition -4 GB of unpartitioned free space on the disk

What is the most likely reason why Melissa is unable to extend the D: drive?

A . The volume that Melissa is attempting to extend was initially formatted with FAT file system. In order to extend a simple volume it must have been initially formatted with the NTFS file system.
B . The volume that Melissa is attempting to extend is located on a disk that was initially a basic disk. In order to extend a simple volume it must be located on a disk that was initially created as a dynamic disk.
C . The volume that Melissa is attempting to extend contains the operating system files. You cannot extend a simple volume that contains the operating system files.
D . The volume that Melissa is attempting to extend has already been extended before. You may extend a volume only one time.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 11 View

C . no 8 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	YES	11	View
C .	no	8	View
D .	no	0	View

#50. Your company's network consists of a single native-mode domain. Within the domain you have Organizational Units (OUs) for Sales, Marketing and Finance. Each of the OUs has a person that has responsibility for the OU and has been given full administrative control over it.

At the domain level you have configured a policy called Mandatory that contains certain desktop restrictions and security settings that you would like to have applied to all users in the domain regardless of which organizational unit they are located in. However you find that user objects located in the Sales OU are receiving different settings than those specified in the Mandatory policy. You suspect that a policy (named "SalesSettings") created by the administrator of the Sales OU is causing this problem.

What can you do to ensure that the settings in the Mandatory policy are received by all users in the domain?

A . Set the link for the Mandatory policy at the domain level to No Override.
B . Set the link for the SalesSettings policy at the OU level to No Override.
C . Set the domain to Block Policy Inheritance.
D . Set the Sales OU to Block Policy Inheritance.
E . Enable loopback processing mode for the Mandatory policy.
F . Enable loopback processing mode for the SalesSettings policy.

Answer Winner # of Votes Explanation

A . YES 6 View

B . no 0 View

C . no 1 View

D . no 0 View

E . no 0 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	YES	6	View
B .	no	0	View
C .	no	1	View
D .	no	0	View
E .	no	0	View
F .	no	0	View

#51. Your Windows 2000 server is configured with four 30 GB hard drives (Disk 0, Disk 1, Disk 2 and Disk 3). All of the disks are dynamic disks. You have the operating system installed to a 5 GB partition on Disk 0. You currently do not have any other data stored on the disks.

You would like to provide fault tolerance for the operating system files in the event that the disk that the operating system is installed to fails. In addition, you will be storing data on the remainder of the disk subsystem. You would like to maximize performance but are not concerned about fault tolerance for this data.

Which of the following would provide the best solution?

A . Back up the boot and system partitions. Configure all four of the disks to be a RAID-5 volume. Restore the boot and system partitions to the RAID-5 volume.
B . Mirror the boot and system partitions to Disk 1. Configure a RAID-5 volume using the remaining 25 GB on Disk 0 and Disk 1 and 25 GB from Disk 2 and Disk 3.
C . Mirror the boot and system partitions to Disk 1. Configure a striped volume using the remaining 25 GB on Disk 0 and Disk 1 and 25 GB from Disk 2 and Disk 3.
D . Back up the boot and system partitions. Configure all four of the disks to be a striped volume. Restore the boot and system partitions to the striped volume.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . YES 6 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	1	View
B .	no	0	View
C .	YES	6	View
D .	no	0	View

#52. You have an accounting application that you want to be available to all people in the Accounting department. All of the members of the department occupy the fifth floor of your office. The computer accounts for all of the computers on that floor are located in an organizational unit (OU) called Accounting. However some of the user accounts for the members of the Accounting department are located in other OUs besides the Accounting OU such as the Accounting Manager who is located in the Managers OU.

You would like to have the accounting application available to all users in the department when they log in from a computer on the fifth floor.

What would be the best way to configure this?

A . Create a GPO and link it to the domain. Publish the application to computers within the domain. Filter the GPO to apply only to the computers in the Accounting OU.
B . Create a GPO and link it to the domain. Publish the application to users within the domain. Filter the GPO to apply only to the users in the Accounting OU.
C . Create a GPO and link it to the Accounting OU. Publish the application to computers within the OU.
D . Create a GPO and link it to the Accounting OU. Assign the application to computers within the OU.
E . Create a GPO and link it to the Accounting OU. Publish the application to users within the OU.
F . Create a GPO and link it to the Accounting OU. Assign the application to users within the OU.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 0 View

D . YES 4 View

E . no 1 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

Answer	Winner	# of Votes	Explanation
A .	no	0	View
B .	no	0	View
C .	no	0	View
D .	YES	4	View
E .	no	1	View
F .	no	0	View

#53. As the person in charge of administration for the Marketing Department you have been given Full Control to a folder called Marketing which contains numerous subfolders and files that consist of data for the department. The Marketing folder is a subfolder of a parent folder named Departments. Other subfolders of Departments include Customer Service, Finance and Sales. The directory structure looks like this: http://www.2000tutor.com/images/folders.gif

You have configured the permissions properly for the Marketing department to only allow certain individuals the appropriate permissions. However, when you come into work one day you notice that the permissions have been changed to the Marketing folder and the subfolders and files contained within it. The administrator of the Finance department also complains that permissions have been changed to the Finance folder and its contents. You suspect that someone has modified the permissions to the Departments and that the permission assignments have propagated down to your folders.

What is the best way to prevent this from happening in the future?

A . Check the "No Override" box for the Departments folder.
B . Clear the "Allow inheritable permissions from parent to propagate to this object" check box for the Departments folder.
C . Check the "No Override" box for the Marketing folder.
D . Clear the "Allow inheritable permissions from parent to propagate to this object" check box for the Marketing folder.
E . Locate all user accounts that have the Change Permissions or Full Control permission allowed for the Departments folder and change the permission to "Deny".

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 5 View

C . no 0 View

D . no 2 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

#54. As you migrate to Windows 2000 it is important to consider whether you wish to make resources available to your users through Active Directory. This will allow your users to query Active Directory and locate the resources based on various characteristics.

On your network you have a machine running Windows 2000 Server. This machine is a member of an Active Directory domain named acme.com. You decide to install a printer named HPLaser5 on the server. You also decide to share out a folder named AcctInfo.

Assuming the default settings, which of the following statements would be correct?

A . Both the printer and the shared folder will be published in Active Directory.
B . Only the printer will be published in Active Directory. You will have to manually publish the shared folder in Active Directory.
C . Only the shared folder will be published in Active Directory. You will have to manually publish the printer in Active Directory.
D . Neither the printer nor the shared folder will be published in Active Directory. You will have to manually publish both in Active Directory.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 5 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#55. One of the differences between basic disks and dynamic disks is the number of partitions (on basic disks) and volumes (on dynamic disks) that each can contain.

Which of the following statements regarding this is correct?

A . Basic disks can contain a maximum of two partitions. Dynamic disks can contain a maximum of four volumes.
B . Basic disks can contain a maximum of two partitions. Dynamic disks can contain an unlimited number of volumes.
C . Basic disks can contain a maximum of four partitions. Dynamic disks can contain a maximum of 24 volumes.
D . Basic disks can contain a maximum of four partitions. Dynamic disks can contain an unlimited number of volumes.
E . Basic disks can contain an unlimited number of partitions. Dynamic disks can contain a maximum of four volumes.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 1 View

D . YES 4 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

#56. Distributed File System (DFS) is a feature of Windows 2000 that gives administrators to ability to present a logical view of folders and files on the network without regard to their physical location. The first step in creating a DFS tree is to create the DFS root. After creating the DFS root, you then create nodes, known as "DFS links".

Which of the following statements regarding the creation of the DFS root and the DFS links are correct? (Choose all that apply.)

A . A domain-based DFS root can only be created on computers running Windows 2000.
B . A DFS root must be created on an NTFS partition.
C . A DFS root must be created on a dynamic disk.
D . DFS links can only be created on computers running Windows 2000.
E . DFS links must be created on NTFS partitions.
F . DFS links must be created on dynamic disk.

Answer Winner # of Votes Explanation

A . YES 5 View

B . no 0 View

C . no 0 View

D . no 0 View

E . no 0 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

#57. You have just recently installed Active Directory on your corporate LAN. You currently have a single domain environment with four domain controllers and have not transferred any of the operation master roles. One day another one of the administrators removes Active Directory from the first domain controller installed into the domain. You want to ensure that changes can still be made to objects within the database.

What must you do to ensure that operations continue normally?

A . Nothing, a domain controller will automatically be promoted to the role of Primary Domain Controller (PDC).
B . Nothing, the operations master roles will automatically be transferred to another domain controller.
C . Promote one of the functional domain controllers to the role of Primary Domain Controller (PDC).
D . Transfer the operations master roles of schema master and domain naming master to one of the functional domain controllers.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 3 View

C . no 0 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

#58. Your network has over 200 Windows 2000 Server computers. They are all members of the same domain. You have made all of the members part of the Servers Organizational Unit (OU). You have configured each Windows 2000 Server computer to audit local security events. The servers are used for different purposes, thus you have configured different servers to audit different local security events. You would now like to institute a policy that makes all of the Windows 2000 Servers have identical local security auditing policies. You must also ensure that auditing remains standardized even if the audit policy changes.

How should you do this?

A . Configure a local auditing policy on each domain controller
B . Configure a local auditing policy on each computer
C . Configure a local group policy object on each server in the Servers OU
D . Configure a domain group policy object and apply it to the Servers OU

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 1 View

D . YES 2 View

Vote for an answer! Submit an explanation or correction.

#59. John, an employee in your company has used windows 2000 encrypting file system on his windows 2000 computer to encrypt a file that contains sensitive information. John's computer belongs to the domain that you administer. When john left the company Greg was hired for the position. You must enable greg to access the contents of the encrypted file.

Which of the following should you do?

A . Log on to john's computer by using the local administrator account and decrypt the file.
B . Back up the encrypted file restore the backup on your computer and decrypt the file.
C . Assign greg the take ownership permission for the file and let him take ownership.
D . Copy the encrypted file to a fat volume.

Answer Winner # of Votes Explanation

A . YES 5 View

B . YES 5 View

C . no 2 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#60. You are the administrator of a Windows 2000 server computer named Intra. This server hosts an intranet web site for your company. The marketing department stores marketing files in a shared folder on a separate file server. The NTFS permissions on the folder are shown on this exhibit:

- Exhibit 1: Marketing users have full control

- Exhibit 2: Virtual Directory with Read, Log Visit, and Index this resource boxes checked and Write and Directory Browsing boxes unchecked

The marketing director wants to make the marketing files available to the rest of the company via internet. She wants company users to be able to read but no modify all the files. You create a new virtual directory named marketing under the intranet web site folder on Intra. You configure the virtual directory as shown some users report that they cannot access the marketing files from their web browsers. However, all users in the marketing department are able to access the files. You need to provide need acess to all company users.

What should you do?

A . Select directory browsing check box on virtual directory tab.
B . Copy files form their location on the file server to the Intra Marketing.
C . Modify NTFS permission on the file server to remove the entry for Marketing.
D . Modify NTFS permission on the file server to include an entry for Everyone: Read

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 0 View

D . YES 2 View

Vote for an answer! Submit an explanation or correction.

#61. You wish to audit the activity of the accounting department's share folder for file and subfolder deletion. The share folder is on a Windows 2000 server.

What steps will you take to activate this security measure?

A . Enable auditing of the Directory Service Access event in Local Policies node of the Computer Configuration. Enable auditing of the Delete Subfolders and Files for each folder you wish to audit.
B . Enable auditing of the Delete Subfolders and Files in the Security tab of the domain object's property sheet.
C . Enable Audit Object Access event in Local Policies node of the Computer Configuration. Enable auditing of the Delete Subfolders and Files for each folder you wish to audit.
D . Enable auditing of the Delete Subfolders and Files in the property sheet of the share in Explorer.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . YES 2 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#62. You want to install Windows 2000 Server using NTFS on a new computer that currently has Windows 98 on a single 2Gb hard drive with a single partition. The partition is the size of the hard drive, and formatted as FAT32.

Which one of the following options for hard drive preparation is valid for this computer?

A . Install Windows 2000 over Windows 98, and run the Convert utility to create a second partition for NTFS. Use secedit commands to apply the default NTFS permissions to this converted file system.
B . Use the existing partition as the system partition for the Windows 2000 operating system, and create a second partition using the Disk Management Tool for NTFS after installation is complete.
C . Start the installation of Windows 2000 using the option to select the system partition during the installation. Run the Convert utility to create a second partition for NTFS, and apply the default NTFS permissions with secedit.
D . Repartition the hard drive, creating a partition size required for your Windows 2000 installation. Format it as NTFS, FAT32 or FAT16 during installation. Leave the remaining hard disk space to be formatted by the Disk Management Tool after installation.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 1 View

C . no 0 View

D . YES 2 View

Vote for an answer! Submit an explanation or correction.

#63. You have already created an unattended answer file using Setup Manager with 10 computers named. Before you begin the installations, you are asked if you can include three more computers. What will be required for you to include more computers in the unattended installation over the network?

A . Edit the unattend.txt file with Notepad
B . Edit the unattend.udf file with Notepad
C . Edit the winnt.sif file with Notepad
D . Edit the unattend.bat file with Notepad

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 5 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#64. Your unattended setup is failing over a device that you provided a Windows 2000 compatible driver and .inf file for in the \$oem$\$1\Drivers subdirectory of the distribution folder. What did you overlook when you were preparing for the unattended installation?

A . The driver was not installed on the source computer using Sysdiff
B . The Cmdlines.txt file does not include a Rundll32.exe command
C . The [Unattended] section of the answer file must set the key OemPreinstall=Yes
D . The dosnet.inf file does not refer the incompatibility in the ServicesToDisable section

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 2 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#65. You work on a computer running Windows NT Workstation 4.0 that is a member of a Windows 2000 domain running in mixed-mode. You want to manage the printers defined on a print server that is a member of the same domain. The print server is also configured as a Web Server and DHCP server. You need to have access to real-time information about the print devices managed by the print server.

What application can you install on your Windows NT workstation to manage the printers on the print server, as well as view the real-time print device information?

A . Adminpak.msi
B . Windows 2000 Device Manager
C . Internet Explorer 5.0
D . Directory Services Client

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . YES 3 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

#66. You manage a computer running Windows 2000 Server. You create a file in a folder on an NTFS partition of the computer. You configure the following NTFS permissions for the file:

"h Authenticated Users Read & Execute, Read "h Accounting Full Control "h Jack Deny Write

Accounting is a local group, Jack is a member of the group Accounting What is Jack's effective permission(s) for the file?

A . Cannot be determined - it depends on the parent folder permissions
B . Read and Execute, Read
C . No access
D . Full control

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 3 View

C . no 0 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

#67. You are looking for a new driver for an application server monitor hoping to improve its resolution. However, a warning is issued when you select a driver from the Microsoft list. What procedure should you follow when selecting a monitor driver?

A . Download the latest driver for your monitor from the Microsoft site to ensure compatibility with your hardware and other Plug and Play devices on your system.
B . Download a current driver from the manufacturer for the make and model of your monitor, and install it to avoid damage to the monitor.
C . Choose to manually select the driver from the Microsoft list to assure hardware compatibility with your operating system.
D . Let the Microsoft wizard find the proper Plug and Play driver so the settings will work with other devices on the system.

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 3 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#68. You enable Terminal Services in Application Server Mode on a computer running Windows 2000 Server. You install and configure three applications on the server. Five users who will run these applications using the Terminal Services client have print devices connected to USB ports on their computers. Those computers run Windows 98, and each user has local printers defined for the device connected to his or her computer.

What step should you take to allow the users to print to their local devices when running an application from the Terminal Services client?

A . Define a script to run when each user starts a Terminal Services session. Use the net use command in this script to redirect print output to the local port.
B . Log on interactively at the Terminal Services server. Run the Add Printer wizard to define a printer for each of the print devices.
C . Install the print drivers for the devices on the Terminal Services server.
D . Instruct each user to run the Add Printer wizard from a Terminal Services session to define a local printer.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . YES 3 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

#69. You create a printer on a computer running Windows 2000 Server. A user reports that she has been trying to print to the network printer from an MS-DOS based application. She has been unsuccessful.

What should you do to solve this printing problem?

A . Run the application in MS-DOS Exclusive mode.
B . Increase the amount of memory given to this MS-DOS application.
C . Use the MS-DOS LPRINT command.
D . Map a physical port to the network printer at a command prompt

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 1 View

D . YES 3 View

Vote for an answer! Submit an explanation or correction.

#70. You plan to install Windows 2000 Server on 10 new computers on your company's network. These servers will provide file and print services to departments within the company. The computers have identical hardware and will use the same software configuration. You plan to use a centralized copy of the Windows 2000 installation files, which are stored on an existing Windows 2000 Server computer.

Which three actions should you take to install Windows 2000 Server on the new computer? (Choose three.)

A . Create a set of installation boot disks by using Makeboot.exe.
B . Create an MS-DOS network boot disk.
C . Create an Unattend.txt file by using Setup Manager. Create a UDF file that identifies the names of the new computers.
D . Create a UDF file by using setup manager. Create an Unattend.txt file that identifies the names of the new computers.
E . Begin the installation process by running the Winnt command with the /S, /U, and /udf switches.
F . Begin the installation process by running Winnt32 command with the /s, /unattend, and /udf switches.

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 8 View

C . YES 8 View

D . no 0 View

E . YES 8 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

#71. You are the administrator of a Windows 2000 network. You have installed two shared printers for a print device on a Windows 2000 Server. Both printers are available to all users. They are shared as Admin and Executive. Admin is configured with a priority of 90, Executive is configured with a priority of 50. Now, you are advised to prevent the printer Executive to be visible to all users. Only members of the Executive group should be able to print to Executive.

What should you do?

A . Allow the Executive Group print permission only. Remove the sharename Executive and add the sharename Executive$. Reconnect all members of the Executive Group to the new sharename.
B . Install a second printer driver for the print device. Set NTFS permissions to the new driver files so that only the Executive Group is allowed to access the files.
C . Deny print permission to the Everyone Group.
D . Change the priority of Executive to 99, so that ...........

Answer Winner # of Votes Explanation

A . YES 5 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#72. You are the administrator of a Windows 2000 Server computer. The server hosts several web sites that have logging enabled. You use a third-party reporting utility to analyze the log files produced by the web sites. You notice that all data from 7:00pm to midnight each night is included in the following day's logfile. You want all data to be included in the correct day's log file.

What should you do?

A . Ensure that the log type is set to W3C.
B . Change the log rollover property in the website's logging properties.
C . Change the time zone setting in the time properties on the web server.
D . Configure the time service on the web server to use local system account.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 4 View

C . no 1 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#73. You are a recently hired network administrator at Awesome Computer. Awesome Computer has an office in New York and Toronto. Company network configured as:

Toronto Office: Windows 2000 Domain Controller Monitor1 with community name of AwesomeA WebServer with community name of AwesomeA

New York Office:Windows 2000 domain Controller Monitor2 with community name of AwesomeB ApplicationServer with community name of AwesomeB

These two offices are linked to two routers with Internet between the routers.You are responsible for monitoring all servers from Monitor1.

What should you do?

A . Relocate the ApplicationServer to Toronto office.
B . Move ApplicationServer computer account to Toronto domain.
C . Add AwesomeA to the list of accepted community names on ApplicationServer.
D . Add public to the list of accepted community names on ApplicationServer.
E . Remove all community names from ApplicationServer.
F . Remove all community names from Monitor2.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . YES 2 View

D . no 0 View

E . no 0 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

Master Dump for Microsoft 70-215 #2

2008-12-22T17:05:00.000-08:00

#25. You are a network administrator at Contoso, Ltd. You work at the main office in Seattle. The branch office in Denver is a call center. The network consists of a Windows 2000 domain only. The network is configured as shown in the exhibit. Denver is a Token Ring network. Seattle is an Ethernet network. None of you r network adapters at Contoso, Ltd. support promiscuous mode. The Router does not support multicast traffic. Wks1.contoso.com and mem1.contoso.com are available for use as network monitor clients. You want to be able to detect and identify rogue installations of network monitor on your network by using the fewest possible computers. What should you do? (check all that apply)

A . Install network monitor tools on wks1.contoso.com by using the Windows Components wizard.
B . Install the SNMP protocol on wks1.contoso.com by using the Windows Components wizard.
C . Install network monitor tools on mem1.contoso.com by using the Windows Components wizard.
D . Install the SNMP protocol on mem1.contoso.com by using the Windows Components wizard.
E . Install a network adapter on wks1.contoso.com that supports promiscuous mode.
F . Install a network adapter on mem1.contoso.com that supports promiscuous mode.

Answer Winner # of Votes Explanation

A . no 13 View

B . no 6 View

C . YES 16 View

D . no 2 View

E . no 1 View

F . no 1 View

Vote for an answer! Submit an explanation or correction.

#26. You are the administrator of a Windows 2000 Server computer. The server contains one network adapter and is a file and print server for critical company resources. You install a second network adpater in the server and connect it to the same network subnet as the first adapter. You want to ensure that the first adapter is used for all netowkr traffic and the second adapter is used only if the first adapter fails or is disconnected from the network. You also want to ensure that the server always has network connectivity even if one network adapter fails.

What should you do?

A . Set the second adapters status to disable.
B . Configure the first adapter to use a TCP/IP metric of 100.
C . Configure the second adapter to use a TCP/IP metric of 25.
D . Configure the binding order on the second adapter to bind TCP/IP last.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 1 View

C . YES 8 View

D . no 2 View

Vote for an answer! Submit an explanation or correction.

#27. You install a new application on a computer running Terminal Services in Application Server mode. Users of this application must have access to files stored on a computer running Netware 4.11. TCP/IP is not installed on the computer running Netware.

What steps should you take to enable Terminal Services clients to access the computer running NetWare?

A . Add NWLink to the Local Area Connection of the Terminal Services server. Configure NWLink with frame type 802.2.
B . Add NWLink to the Local Area Connection of the Terminal Services server and to the Local Area Connection of the Terminal Services clients. Configure NWLink with frame type 802.3.
C . Add NWLink to the Local Area Connection of the Terminal Services server. Configure NWLink with frame type 802.3.
D . Add NWLink to the Local Area Connection of the Terminal Services server and to the Local Area Connection of the Terminal Services clients. Configure NWLink with frame type 802.3.

Answer Winner # of Votes Explanation

A . YES 7 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#28. You are the administrator of a Windows 2000 Server computer. You configure the server to audit all access to files that are places in shared folders. One week after you configured the server, users report that the server has stopped responding. You investigate the problem and discover a stop error with the error message: Stop C0000244 (Audit Failed). An attempt to generate a security audit failed. You restart the computer. You need to ensure that you can keep a record of all files access on the server. You also need to ensure that the stop error will not occur again.

A . Set the CrashonAuditFail registry key to 0.
B . Set the Security Log to overwrite events as needed.
C . Delete the Liscense Trial registry key.
D . Increase the size of the security log.
E . Save the security log to a file, and clear it every morning.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 10 View

C . no 0 View

D . no 2 View

E . no 8 View

Vote for an answer! Submit an explanation or correction.

#29. Computer accounts and user accounts in your domain have been seperated into OUs for administrative purpose. You want to require strong passwords for the local user accounts only.

What should you do?

A . Set a Group Policy on each local computer to enable the passwords must meet complexity requirements policy.
B . Set a Group Policy on the domain to enable the passwords must meet complexity requirements policy.
C . Set a Group Policy on all OUs containing computer accounts to enable the passwords must meet complexity requirements policy.
D . Set a Group Policy on all OUs containing user accounts to enable the passwords must meet complexity requirements policy.

Answer Winner # of Votes Explanation

A . YES 13 View

B . no 6 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#30. You wish to setup a domain policy to have passwords expire in 30 days. You wish to setup a local computer policy to have passwords expire in 90 days. (Choose two)

A . Set Domain Policy for password expiration in 30 days.
B . Set Domain Policy for password expiration in 90 days.
C . Set OU for password expiration in 30 days.
D . Set OU for password expiration in 90 days.
E . Set Local Computer Policy for password expiration in 30 days.
F . Set Local Computer Policy for password expiration in 90 days.

Answer Winner # of Votes Explanation

A . YES 6 View

B . no 0 View

C . no 0 View

D . no 0 View

E . no 0 View

F . YES 6 View

Vote for an answer! Submit an explanation or correction.

#31. You are the administrator of 20 Windows 2000 Professional computers and 2 Windows 2000 Server computers for your domain. You want to set an account policy that locks any user account after 3 failed logon attempts. You also want to ensure that only administrators will be able to unlock the account.

What should you do? (Choose 2)

A . Set the account lockout duration to 0.
B . Set the account lockout duration to 3.
C . Set the account lockout threshold to 0.
D . Set the account lockout threshold to 3.
E . Set the reset account lockout after to 0.
F . Set the reset account lockout after 3.

Answer Winner # of Votes Explanation

A . YES 7 View

B . no 0 View

C . no 0 View

D . YES 7 View

E . no 1 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

#32. You are the administrator of a high security network. Many files stored on your Windows 2000 file servers and Windows 2000 Professional computers are highly confidential. You want to implement identical security configurations on all Windows 2000 file servers and Windows 2000 Professional computers.

What should you do? (Choose all that apply)

A . Configure Group Policies to apply the security configuration to all Windows 2000 file servers and Windows 2000 Professional computers.
B . Use the Security Configuration Management Console to import security information from a file server as a template.
C . Use the Security Configuration Management Console to import security information from a Windows 2000 Professional Computer as a template.
D . Use Secedit to export the security configuration to all file servers.
E . Use Secedit to export the security configuration to all Windows 2000 Professional computers.

Answer Winner # of Votes Explanation

A . YES 3 View

B . no 2 View

C . no 1 View

D . no 1 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

#33. Both of your domains are Active Directory domains that run in native mode.

How can you see a list that shows which users are allowed to use remote access to your network ??

A . Create a group named RAS_USERS. Add users who are permitted to dial in to the network. Create a remote access policy that allows this group to use the remote access server. Display the members of the group .
B . Create a group named RAS_USERS. Add users who are allowed to dial into the network. Set the remote access permissions for this group to allow access. To show who has access to the remote access server display the members of the group.
C . Write a script for the windows scripting host in the script through the members of the users container. Display the name of any user who has the remote access permission set to allow access.
D . Use the default remote access policy to users and groups who have been granted remote access permissions.

Answer Winner # of Votes Explanation

A . YES 6 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#34. You are the network administrator at Island Hopper News. The domain and network configuration is a single-site Windows 2000 domain that is configured as shown in the exhibit. You must provide Terminal Services to the Pentium MMX client computers. You also need to be able to manage user liscenses and enable users to access term1.islandhoppernews.com. First you install Terminal Services in Application server mode on term1.islandhoppernews.com.

What should you do next?

A . Install Terminal Services liscensing on term1.islandhoppernews.com. Select the Enterprise liscense server option.
B . Install Terminal Services liscensing on term1.islandhoppernews.com. Select the Domain liscense server option.
C . Install Terminal Services liscensing on file1.islandhoppernews.com. Select the Enterprise liscense server option.
D . Install Terminal Services liscensing on file1.islandhoppernews.com. Select the Domain liscense server option.
E . Install Terminal Services liscensing on uu2.islandhoppernews.com. Select the Enterprise liscense server option.
F . Install Terminal Services liscensing on uu2.islandhoppernews.com. Select the Domain liscense server option.

Answer Winner # of Votes Explanation

A . no 1 View

B . no 0 View

C . no 0 View

D . no 0 View

E . no 1 View

F . YES 7 View

Vote for an answer! Submit an explanation or correction.

#35. You have a HP printer using JetDirect driver on your network, the user will print the package label with this Printer. It is configured to use HPCL. Later, your user complained about the slowness in printing the package labels.

what should you do then?

A . HPCL -> RAW
B . HPCL -> Postscript
C . Add another HP printer, blah, blah
D . Add another 3 HP printer, blah, blah

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 5 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#36. You are the administrator of a Windows 2000 Network. You want to upgrade 50 NT Server machines to W2K 2000 and place them in a single domain. The domain includes 300 member client computers consisting of 200 Windows Professional computers and 100 NT workstation computers. You implement GPO's for each OU. However, you want to restrict users of the W2K Professional computers from accessing registry editing tools.

What should you do?

A . Create an OU that contains all win nt users and computers Create a GPO in the OU that restricts users from accessing registry editing tools
B . Create a NT system policy file on the W2K domain controller Configure the policy so that it restricts default users from accessing registry editor tools
C . Create a mandatory user profile for the win nt users that removes any shortcuts or registry editor and system policy editor from each users desktop
D . Create a NT System policy file that restricts default users from accessing registry editing tools. Save the system policy to each users home folder.

Answer Winner # of Votes Explanation

A . YES 8 View

B . no 2 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#37. You have a new modem on a W2K server. When you restart the computer W2k detects the modem and installs the default drivers. Occasionally the modem stops communicating with your ISP and you have to restart. You download an updated driver for the modem and save it to your winnt folder.

What do you do next?

A . In the property sheet for the modem device you click on the UPDATE DRIVER command button
B . Use device manager to search for hardware changes
C . use device manager to delete the modem, the restart the pc
D . move new driver to the winnt\drivercache folder, restart your pc

Answer Winner # of Votes Explanation

A . YES 8 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#38. A W2K server has 2 disks attached to an EIDE. You need additional space. You add a new scsi disk controller that has 6 new disks attached. the new controller is not included on the current HCL. When you restart you computer, W2K does not detect the new controller.

What do you do? (Choose 2)

A . Use device manager to turn of the IRQ steering in the properties of the standard pc
B . Use the disk manager to restore the basic configuration. Restart the pc.
C . Use the add/remove hardware wizard to add a new scsi and raid controller supplied by the manufacturer
D . Use disk management to rescan the disks
E . Use the manufacturer’s setup program to install the driver for the scsi disk controller

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 9 View

D . no 1 View

E . YES 9 View

Vote for an answer! Submit an explanation or correction.

#39. You configure a local group called Accounting and create a mandatory profile for the group. The profile include a logo saved with 16 bit colour and 1024 x 768. Some pcs in Accounting have a standard VGA adapter while others have a SVGA adapter. 4 users say the bitmap is distorted and display the wrong colour depth. You want these users to view it correctly.

What to do?

A . Configure a roaming profile.
B . Configure a seperate profile for each user.
C . Change to 16 bit 640 x 840 and reconfigure.
D . Reinstall appropriate WDM compliant drivers for pcs that do not display the bitmap correctly

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 6 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#40. Your network contains two routed subnets: Subnet A and Subnet B. Subnet B contains a Windows 2000 server configured as a DHCP server. This server has scopes created for both Subnet A and Subnet B. Subnet A does not contain a DHCP server.

The clients on Subnet A are not receiving IP addresses from the DHCP server.

What can you do to enable clients in Subnet A to receive dynamically assigned IP addresses? (Choose all that apply)

A . Configure an RFC 1542-compliant router to forward BOOTP messaging between subnets.
B . Configure an RFC 1560-compliant router to pass all UDP traffic on ports 2151, 2152, 2153 and 2154.
C . Install and configure a DHCP server on Subnet A.
D . Configure the clients on Subnet A to use H-node NetBIOS name resolution.
E . Configure a DHCP relay agent on Subnet A to forward DHCP messages to Subnet B
F . Create a superscope on the DHCP server in Subnet B which contains both the scope for Subnet A and the scope for Subnet B.

Answer Winner # of Votes Explanation

A . no 7 View

B . no 2 View

C . no 3 View

D . no 0 View

E . YES 8 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

#41. You are the administrator of a Windows 2000 workgroup at Awesome computer. Users currently do not have access to the internet.you want to all users to be able to access the Internet by using MEM3.

Which three are correct? (choose three)

A . Configure the appropriate DHCP scope options on MEM2
B . Anable ICS on MEM3
C . Install and configure Windows 2000DNS server on MEM2

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 4 View

C . no 1 View

Vote for an answer! Submit an explanation or correction.

#42. You are planning the installation of windows 2000 server on a new computer that has four 50-GB hard disk drives installed. You want windows 2000 setup to create a single partition on disk 0 of the largest possible size and to install the operating system on the partition. After windows 20000 has been installed you also want to configure the remaining three disks in such a way that the maximum amount of space on all four disks can be accessed from a single drive letter.

Which of the following methods should you use to achieve your objectives?

A . On disk0 create a 4 GB fat16 partition during setup. Use disk management to covert all four disks to dynamic disks and combine unallocated space on all four disks into a single spanned volume.
B . On disk 0 create a single 50 GB ntfs partition during setup. Use disk management to create a single 50 GB ntfs partition on each of the remaining disks and then mount each partition to a separate empty folder on disk 0.
C . On disk 0 create a 32 FB fat32 partition during setup. Use disk management to convert all four disks.
D . On disk 0 create a single 50 GB ntfs partition during setup. Use disk management to convert all four disks to dynamic disks and then extend the simple volume on disk 0 to include all of the remaining disks into a single striped volume.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 5 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#43. You have an application server named App1. On this server you have many custom built programs. All of these programs are launched as a service on startup. You have one program that is called Finance. This application is critical to your Accounting department. You find that the Finance program is making App1 unstable due to errors in the program code. You want to have App1 run stable until the code errors are fixed. What should you do? (Not exactly word for word, but you get the idea. It was worded bad on the exam too)

A . Open Task Manager and run the Finance application as /BelowNormal
B . Open Task Manager and run the Finance application as /Low
C . Don't remember - It was wrong
D . Open Services and change the startup type from Automatic to Manual

Answer Winner # of Votes Explanation

A . no 0 View

B . no 4 View

C . no 0 View

D . YES 8 View

Vote for an answer! Submit an explanation or correction.

#44. You have the following exhibit:

(garbled litware.com, contoso.com, is.litware.com, finance.litware.com, is.contoso.com, support.is.litware.com, support.contoso.com & development.contoso.com)

You need to deploy and service pack to the support.is.litware.com domain and the support.contoso.com.

How should you deploy?

A . Assign to litware.com and contoso.com domains
B . ??
C . Create 2 sites, 1 tree in each site. Create a GPO in each site
D . Create 1 site that contains 2 trees. Creat a GPO for the site

Answer Winner # of Votes Explanation

A . YES 2 View

B . no 1 View

C . no 0 View

D . no 1 View

Vote for an answer! Submit an explanation or correction.

#45. You are the Administrator of windows 2000 server computer. The computer is configured to have a single 18 GB drive which contains the operating systems (OS) files. This drive also contain a share folder where 5 network users store there MS excel files. You want to prevent each network user from using more than 1 GB of space in the shared folder.

Which action or actions should you take to achieve this goal? (Choose all that apply)

A . Create a quota entry for everyone account. Set the quota limit to 1 GB.
B . Enable disk quotas on the volume.
C . Set default quota limit to 1 GB.
D . Select the deny disk space to users exceeding quota limit check box.
E . Upgrade the disk to a dynamic disk.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 8 View

C . YES 8 View

D . YES 8 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

#46. You currently have two Terminal Servers in your company named TServer1 and TServer2. Both of the servers are running Terminal Services in application server mode. You would like to configure the Terminal Servers so that all Authenticated Users have access to TServer1 but only members of the Finance group have access to TServer2.

What could you do to allow only members of the Finance group to access TServer2 while still allowing other users to access TServer1?

A . From the Terminal Service Configuration utility, choose the connection for TServer2 and configure the permissions so that only the Finance group has the ability to access the server.
B . In the Terminal Services Profile tab in a user's properties, disable the option for "Allow logon to Terminal Services" for all users that are not members of the Finance group.
C . Enable Terminal Services in remote administration mode on TServer2.
D . Change the configuration for TServer2 so that all users other than members of the Finance group have only guest access.

Answer Winner # of Votes Explanation

A . YES 4 View

B . no 0 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#47. Encrypting File System (EFS) provides an additional measure of security for confidential documents on your network.

Which of the following statements about EFS are true? (Choose all that apply.)

A . Users can share encrypted files.
B . Encrypted files can become decrypted if the user copies or moves the file to a FAT volume.
C . System files and compressed files can be encrypted.
D . Encrypting a folder or file does not protect against deletion. Anyone with delete permission can delete encrypted folders or files.
E . Only files and folders on NTFS volumes can be encrypted.

Answer Winner # of Votes Explanation

A . no 7 View

B . no 7 View

C . no 1 View

D . no 6 View

E . YES 10 View

Vote for an answer! Submit an explanation or correction.

#48. Your Windows 2000 Server computer has the following configuration:

-One physical hard disk configured as a basic disk-One partition (C:) formatted with the FAT file system

You would like to support disk quotas and the Encrypting File System (EFS) on your computer.

What must you do to allow this?

A . Convert the disk from a basic disk to a dynamic disk.
B . Convert the C: drive to the FAT32 file system.
C . Convert the C: drive to the NTFS file system.
D . Format the C: drive with the FAT32 file system.
E . Format the C: drive with the NTFS file system.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 7 View

D . no 0 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

What is the most likely reason why Melissa is unable to extend the D: drive?

A . The volume that Melissa is attempting to extend was initially formatted with FAT file system. In order to extend a simple volume it must have been initially formatted with the NTFS file system.
B . The volume that Melissa is attempting to extend is located on a disk that was initially a basic disk. In order to extend a simple volume it must be located on a disk that was initially created as a dynamic disk.
C . The volume that Melissa is attempting to extend contains the operating system files. You cannot extend a simple volume that contains the operating system files.
D . The volume that Melissa is attempting to extend has already been extended before. You may extend a volume only one time.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 11 View

C . no 8 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

Master Dump for Microsoft 70-215

2008-12-22T15:14:00.000-08:00

#1. You are the administrator of a server called X. There is only one domain in server X. Server X has a folder named Accounting that holds alot of sensitive information, and can be accessed by two groups with these permissions:

Accounting global group: Full Control Users: Full Control

Eric is a user of the domain and needs full access to the Accounting folder. You make Eric a member of the Accounting global group, but when Eric tries to access the Accounting folder he is not allowed access.

What should you do to give him access to the Accounting folder?

A . Have Eric sign off and sign back on.
B . Give the Everyone group read access to the Accounting folder.

C . Make Eric a member of the Local Administrator group.

D . Can't remember the last chose, but it was wrong

Answer Winner # of Votes Explanation

A . YES 93 View

B . no 8 View

C . no 12 View

D . no 2 View

Vote for an answer! Submit an explanation or correction.

#2. Your network has two domains with approximately 1,000 users in each domain. Both domains are Active Directory domains that run in native mode. Some of the users have portable computers and access the network by using remote access.

The managers at your company are concerned that remote access might pose a security risk. They want to see a list that shows which users are allowed to use remote access.

How should you configure the remote access to display a list of authorized users?

A . Create a group named RAS_USERS. Add users who are permitted to dial in to the network. Create a remote access policy that allows only this group to use the remote access server. To show who has access to the remote access server, display the members of the group.
B . Create a group named RAS_USERS. Add users who are allowed to dial in to the network. Set the remote access permission for this group to allow access. To show who has access to the remote access server, display the members of the group.

C . Write a script for the windows scripting host. In the script, iterate through the members of the users container. Display the name of any user who has the remote access permission set to Allow access.

D . Use the default remote access policy to view users and groups who have been granted remote access permission.

Answer Winner # of Votes Explanation

A . YES 43 View

B . no 7 View

C . no 2 View

D . no 6 View

Vote for an answer! Submit an explanation or correction.

#3. You want to upgrade a Windows NT Server 4.0 computer named Server34 to Windows 2000 Server. Server34 is a member server in a Windows 2000 domain named marketing.fabrikam.local. The domain runs in native mode. You want to change the role of Server 34 from a member server to a domain controller in the same domain. What should you do? (Choose two.)

A . Reinstall Windows NT Server 4.0 on Server 34 in the same WINNT folder, and make Server 34 a BDC in the marketing domain.
B . Use Server Manager on Server34 and promote Server34 to a PDC for the marketing domain.

C . Upgrade Server34 to Windows 2000 Server.

D . Run the Active Directory Installation wizard to make Server34 a domain controller in the marketing.fabrikam.local domain.

E . Run the Active Directory Installation wizard to convert Server34 to a domain controller in the fabrikam.local domain.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 3 View

C . YES 54 View

D . YES 54 View

E . no 2 View

Vote for an answer! Submit an explanation or correction.

#4. You back up all of the system state date for each domain controller and place the date on a single tape. That tape is currently attached to the Srv1.west.litware.com computer. To which server or servers can you restore the system state from srv1.west.litware.com(choose all apply)

A . srv1.west.litware.com
B . srv2.west.litware.com

C . srv3.west.litware.com

D . srv4.west.litware.com

E . srv5.west.litware.com

F . srv6.west.litware.com

Answer Winner # of Votes Explanation

A . YES 30 View

B . no 4 View

C . no 4 View

D . no 4 View

E . no 4 View

F . no 4 View

Vote for an answer! Submit an explanation or correction.

#5. You are the administrator of a Windows 2000 Server computer named Server1. You create a Distribute file system (Dfs) root named Public. You add a shared folder named Docs as a Dfs node under the root. The share permissions and NTFS permissions for Public and Docs are shown in the following table.

Folder Share permissions NTFS permissions ----------------------------------------------------------------------------------- Public Everyone: Read Everyone: Read Domain Admins: Full Control

Docs Users: Read Training: Full Control Domain Admins: Full Control Domain Admins: Full Control

A user named Maria is a member of the Users and Training user groups. When Maria attempts to save the file \\Server1\Public\Docs\memo.doc, she receives the following error message: "Access denied." You want Maria to be able to change and delete all files in the Docs folder. You do not want her to have more access than necessary. What should you do?

A . Add Maria to the Domain Admins group.
B . Add Maria to the local Administrators group.

C . Set the share permissions for the Public folder to grant Maria Full Control permission.

D . Set the share permissions for the Docs folder to grant Maria Change Permission.

E . Set the NTFS permissions for the Public folder and is sub objects to grant Maria Modify permission.

F . Set the NTFS permissions for the Docs folder and its sub objects to grant Maria Full Control permission.

Answer Winner # of Votes Explanation

A . no 3 View

B . no 0 View

C . no 1 View

D . YES 15 View

E . no 1 View

F . no 2 View

Vote for an answer! Submit an explanation or correction.

#6. You are the administrator for your company. Your Windows 2000 Server computer contains two 23GB hard disks. Each disk is configured as a basic disk and has a single 23GB NTFS partition. Both partitions are backup up to tape every night. The partition on Disk1 stores user data. Most users of your company encrypt their files. Disk1 fails. You replace it with a new disk. You need to recover the data as quick as possible while maintaining the security of the files.

What should you do?

A . Create a single NTFS partition. Restore the contents of Disk1 from the most recent tape backup. Run the cipher /d /i command.
B . Create a single NTFS partition. Restore the contents of Disk1 from the most recent tape backup. Instruct the users to verify the integrity of their files.

C . Create a single NTFS partition. Restore the contents of Disk1 to a second file server. Logon to the server console as a recovery agent. Copy the files from the second file server to the new partition.

D . Create a single NTFS partition. Restore the contents of Disk1 to a second file server. Instruct users to copy their files from the second file server to the new partition.

Answer Winner # of Votes Explanation

A . no 1 View

B . YES 20 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#7. Running system monitor locally and ensuring it has least impact on other processes, how do you measure the physical disk performance counters on your win2000 server computer?

A . From the command prompt run the start/low perform command
B . Use Task manager to set the priority off the MMC.EXE process to Low

Answer Winner # of Votes Explanation

A . no 3 View

B . YES 18 View

Vote for an answer! Submit an explanation or correction.

#8. You have two Windows 2000 servers, SRV1 and SRV2. SRV1 has a spanned volume over three physical disks. These disks support hot swapping. The drive letter that the spanned volume uses on SRV1 is not currently in use on SRV2. You want to move the three disks to SRV2, using the same drive letter as SRV1. You back up the spanned volume.

What should you do next? (choose two)

A . Move the disk from SRV1 to SRV2.
B . on SRV1 rescans the disks. On SRV2, rescan the disks

Answer Winner # of Votes Explanation

A . YES 13 View

B . no 9 View

Vote for an answer! Submit an explanation or correction.

#9. Your hard-drive configuration is as follows and one of your drives fails.

Controller label 1 Disk label EIDE Controller 0 EIDE Disk 0 and Disk 1

Controller label 2 Disk label SCSI Controller 1 SCSI Disk 0, 1, 2, 3, 4, 5, 6

The disk that fails is multi(1)disk(0)rdisk(1)partition(1). Place an "X" on the drive that has failed in the configuration below: ID Disk

A . EIDE 0 (disk 1)
B . EIDE 1 (disk 2)

C . SCSI 0 (disk 1)

D . SCSI 1 (disk 2)

E . SCSI 2 (disk 3)

F . SCSI 3 (disk 4)

G . SCSI 4 (disk 5)

H . SCSI 5 (disk 6)

Answer Winner # of Votes Explanation

A . no 3 View

B . no 4 View

C . no 0 View

D . YES 19 View

E . no 0 View

F . no 0 View

G . no 0 View

H . no 0 View

Vote for an answer! Submit an explanation or correction.

#10. Your network uses the TCP/IP protocol for its Windows 2000 prof and win2000 NT computers. You have one server that acts as both a Wins server, and a DNS server. All the client computers are configured to use this server for DNS and WINS. Users of Windows NT Workstation cannot connect to file server, but Windows 2000 professional users can. This server has a static address off 192.168.1.11. What should you do to allow the Windows NT Workstation computer to connect to the file server??

A . Select the Enable NetBIOS over TCP/IP.
B . Add the WINS address used by the Windows NT Workstation computers.

Answer Winner # of Votes Explanation

A . YES 12 View

B . no 1 View

Vote for an answer! Submit an explanation or correction.

#11. You have configured a Group Policy Object (GPO) for the marketing organization unit (OU) to prevent users from accessing My Network Places and from running System in Control Panel. You want the Managers Domain Local Group to be able to access My Network Places, but you still want to prevent them from running System in Control Panel. What should you do?

A . Add the Managers group to the access control list of the GPO. Disable the permission of the managers group to read and apply the Group Policy.
B . Add the Managers group to the access control list of the GPO. Deny the permission of the managers group to read and apply the Group Policy.

C . Create a second GPO in the OU. Add the Managers group to the access control list. Allow the managers group to apply the Group Policy. Deny the Authenticated Users group permission to read and apply the Group Policy. Configure the new GPO to deny the ability to run system Control Policy Panel. Give the original GPO a higher priority than the new GPO.

D . Create a second GPO in the OU. Add the Managers group to the access control list. Allow the managers group to apply the Group Policy. Disable the Authenticated Users group permission to read and apply the Group Policy. Configure the new GPO to allow access to My Network Places. Give the original GPO a higher priority than the new GPO.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 2 View

D . YES 9 View

Vote for an answer! Submit an explanation or correction.

#12. Your company has a Routing and Remote Access server at its main office. One of the company?¦s branch offices also runs Routing and Remote Access on a server that has one modem. This server is configured to use demand-dial routing to connect to the main office. This server is part of the company?¦s Active Directory domains. The domain runs in native mode.

Some employees at this branch office use the branch office same to access their files from here. The manager of the branch office reports that sometimes none of the user in the office can connect to the main office. When you examine the event log on the branch office server to find that users have been connecting to the server during working hours.

The manager wants users to be able to dail in to the server between 6:00p.m. and 8:00a.m. However, the manager still wants users to be able to log on at any time when connected directly to the LAN.

A . Change the logon hours for user’s accounts to deny between 8:00a.m. and 6:00p.m.
B . Set the remote access policy to deny connection between 8:00a.m. and 6:00p.m.

C . Create one batch file to start Remote Access Connections Manager server, and create another batch file to stop it. Schedule the stop batch file to run at 8:00a.m. every day and the start batch file to run at 6:00 p.m. every day.

D . Create two user accounts for each user. Grant dail-in permission for an account and deny dail-in permission to second account. Change the login hour for the dail-in accounts to de logon between 8:00 a.m. and 6:00p.m.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 7 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#13. You have four different distribution shares on your network for Windows 2000 Server installations. A new service pack was just announced.

What should you do to make the service pack available for future installations?

A . Copy the service pack's driver.cab to the distribution "share", as well as layout.inf, dosnet.inf and txtsetup.sif
B . Use update /slip to apply the service pack to each "share".

C . Copy the layout.inf, dosnet.inf and txtsetup.sif files to each distribution "share".

D . Use sysdiff /diff to apply the service pack to each "share".

Answer Winner # of Votes Explanation

A . no 2 View

B . YES 8 View

C . no 1 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#14. Your company has a human resources (HR) manager named Sean Chai. He keeps your company's confidential HR files in a shared folder. To increase the security of the HR files, Sean set the folder to encrypt the files. Sean leaves the company without resetting the permissions and encryption settings for the HR files. The files must be made accessible to the new HR manager.

Which two actions should you take to allow this access? (Choose two.)

A . Set the file permissions on the HR files to allow access to the new manager.
B . Back up the shared folder to tape and restore the files to a different folder.

C . Log on as an administrator and remove the encryption attribute from the HR files.

D . Log on as the new manager, connect to the shared folder, and run the cipher /e /s . command.

E . Configure the new manager's account to be an Encrypted Data Recovery Agent for Sean's account.

Answer Winner # of Votes Explanation

A . no 10 View

B . no 4 View

C . YES 19 View

D . no 1 View

E . no 10 View

Vote for an answer! Submit an explanation or correction.

#15. You are the network administrator at Humongous Insurance, a major insurance comapny that has 1,000 offices world wide. You are configuring the network so that only the sales staff can connect to it from home. Your Windows 2000 forest contains a member server named SV1 that has Routing and Remote Access for Windows 2000 enabled. You configure SV1 to use a modem bank to accepr incoming dial-up attempts. You configure SV1 to use Windows Authentication as the authentication Provider. The only supported authentic method is MS CHAP V2. You need to restrict access to SV1. What should you do?

A . Create an OU named SS. Populate SS with the sales staff user accounts. Provide access to this OU by using the Client-Friendly-Name attribute of the default remote access policy.
B . Create an OU named SS. Populate SS with the sales staff user accounts. Provide access to this OU by using the Windows-Group attribute of the default remote access policy.

C . Create a new remote access policy. Add the Everyone group to this policy by using the Windows-Group attribute in the properties of each sales staff user acounts. Control dial-in access through remote policy.

D . Create a Windows 2000 global group. Populate this global group with the sales staff user accounts. Provide access to the global group by using Windows-Group attributes of the default remote access policy.

Answer Winner # of Votes Explanation

A . no 2 View

B . no 0 View

C . no 2 View

D . YES 8 View

Vote for an answer! Submit an explanation or correction.

#16. Some applications on your company network use defined domain user accounts as their service accounts. Each computer that runs one of these applications should have the respective service account in the Local Administrators Group. Currently, you individually place these service accounts in the Local Administrators Group on the appropriate Windows 2000 Professional computers. You need to centralize this process. What should you do?

A . Add the applications service accounts to the Domain Administrator Group.
B . Add the applications service accounts to the Local Administrator Group. Use the Restricted Groups option in each computer's local group policy.

C . Add the applications service accounts to the Local Administrator Group. Use the Restricted Groups option in an OU Group Policy.

D . Add the applications service accounts to the Local Administrator Group. Use the Restricted Groups option in a Domain Group Policy.

Answer Winner # of Votes Explanation

A . no 2 View

B . no 0 View

C . no 1 View

D . YES 7 View

Vote for an answer! Submit an explanation or correction.

#17. You install a second modem on a Windows 2000 Server computer configured with Routing and Remote Access. Dial-in users report that they are unable to connect to the server by using this new modem.

What can you do to help find out the cause of the problem? (Choose Three.)

A . Use the Diagnostics tab in Phone and Modem Options in Control Panel to query the modem.
B . Use device Manager to identify any port resource conflicts.

C . Use the Routing and Remote Access snap-in to find out whether the ports for both modems are operational.

D . From a command prompt, run the Net Config Server command.

E . From a command prompt, run the Net Statistics command.

F . Use Regedit32 to view the Error Control value in the HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\RemoteAccess Key.

Answer Winner # of Votes Explanation

A . YES 6 View

B . YES 6 View

C . YES 6 View

D . no 0 View

E . no 0 View

F . no 0 View

Vote for an answer! Submit an explanation or correction.

#18. You install a new server application on your Windows 2000 Server computer. Response times fail to meet user specifications. You want to use the Process page in Task Manager to find out whether the response time of new application would improve by the addition of one or more processors.

Which two columns should you select to view? (Choose two.)

To answer, click the two appropriate check boxes in the Select Columns dialog box. Display image

A . User Objects
B . Virtual memory size

C . Memory usage delta

D . CPU usage

E . Page faults

F . Thread count

G . Handle count

H . I/O write bytes

I . Base priority

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 5 View

D . YES 13 View

E . no 0 View

F . no 7 View

G . no 0 View

H . no 0 View

I . no 2 View

Vote for an answer! Submit an explanation or correction.

#19. How can you assign an application to one processor exclusively?

A . Right click on application executable, select properties and select assign processor.
B . Right click on application process in Task Manager, select Set Affinity, and select the appropriate processor.

C . Open Task Manager, chose options from task bar, select processor and assign processes to appropriate processor.

D . Open Task Manager, chose Performance, chose view all processors, assign processes to appropriate processor.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 9 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#20. Your company network includes a PentiumII, 450Mhz database server names Webdata1. Webdata1 supports a high-traffic e-commerce web site on a server names Webserver1. Users access the e-commerce website from their Internet browsers. Users report that when they attempt to complete a purchase, they must wait five minutes for confirmation that their order has been processed. You want to use Task Manager to help you decide whether an additional processor is needed. What should you do?

A . On the performance tab, select the option to monitor the system cache.
B . On the performance tab, select the option to monitor the available physical memory.

C . On the process tab, select the option to monitor the memory usage column, Monitor this column.

D . On the proces tab, configure the view to include the thread count column, Monitor this column.

E . On the proces tab, configure the view to include the page faults column, Monitor this column.

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . no 0 View

D . YES 6 View

E . no 0 View

Vote for an answer! Submit an explanation or correction.

#21. Your Windows 2000 Server computer has two SCSI hard disks. The hard disks are configured as SCSI ID 0 and SCSI ID 1 on a single SCSI host bus adapter. The hard disks are mirrored and each hard disk is formatted with a single NTFS partition. One of the hard disks has just failed. After replacing the failed hard disk with a new disk, what else should you do to recover from the hard disk failure?

A . Choose Establish Mirror in disk administrator
B . Choose Break Mirror in disk administrator and then choose regenerate in Disk Administrator

C . Choose Break mirror in disk administrator and then choose establish mirror in disk administrator

D . Wait for Windows NT to regenerate the mirror

Answer Winner # of Votes Explanation

A . no 0 View

B . no 0 View

C . YES 11 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#22. You have 5 SCSI drives. You have created an ERD disk during installation. Now you have made some changes in the configuration of the SCSI drives. You want to save the changes for future use. What will you do?

A . Use RDISK.EXE to create a new ERD to take account of the new configuration change.
B . Use SCSI applet in Control Panel

C . Use NT Backup Program

D . Use Disk Administrator

Answer Winner # of Votes Explanation

A . no 2 View

B . no 0 View

C . YES 10 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#23. Your Windows 2000 Server computer contains four 16GB hard disks. Disk0 is configured as a basic disk. Disk0 has a single 16GB partition that contains the boot and system files. Disk 1, 2 and 3 are configured as dynamic disks in a RAID5 volume. The entire server is backed up to a tape drive each night. During your daily review of the servers event logs, you discover that Disk1 has failed. You shut down the server and replace Disk1 with a new hard disk. When you restart the server Windows 2000 starts normally, but the data on the RAID5 volume is inaccessible. Disk Management indicates that Disk2 has failed too. You replace Disk2 with a new hard disk. Now you need to recover the data on the RAID5 volume as quickly as possible. What should you do?

A . Use Disk Manager to rebuild RAID5 partition.
B . Delete and recreate the RAID5 partition. Restore the contents of RAID5 partition from the most recent tape backup.

C . Use Windows 2000 backup to restore the contents of Disk2. Use Disk Manager to rebuild the RAID5 partition on Disk1.

D . Delete and recreate the RAID5 partition. Restart the server by using Windows 2000 Setup CD, and select repair option.

Answer Winner # of Votes Explanation

A . no 0 View

B . YES 12 View

C . no 0 View

D . no 0 View

Vote for an answer! Submit an explanation or correction.

#24. Your Windows 2000 server provides DNS for you network. You are not able to ping a Unix server called Unix1. You add a record to your server DNS for the Unix server, but you still are unable to ping the server. What should you do? (choose two)

A . Restart DNS on the Windows 2000 server.
B . Windows 2000 server does not support Unix server entries.

C . Run ipconfig /registerdns on the unix server.

D . Stop the DNS client service and restart it.

E . Run the ipconfig /flushdns command.

Answer Winner # of Votes Explanation

A . no 2 View

B . no 0 View

C . no 7 View

D . no 5 View

E . YES 12 View

Vote for an answer! Submit an explanation or correction.

A . Install network monitor tools on wks1.contoso.com by using the Windows Components wizard.
B . Install the SNMP protocol on wks1.contoso.com by using the Windows Components wizard.

C . Install network monitor tools on mem1.contoso.com by using the Windows Components wizard.

D . Install the SNMP protocol on mem1.contoso.com by using the Windows Components wizard.

E . Install a network adapter on wks1.contoso.com that supports promiscuous mode.

F . Install a network adapter on mem1.contoso.com that supports promiscuous mode.

Answer Winner # of Votes Explanation

A . no 13 View

B . no 6 View

C . YES 16 View

D . no 2 View

E . no 1 View

F . no 1 View

Vote for an answer! Submit an explanation or correction.

MCDBA bundle Braindumps Section

2008-12-22T14:45:00.000-08:00

MCDBA bundle Certification
70-215	Installing, Configuring and Administering Microsoft Windows 2000
70-216	Implementing and Administering a Microsoft Windows 2000 Network
70-228	Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
70-229	Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Braindumps provide the most comprehensive MCDBA bundle training - through our online virtual MCDBA bundle bootcamps. MCDBA bundle certification has never been easier to study for, and complete with MCDBA bundle notes, you are sure to pass your MCDBA bundle exams. Each complete MCDBA bundle course in our MCDBA bundle bootcamp cover the next MCDBA bundle exam, provide a complete MCDBA bundle practice exam, and ensure your MCDBA bundle test success with an MCDBA bundle study guide.

Combining our detailed MCDBA bundle braindumps with our proved MCDBA bundle boot camps, is certain to provide you with the MCDBA bundle training required for you to pass the MCDBA bundle tests. There is no more complete and comprehensive method for MCDBA bundle course preparation, than a Braindumps MCDBA bundle boot camp.

What is an MCDBA bundle braindump? MCDBA bundle braindumps are an actual inside look at the MCDBA bundle test material, providing you with advanced knowledge through our MCDBA bundle study guide, MCDBA bundle notes, MCDBA bundle practice exams - all to give the best MCDBA bundle tests and MCDBA bundle exam preparation.

Start today with our MCDBA bundle braindump. With so many MCDBA bundle braindumps to choose from, you have a virtual MCDBA bundle boot camp available to you for your best MCDBA bundle exams study. MCDBA bundle bootcamps, and the MCDBA bundle boot camps at Braindumps are specially designed to allow MCDBA bundle certification ease of preparation. Select your MCDBA bundle bootcamp with confidence that your MCDBA bundle training for your MCDBA bundle tests and MCDBA bundle exams are backed by the quality MCDBA bundle notes, MCDBA bundle practice exams, and MCDBA bundle study guides.

Start down the road to MCDBA bundle test success utilizing all of the benefits found on our MCDBA bundle certification and MCDBA bundle course - MCDBA bundle bootcamp. One place, one stop, only one MCDBA bundle braindump.

MCDBA on Microsoft SQL Server 2000 Certification

2008-12-22T14:43:00.000-08:00

The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

The MCDBA on SQL Server 2000 certification is appropriate for:

•	Database administrators.
•	Database analysts.
•	Database developers.

By earning the premier MCDBA on SQL Server 2000 credential, individuals are demonstrating that they have the skills necessary to lead organizations in the successful design, implementation, and administration of SQL Server databases.

MCDBA on SQL Server 2000 candidates should have at least one year of experience working with SQL Server. For additional requirements to earn the MCDBA on SQL Server 2000 credential please read MCDBA on SQL Server 2000 Requirements.

Naming Guidelines

2008-12-22T14:20:00.000-08:00

Guidelines for naming database objects are important for identifying the type of object and to promote ease in troubleshooting or debugging. When naming database objects, you should:

Use meaningful names where possible.

For example, for a column that contains the name of customers, you could name the column Chr_Name_Of_Customer. A prefix of Chr in the column name denotes a character data type.

Keep names short.

For example, although the column name Chr_Name_Of_Customer is meaningful, you could shorten the column name to Name or Chr_Name.

Use a clear and simple naming convention.

Decide what works best for your situation, and be consistent. Avoid naming conventions that are too complex, because they can become difficult to remember. For example, you can remove vowels if an object name must resemble a keyword (such as a backup stored procedure named Bckup).

Chose an identifier that distinguishes the type of object, especially when using views and stored procedures.

System administrators often mistake views for tables, an oversight that can cause unexpected problems. For example, if you create a view that joins two tables, you could name that view, SoldView.

Keep object names and user names unique.

For example, avoid creating a Sales table and a sales role in the same database.

SQL Server Object Names

2008-12-22T14:12:00.000-08:00

SQL Server provides a series of standard naming rules for object identifiers and a method of using delimiters for identifiers that are not standard. It is recommended that you name objects by using the standard identifier characters, if possible.

Standard Identifiers

Standard identifiers can contain from one to 128 characters, including letters, symbols (_, @, or #), and numbers. No embedded spaces are allowed in standard identifiers. You should observe the following rules for using identifiers:

The first character must be an alphabetic character of a-z or A-Z.

After the first character, identifiers can include letters, numerals, or the @, $, #, or _ symbol.

Identifier names starting with a symbol have special uses:

An identifier beginning with the at sign (@)denotes a local variable or parameter.
An identifier beginning with a number sign (#) denotes a temporary table or procedure.
An identifier beginning with a double-number sign (##) denotes a global temporary object.


	Note: Names for temporary objects should not exceed 116 characters, including the number sign (#) or double-number sign (##), because SQL Server gives temporary objects an internal numeric suffix.

Delimited Identifiers

If an identifier complies with all of the rules for the format of identifiers, you can use it with or without delimiters. If an identifier does not comply with one or more of the rules for the format of identifiers, it must always be delimited.

You can use delimited identifiers in the following situations:

When names contain embedded spaces

When reserved words are used for object names or portions of object names

You must enclose delimited identifiers in brackets or quotation marks when you use them in Transact-SQL statements.

Bracketed identifiers are delimited by square brackets ([ ]):

SELECT * FROM [Blanks In Table Name]


	Note: You can always use bracketed delimiters, regardless of the status of the SET QUOTED_IDENTIFIER option.

Quoted identifiers are delimited by quotation marks (""):

SELECT * FROM "Blanks in Table Name"

You can use quoted identifiers only if the SET QUOTED_IDENTIFIER option is on.

Data Manipulation Language Statements

2008-12-22T14:05:00.000-08:00

DML statements work with the data in the database. By using DML statements, you can change data or retrieve information. DML statements include:

SELECT

INSERT

UPDATE

DELETE

By default, only members of the sysadmin, dbcreator, db_owner, db_datawriter, and db_datareader roles can execute DML statements.

Example

This example retrieves the category ID, product name, product ID, and unit price of the products in the Northwind database.

SELECT CategoryID, ProductName, CategoryID, ProductID, UnitPrice FROM Northwind..Products

Data Definition Language Statements

2008-12-22T14:02:00.000-08:00

Data Definition Language (DDL) statements define the database by creating databases, tables, and user-defined data types. You also use DDL statements to manage your database objects. Some DDL statements include:

CREATE object_type object_name.

ALTER object_type object_name.

DROP object_type object_name.

By default, only members of the sysadmin, dbcreator, db_owner, or db_ddladmin role can execute DDL statements. In general, it is recommended that no other accounts be allowed to create database objects. If users create their own objects in databases, then each object owner is required to grant the proper permissions to each user of those objects. This causes an administrative burden and should be avoided. Restricting statement permissions to these roles also avoids problems with object ownership that can occur when an object owner has been dropped from a database, or when the owner of a stored procedure or view does not own the underlying tables.

If multiple user accounts create objects, the sysadmin and db_owner roles can use the SETUSER function to impersonate other users or the sp_changeobjectowner system stored procedure to change the owner of an object.

Example

The following script creates a table called Client in the ClassNorthwind database. It includes CustomerID, Company, Contact, and Phone columns.

USE ClassNorthwind
CREATE TABLE Client
(CustomerID int, Company varchar(40),Contact varchar(30),
Phone char(12) )

Data Control Language Statements

2008-12-22T01:28:00.000-08:00

You use Data Control Language (DCL) statements to change the permissions associated with a database user or role. The following table describes the DCL statements.

		Statement		Description

		GRANT		Creates an entry in the security system that allows a user to work with data or execute certain Transact-SQL statements.

		DENY		Creates an entry in the security system that denies a permission from a security account, and prevents the user, group, or role from inheriting the permission through its group and role memberships.

		REVOKE		Removes a previously granted or denied permission.

By default, only members of the sysadmin,dbcreator,db_owner, or db_securityadmin role can execute DCL statements.

Example

This example grants the public role permission to query the Products table.

USE Northwind
GRANT SELECT ON Products TO public

Elements of Transact-SQL

2008-12-22T01:27:00.000-08:00

As you write and execute Transact-SQL statements, you will use different languages statements, which are used to determine who can see or modify the data, create objects in the database, and query and modify the data. You should follow the rules for naming SQL Server objects, and become familiar with the naming guidelines for database objects.

In this lesson you will learn about the following topics:

Data control language statements

Data definition language statements

Data manipulation language statements

SQL server object names

Naming guidelines

The Transact-SQL Programming Language

2008-12-22T01:25:00.000-08:00

Transact-SQL is the SQL Server implementation of the entry-level ANSI-SQL International Standards Organization (ISO) standard. The ANSI-SQL compliant language elements of Transact-SQL can be executed from any entry-level ANSI-SQL compliant product. Transact-SQL also contains additional language elements that are unique to it.


	Important: It is recommended that you write scripts that include only ANSI-SQL standard statements to increase the compatibility and portability of your database.