⟩ What is MCDBA
MCDBA stands for Microsoft Certified Database Administrator and this is a Microsoft certification exam
Question and Answer:
Home MCDBA Certification
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain The invoice creation process must be dynamically monitored to track the following information Average number of seconds to create an invoice Number of invoices created per second Total number of successfully created invoices Total number of failed attempts to create an invoiceMonitoring should occur with a minimum of development effort. What should you do?A. Write statistics to the database and use SQL Query Analyzer to dynamically monitor thestatisticsB. Create a removable Microsoft .NET class to contain statistics. Configure the class as singletonclass. Write a utility that retrieves statistical information from this classC. Write statistics to the application event logD. Use custom performance counters
Suppose You need to enable brokers to track their own shipment. To meet this requirement, you need toconsider various specifications. Which four specifications should you consider? (Each correctanswer presents part of the solution)A. Provide a Web-accessible form to authenticate brokers against a table of registered usersB. Provide a Web-accessible form to enable brokers to request vehicle routes for their shipmentsC. Provide a Web-accessible form to query the database for broker shipmentsD. Provide a Web-accessible form to generate waybill numbersE. Identify a parcel in the database as part of a broker shipmentF. Relate a parcel to a specific brokerG. Track the weight of a parcel in the database
Suppose You are creating the logical design for a use case named Customer updates customer profiles?.Which object or objects should you include in the design? (Choose all that apply)A. Data access objectB. Customer objectC. Flight objectD. Logging objectE. Airline object
Suppose You are writing a list of integration requirements for your solution. Which requirement orrequirements should you include? (Choose all that apply)A. Order data must be read from the accounting applicationB. Shipment tracking must be read from an XML Web serviceC. Customers must be redirected to another Web site to track shipmentsD. Customers must be able to place orders by using an XML Web serviceE. Order data must be written to the accounting applicationF. Order data must be e-mailed to the salespeopleAnswer A, B, E
Explain Which new business process or processes should be supported by the new solution?(Choose all that apply)A. Brokers can order transportation servicesB. Vehicle scheduling capability is providedC. Bar code readers are supportedD. Use of space on vehicles can be trackedE. Brokers can track shipmentsF. Customers can track parcelsAnswer A, D, E
Suppose You are completing the technical specification for the new reservation application.Which technique should you recommend for state management?A. ASP.NET ViewStateB. Server-side databaseC. Client-side cookiesD. Application cache
Suppose You are validating the physical design of a data a data layer class that will return a set of timeentries from the timesheet database. This class will be used by the Web application for TeamLeads and Business Planners and, indirectly, by the new timesheet application.The class must use connection pooling, and it must be as secure and as flexible as possible. Youneed to specify a Microsoft SQL Server authentication strategy that meets these requirements.Which strategy should you use?A. The data class uses SQL Server authentication with an application specific SQL Serveraccount. The account name and password are embedded in a connection stringB. The data class uses Windows authentication when connecting to the database andimpersonates a specific account created for operations on the databaseC. The data class uses Windows authentication when connecting to the database andimpersonates the application userD. The data class uses SQL Server authentication with the SQL Server sa accoun
Suppose You need to ensure that transportation brokers are authenticated when they access the brokerWeb site. Which action or actions should you take? (Choose all that apply)A. Create a distribution list of authenticated usersB. Provide a facility for online registrationC. Provide a facility to view passwordsD. Provide secure storage of user names and passwordsE. Secure the exchange of user names and passwords between the client computer and theserverF. Enable e-mail access for transportation brokersAnswer B, D, E
Before you release the solution, you need to develop a process to validate and enforce anappropriate level of quality. Which three statistics should you use?(Each correct answer presents part of the solution)A. Number of defects per componentB. Number of defects per thousand lines of source codeC. Number of defects by developerD. Percentage of successful buildsE. Percentage of requirements testedF. Number of defects detected to dateG. Number of defects corrected to date.
Explain Which new module or modules should you develop for Trey Research? (Choose all that apply.)A. An application to export laboratory resultsB. A data storeC. A Web application for trucking supervisorsD. An automated report generatorE. An application to import laboratory reportsF. An OCR interfaceG. An IVR application
