Microsoft Certification Questions

You are preparing to install Certificate Services for the first time on your Windows 2000 network. You plan to install Certificate Services on a Windows 2000 Server computer that is a member of the domain. You want the certification authority (CA) to be able to use Active Directory. Which CA type should you select when you install Certificate Services? 

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server database. The application stores encrypted credit card numbers in the database. You need to ensure that credit card numbers can be extracted from the database.
Which cryptography provider should you use?

When you run Sysprep on a Windows 2000 computer, what happens to the user-specific information on the computer?

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

You are archiving a Security Log for later analysis in a spreadsheet. Which file type should you assign to the log when you save it?

Your network consists of a single Active Directory domain. All network servers run Windows Server 2003 Service Pack 2 (SP2). You share a folder named Research. A user named User1 reports that he cannot access files in the Research share. You confirm that the Domain Users group is granted the Change permission for the Research share. You run the Cacls command as shown in the exhibit:

You need to ensure that User1 can modify files in the Research share. You must prevent User1 from modifying permissions for the Research folder. To which group should you add User1?

You create a System Policy file on a Windows 2000 Server computer to manage Windows NT 4.0 client computers  (and their users) on your Windows 2000 network. What filename should you assign to this System Policy file?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server 2008 database. The database includes a table named dbo.

Documents that contains a column with large binary dat a. You are creating the Data Access Layer (DAL). You add the following code segment to query the dbo.Documents table. (Line numbers are included for reference only.)

01public void LoadDocuments(DbConnection cnx)
02{
03var cmd = cnx.CreateCommand();
04cmd.CommandText = "SELECT * FROM dbo.Documents";
05...
06cnx.Open();
07
08ReadDocument(reader); }

You need to ensure that data can be read as a stream. Which code segment should you insert at line 07?