Discussion
Home ‣ Certification ‣ Microsoft Certification Comments
- Question
You use Visual Studio .NET to develop a Windows-based application that interacts with a Microsoft SQL Server database. Your application contains a form named CustomerForm. You add the following design-time components to the form: ? SqlConnection object named XYZConnection. ? SqlDataAdapter object named XYZDataAdapter. ? DataSet object named XYZDataSet. ? Five TextBox controls to hold the values exposed by XYZDataSet. At design time, you set the DataBindings properties of each TextBox control to the appropriate column in the DataTable object of XYZDataSet. When you test the application, you can successfully connect to the database. However, no data is displayed in any text boxes. You need to modify your application code to ensure that data is displayed appropriately. Which behavior should occur while the CustomerForm.Load event handler is running?
Options- A. Execute the BeginInit method of XYZDataSet.
- B. Execute the Open method of XYZConnection.
- C. Execute the FillSchema method of XYZDataAdapter and pass in XYZDataSet.
- D. Execute the Fill method of XYZDataAdapter and pass in XYZDataSet.
- Correct Answer
- Execute the Fill method of XYZDataAdapter and pass in XYZDataSet.
ExplanationDataset is a container; therefore, you need to fill it with data. You can populate a dataset by calling the Fill method of a data adapter.
- 1. Someone has created a new document using Word 2010 and sent you a copy. The document is not protected and you have rights to view the content and even make changes. However, they have inserted a hyperlink to a company website but when you click the hyperlink nothing happens. What might be wrong?
Options- A. Hyperlinks do not open automatically, you need to paste them into your web browser
- B. You need to hold the Ctrl key whilst clicking the hyperlink
- C. Its impossible to add hyperlinks to a document. Maybe they formatted it to look like a link.
- D. You need to hold the Alt key whilst clicking the hyperlink Discuss
- 2. The navigation pane in Word 2010 has several tabs that let you move through the information in your document in different ways. Which of the following tabs is part of the Navigation pane?
Options- A. Browse by heading
- B. Browse by search results
- C. Browse by page
- D. All of these Discuss
- 3. Sachin works for a computer training institute in North America.After discussing the steps of installing Windows XP professional in the class room, sachin divided the students in a group of two and asked them to complete the installation on their respective machines.But none of the students were able to complete the installation process.Identify the solution that is the cause to the above problem.
Options- A. Needs to run XP Upgrade Adviser to avoid compatibility problem
- B. Needs to run XP Upgrade Professional to avoid compatibility problem
- C. Needs to run XP Upgrade Home Edition to avoid compatibility problem
- D. Needs to run XP Service Pack to avoid compatibility problem Discuss
- 4. Your network consists of a single Active Directory domain named contoso.com. The functional level of the domain is Windows Server 2003. You have a file server named Server1 that is used to store users' home folders and profiles. On Server1, you create a folder named D:data and share the folder as UserData. You create a new user account named TemplateUser in Active Directory. You need to ensure that each user account you create by copying TemplateUser is configured to have a unique home folder stored in the UserData share. Which home folder path should you specify?
Options- A. D:\data\%homedrive%
- B. D:\data\%username%
- C. \\server1\userdata\%homedrive%
- D. \\server1\userdata\%username% Discuss
- 5. Your network consists of a single Active Directory domain. The domain includes a group named SalesUsers. You have a file server that runs Windows Server 2003 Service Pack 2 (SP2). The server has a folder named CorpData. You share the CorpData folder and assign the Domain Users group the Full Control share permission. In the CorpData folder, you create a folder named Sales. You need to configure security for the Sales folder to meet the following requirements: -Members of the SalesUsers group must be able to read, create, and modify all files and folders. -All other users must be able to view items in the folder. What should you do?
Options- A. On the Sales folder, block permission inheritance and remove permissions. Assign the Allow Modify permission to the SalesUsers group.
- B. On the Sales folder, block permission inheritance and copy permissions. On the Sales folder, assign the Allow Modify permission to the SalesUsers group.
- C. On the CorpData share, change the share permission for Domain Users to Read. On the Sales folder, assign the Allow Modify permissions to the SalesUsers group.
- D. On the CorpData folder, block permission inheritance and remove permissions. In the Sales folder, assign the Allow Modify permissions to the SalesUsers group. Discuss
- 6. You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows. You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal. What should you do?
Options- A. Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data.
- B. Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
- C. Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format.
- D. Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data. Discuss
- 7. You have a portable computer named Computer1 that runs Windows 7. You have a file server named Server1 that runs Windows Server 2008. Server1 contains a shared folder named Share1. You need to configure Computer1 to meet the following requirements: Ensure that cached files from Share1 are encrypted. Ensure that files located in Share1 are available when Server1 is disconnected from the network. What should you do?
Options- A. On Server1, encrypt the files in Share1. On Computer1, make Share1 available offline.
- B. On Server1, configure BitLocker Drive Encryption. On Computer1, make Share1 available offline.
- C. On Computer1, make Share1 available offline and enable encryption of offline files.
- D. On Computer1, copy the files from Share1 to the Documents library and configure BitLocker Drive Encryption. Discuss
- 8. Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). You enable auditing for failed logon attempts on all domain controllers. You need to ensure that a record of failed logon attempts is retained for 90 days on all domain controllers. What should you do?
Options- A. From the Security Templates snap in, open the hisecdc template. Modify the Retain System Log setting.
- B. From the Security Templates snap in, open the securedc template. Modify the Retain Security Log setting.
- C. Open the Default Domain Policy. Modify the Retain System Log setting.
- D. Open the Default Domain Controller Policy. Modify the Retain Security Log setting. Discuss
- 9. Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do?
Options- A. Examine the System Event Log on the user's computer.
- B. Examine the System Event Log on both domain controllers.
- C. Examine the Security Event Log on both domain controllers.
- D. Examine the Application Event Log on the user's computer. Discuss
- 10. You have a computer that runs Windows 7. The computer connects to the corporate network by using a VPN connection. You need to ensure that you can access the Internet when the VPN connection is active. The solution must prevent Internet traffic from being routed through the VPN connection. What should you do?
Options- A. Configure a static DNS server address.
- B. Configure a static IP address and default gateway.
- C. Configure the security settings of the VPN connection.
- D. Configure the advanced TCP/IP settings of the VPN connection. Discuss
Microsoft Certification problems
Search Results
Correct Answer: You need to hold the Ctrl key whilst clicking the hyperlink
Correct Answer: All of these
Correct Answer: Needs to run XP Upgrade Adviser to avoid compatibility problem
Correct Answer: \\server1\userdata\%username%
Correct Answer: On the Sales folder, block permission inheritance and copy permissions. On the Sales folder, assign the Allow Modify permission to the SalesUsers group.
Correct Answer: Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
Explanation:
We need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier).
Incorrect Answers:
A: We could use a SqlConnection object only if the SQL Server were SQL Server 7.0, 2000 or later.
C: HTTP functionality is not required in this scenario. It would introduce unnecessary overhead.
D: ADODB is a legacy standard and should not be used here
Correct Answer: On Computer1, make Share1 available offline and enable encryption of offline files.
Correct Answer: Open the Default Domain Controller Policy. Modify the Retain Security Log setting.
Correct Answer: Examine the Security Event Log on both domain controllers.
Correct Answer: Configure the advanced TCP/IP settings of the VPN connection.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.