|
Question 1.
You need to design a solution for deploying the database to new stores as they are opened. Your solution must minimize the number of steps that are required to make the database ready for use in the production environment.
What should you do?
A. Replicate the database schema and all lookup data from an existing server to new servers.
B. Detach the database on an existing server, copy the database files to new servers, and attach
the copies on the new servers. Reattach the database on the existing server.
C. Use SQL Server Integration Services (SSIS) to copy the entire database from an existing
server to new servers.
D. Back up the database on an existing server, and restore the backup to new servers.
Answer: A
Question 2.
You need to ensure that products that have an inventory below the specified threshold are not included in the exported XML data that is sent to distributors. Your solution must require the minimum number of changes to any existing database objects.
What should you do?
A. Write a stored procedure that accepts all inventory changes and that removes products from
the database when product inventory falls below the specified threshold.
B. Write a trigger on the inventory table that updates the exclusion bit column whenever inventory
changes are made.
C. Write a SQL Server Agent job that updates the exclusion bit column based on current
inventory.
D. Write a user-defined function that updates the inventory table and the exclusion bit column,
and ensure that all database objects that update inventory use the new function.
Answer: B
Question 3.
You need to design a report that provides consolidated inventory information from selected stores. The report must be designed so that it will display aggregated inventory from only those stores that are selected by the user. Your solution must minimize additional network utilization.
What should you do?
A. Use SQL Server Integration Services (SSIS) to copy all inventory data from all servers into a
single temporary table. Design the report to use the temporary table as its data source and to
filter out data from stores that are not selected.
B. Implement replication so that all servers contain the inventory data from all other servers.
Design the report to use the server that is at the same location as the user who is running the
report.
C. Create a parameterized stored procedure that queries the required inventory data and returns
the results in a single result set. Design the report to use the stored procedure as its data
source.
D. On each server, create a view that displays that servers inventory data. Design a report that
uses the view from each server as a data source for the report and filters out data from stores
that are not selected.
Answer: C
Question 4.
You need to design a solution for importing weather-related data from the legacy system into the new weather database tables.
What should you do?
A. Write a SQL Server Integration Services (SSIS) package to import the data.
B. Write a Windows Forms application to import the data.
C. Use the bcp utility to import the data.
D. Write a managed assembly to import the data.
E. Write a view that uses linked servers to query the data from the ODBC database.
Answer: A
Question 5.
You need to design a solution for controlling changes to database objects on the SQL Server database servers. Your solution must comply with existing company policies and procedures.
What should you do?
A. Require developers to check in all code changes to a source control database.
B. Create a single database user account that has permission to change database objects.
C. Give one developer permissions to change database objects, and enable logging of those
changes on the server.
D. Disable replication of database objects between servers.
Answer: B
Question 6.
You need to ensure that proper business logic is used when data is provided to reports, so that the reports contain the correct data. What should you do?
A. Write a Windows application that queries the appropriate data and builds a new table
containing this data. Program SSRS to use the new table as a data source.
B. Use SQL Server Integration Services (SSIS) to copy production tables into reporting tables on
the same server. Program SSRS to obtain data from the reporting tables.
C. Program SSRS to obtain data by using appropriate Transact-SQL queries.
D. Write one or more parameterized stored procedures that return data. Program SSRS to use
the stored procedures and the correct parameters to query data for reports.
Answer: D
Question 7.
To improve performance, you need to redesign the Store Reports view, which provides access to aggregated data.
What should you do?
A. Use a language that supports the .NET Framework to rewrite the view as a stored procedure.
B. Use Transact-SQL to rewrite the view as a stored procedure.
C. Add indexes to the view.
D. Add indexes to the underlying tables that constitute the view.
Answer: D
Question 8.
You need to ensure that all orders are entered with complete, consistent, and accurate information. What should you do?
A. Write a parameterized stored procedure. Modify any application or object that enters orders so
that it will enter orders by using the new stored procedure.
B. Write a COM object that enters orders directly into the appropriate tables. Modify any
application or object that enters orders so that it will enter orders by using the new COM
object.
C. Write a managed assembly that enters orders directly into the appropriate tables. Modify any
application or object that enters orders so that it will enter orders by using the new assembly.
D. Modify the permissions of the tables that contain order information so that no end users have
direct access to the tables.
Answer: A
Question 9.
You need to ensure that all newly entered orders are communicated to the shipping system.
What should you do?
A. Write a COM object that accepts all orders and inserts them directly into the appropriate
database tables and into the shipping system.
B. Create a CLR stored procedure that is used to enter all orders. Write the stored procedure to
enter data into the shipping system by using the COM object.
C. Create a SQL Server Integration Services (SSIS) package to export all orders into a CSV file
that is readable by the shipping system. Schedule the package to run hourly.
D. Write a trigger on the Order table that inserts the order data into the shipping system.
Answer: B
Question 10.
You need to ensure that store managers receive low-inventory e-mail messages. Your solution must minimize additional processing load on the SQL Server computers.
What should you do?
A. Write a Notification Services event that sends e-mail messages to store managers when low
inventory conditions occur for a product.
B. Write an SSRS report listing all low-inventory products, and ensure that the report is sent by e-
mail to each store manager.
C. Write a SQL Server Agent job that sends low-inventory messages by e-mail to store
managers.
D. Write a trigger that runs whenever inventory is updated. Program the trigger to use the sp OA
family of stored procedures to launch a COM object that sends low-inventory messages by e-
mail to store managers.
Answer: A
Question 11.
You need to ensure that the XML data that is exported to distributors can be reviewed for accuracy at any time. Your solution must create a minimal amount of additional data.
What should you do?
A. Create a stored procedure that generates the XML data, and rerun the stored procedure when
the XML data needs to be reviewed.
B. Create a SQL Server Integration Services (SSIS) package that generates the XML data, and
rerun the package when the XML data needs to be reviewed.
C. Store generated XML data in an XML column within a new archival table.
D. Create a copy of the complete database each time the XML data is generated.
Answer: C
|
Question 1.
You work as a desktop technician at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server and all client computers run Windows XP Professional. A ITCertKeys.com user named Kara Lang uses a Windows XP Professional client computer named ITCertKeys -WS273. Kara Lang uses Microsoft Outlook 2002 to send e-mail messages. Kara Lang wants ITCertKeys -WS273 to be configured to view Microsoft Outlook shortcuts on the left side of the Microsoft Outlook window when ever she is busy with e-mail messages.
Which option should be used on the View menu of Microsoft Outlook?
A. Kara Lang should use the Outlook Bar option.
B. Kara Lang should use the Folder List option.
C. Kara Lang should use the Preview Pane option.
D. Kara Lang should use the Auto Preview option.
Answer: A
Explanation:
The Outlook Bar option in the View menu will display Outlook shortcuts on the left side when creating an e-mail message.
Incorrect Answers:
B: The Folder List option controls whether the Folder List is displayed in Outlook.
C: The Preview Pane option shows the content of the e-mail messages that will appear at the bottom of the Outlook screen.
D: The Auto Preview option controls what kind of view you want, maybe a small preview of each e-mail message.
Question 2.
You work as a desktop technician at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server and all client computers run Windows XP Professional and Microsoft Office XP. Ally Wagner is the CEO of ITCertKeys.com and uses a client computer named ITCertKeys -WS272. You have been instructed to add a new personal folder to Microsoft Outlook 2002 for Ally Wagner.
What should you do?
A. In Outlook 2002, select Toolbars from the View menu. Then click the New button.
B. In Outlook 2002, select Data File Management from the File menu. On the Outlook Data Files
dialog box, click the Close button.
C. In Outlook 2002, select Data File Management from the File menu. On the Outlook Data Files
dialog box, click the Add button. Then click the OK button twice.
D. In Outlook 2002, select Data File Management from the File menu. Then click the Open Folder
button. In the Open Outlook Data File window, click the Outlook data file and then click OK
twice.
Answer: C
Explanation:
If Ally Wagner click File, click New, click Outlook data file and then click the OK button twice; it will create a new Outlook personal folder file.
Incorrect Answers :
A: Click View and then click Outlook Bar in the View menu; will not create a new Outlook personal folder file.
B: Click File and click Data File Management and then click the Close button, will not create a new Outlook personal folder file.
D: Click File, click Open, click Outlook data file and then click the file in the Open Outlook Data File window and click OK twice; will not create a new Outlook personal folder file.
Question 3.
You work as a desktop technician at ITCertKeys.com. The ITCertKeys.com network contains a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server and all client computers run Windows XP Professional and Microsoft Office XP. Andy Reid is the manager of the Finance department at ITCertKeys.com. Andy Reid needs to send a confidential report to members of the board. Andy Reid attempts to encrypt the message to ensure that no unauthorized recipients can read the e-mail. He encrypts a test message and sends it to his secretary. However, the secretary reports that the message was not encrypted. Andy Reid contacts you for assistance. He wants to ensure that he can send encrypted e-mail messages.
What should you do?
A. Instruct Andy Reid to obtain a digital ID from the Exchange Server.
B. Instruct Andy Reid to use NTFS file encryption.
C. Instruct Andy Reid to obtain an encrypted e-mail message from the Exchange Server.
D. Instruct Andy Reid to obtain an encryption algorithm from the Exchange Server.
Answer: A
Explanation:
For Andy Reid to send encrypted e-mail messages, he should get a digital ID from the Exchange server.
Incorrect Answers :
B: NTFS file encryption can be used to encrypt files on an NTFS partition. It cannot be used to encrypt email messages.
C: Obtaining an encrypted e-mail message will not allow Andy Reid to encrypt his own messages.
D: Andy Reid does not need an encryption algorithm to send encrypted messages.
Question 4.
You work as a desktop support technician at ITCertKeys.com. The ITCertKeys.com network contains a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server and all client computers run Windows XP Professional.
A ITCertKeys.com user named Andy Booth uses a client computer named ITCertKeys -WS270. Andy Booth uses Microsoft Outlook 2003 to send e-mail messages to users on the ITCertKeys.com network. Some of the messages Andy Booth sends contain critical information. Andy Booth wants to ensure that only authorized recipients can read his e-mail messages. He also wants the recipients of his e-mail messages to be warned if the message was tampered with enroute to the recipient's inbox.
What should Andy Booth do?
A. He should create a rule in Microsoft Outlook.
B. He should compress and then encrypt his e-mail messages.
C. He should use Antivirus software to scan all outgoing e-mail messages.
D. He should encrypt and digitally sign his e-mail messages.
E. He should use a firewall.
Answer: D
Explanation:
Andy Booth should use encryption and digital signatures. Encryption is used to encrypt the messages and the digital signatures are used to allow the receiver to read the content.
Incorrect Answers :
A: Rules are applied to incoming e-mail messages. They are not used to secure outgoing messages.
B: A file cannot be compressed and encrypted at the same time.
C: Scanning outgoing e-mail messages for virus does not ensure that only authorized users can read the e-mail.
E: Firewall provides paITKet-filtering for traffic entering a network. It does not secure e-mail messages.
Question 5.
You work as the network administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003. All the client computers run Windows XP Professional and Microsoft Office XP. A ITCertKeys.com user named Mia Hamm is a member of the Research department. One morning Mia Hamm complains that the dictionary does not contain several industry-specific words that are used in her Microsoft Word document. Mia Hamm wants Microsoft Word to automatically recognize these words when they are spelled correctly, rather than highlighting them as misspelled words.
What should you do to ensure that Word does not highlight these industry-specific words are misspelled?
A. Right-click the Spelling & Grammar Status icon at the bottom of the Word window.
Select Options from the context menu. Then click the Check Document button.
B. Create a text file that contains the desired words. Open the Options dialog box. Then specify
the text file's location in the Tools path on the File Location tab.
C. Open the Options dialog box. Ensure that the Suggest from the main dictionary only check box
is selected on the Spelling & Grammar tab.
D. Open the Options dialog box. Create a custom dictionary. Then right-click the desired words in
a document and select Add to Dictionary from the context menu.
Answer: D
Explanation:
The question tests your knowledge of how Word handles words not found in its main dictionary. There is no way to know this other than to do it. The answer listed is the correct way to do this. Microsoft creates a custom.dic file for you when Word is installed. This is the custom dictionary file.
Incorrect Answers:
A: There is no such icon as "Spelling and Grammar Status." Even if there were, clicking Check
Document will only compare the words in the document against the main dictionary file. Since
the custom words did not appear in the main dictionary, they will still show up as misspelled.
B: There is no way to specify a custom dictionary from the File Location tab. This tab is for items
such as save location, template location, etc. Below is the File Location tab for Office 2003, but
office XP is exactly the same:
C: Ensuring that the Check from main dictionary only checkbox is checked is the exact opposite
of what needs to be done. If this box is checked, Word will never check for any documents
outside of the main dictionary, and the industry specific words will always be marked as
incorrect even if a custom dictionary is specified.
Question 6.
You work as the network administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003. All the client computers run Windows XP Professional and Microsoft Office XP. A ITCertKeys.com user named Kara Lang is a member of the Research department. Kara Lang complains that when she scrolls through a Microsoft Word document that contains graphics, the graphics display becomes corrupted.
What should you do first to ensure that the graphics do not appear corrupted when Kara Lang scrolls through Word documents?
A. Create a new user profile.
B. Reduce the Display settings to 256 colors.
C. Adjust the mouse pointer acceleration to a lower setting.
D. Adjust the hardware accelerator of the video adapter to a lower setting.
Answer: D
Explanation:
The settings are configured to rely too much on the processor on the graphics card which seems to be a little too weak for the current settings. Adjust graphics hardware acceleration by clicking Start, point to Settings, and then click Control Panel. Double-click Display. On the Settings tab, click Advanced. Click the Troubleshoot tab. Move the Hardware Acceleration slider two notches to the left of Full (the Disable all cursor and advanced drawing accelerations setting). Click OK, and then click OK again.
Question 7.
You work as the network administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003. All the client computers run Windows XP Professional and Microsoft Office XP. A ITCertKeys.com user named Rory Allen is a member of the Sales department. Rory Allen complains that Office applications display animated characters when he accesses Help. Rory Allen wants Office to permanently stop displaying the Help character.
What should you instruct Rory Allen do to configure Office so that the character is no longer displayed?
A. Right-click the character and select Hide.
B. Delete the Microsoft Agent DLL file located in the Windows System32 folder.
C. Select Hide the Office Assistant from the Help menu in each Office application.
D. Right-click the character and select Options from the context menu. Then clear the Use the
Office Assistant check box.
Answer: D
Explanation:
The Office Assistant is a feature included in Microsoft Office starting with Microsoft Office 97, and has been dubbed "Clippy" or "Clippit" after its default animated paperclip representation. However, Clippit is actually the default assistant's official name. Right-clicking on the character and selecting Hide will only remove the assistant temporarily. Manually removing .dll files from the system is never a good way to solve a problem as this could cause more problems. Selecting Hide the Office Assistant from the Help menu is the same action as right-clicking on the assistant and selecting Hide. Clearing the Use the Office Assistant from the Options menu when right-clicking the assistant is the correct way to permanently remove the Office Assistant.
Question 8.
You work as the network administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003. All the client computers run Windows XP Professional and Microsoft Office XP. A ITCertKeys.com user named Andy Booth is a member of the Research and Development department. One morning Andy Booth complains that he receives a document containing mechanical drawings for a new design, but the document will not open on his computer.
What should you do to ensure that Andy Booth can open the document?
A. Open the document by using the Windows Photo and Fax Viewer.
B. Open a new Microsoft Paint document. Drag the file into the paint document.
C. Open a new Microsoft Word document. Drag the file into the new Word document.
D. Download and install the Microsoft Visio Viewer from the Microsoft Office Download Center
Web Site.
Answer: D
Explanation:
.vsd files are created in Microsoft Visio. Microsoft offers free of charge a Microsoft Visio Viewer that allows anyone to view Visio drawings and diagrams inside their Microsoft Internet Explorer version 5.0 or later Web browser.
Question 9.
HOTSPOT
You work as a desktop technician at ITCertKeys.com. The ITCertKeys.com network contains a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server and all client computers run Windows XP Professional. ITCertKeys.com contains a Desktop Support team which you are part of. A ITCertKeys.com customer named Ally Wagner has contacted you. Ally Wagner has upgraded her computer from Microsoft Windows 98 to Microsoft Windows XP Professional. Ally Wagner has now a problem; she cannot run the accounting application that she used before the upgrade.
You tell Ally Wagner to run the application in Windows 98 mode, but she does not know how to implement the change. In the exhibit, what should Ally Wagner do?
Answer:
Explanation:
On the application Property dialog box, the Compatibility tab is used to select the operating mode.
Question 10.
You work as a desktop technician at ITCertKeys.com. The ITCertKeys.com network contains a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server and all client computers run Windows XP Professional. ITCertKeys.com contains a Desktop Support team which you are part of. A ITCertKeys.com customer named Kara Lang has contacted you. Kara Lang has upgraded her second computer from Microsoft Windows 98 to Microsoft Windows XP Home. She needs to use a financial application that does not run on Windows XP Home. On her other computer she used to configure the application to run on Windows XP in Windows 98 mode. Kara Lang cannot remember how to invoke the necessary tool.
What should you do?
A. Instruct Kara Lang to open Component Services.
B. Instruct Kara Lang to open Computer Management.
C. Instruct Kara Lang to open the executable's Properties dialog box.
D. Instruct Kara Lang to open the Upgrade Advisor.
Answer: C
Explanation:
The executable's Properties dialog box will allow Kara Lang to choose the operating system for the financing application to run.
Incorrect Answers:
A: The Component Services will allow the user to configure software component, not application compatibility settings.
B: The Computer Management will allow the user to configure device drivers, format hard drives etc.
D: The Upgrade Advisor is run before an upgrade.
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.