MTA Practice Exam.docx

How should you configure an application to consume a web service? - correct answer A) add the web service to the development computer B) add a reference to the web service in the application * C) add a reference to the application in the web service D) add the web service code to the application You are writing a web application that processes room reservation requests. You need to verify that the room that a guest has selected is not already reserved by another guest. Which type of programming should you use to determine whether the room is still available when the request is made? - correct answer A) functional B) dynamic C) in-browser D) server-side* A data warehouse database is designed to: - correct answer A) Enable business decisions by collecting, consolidating, and organizing data* Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System? - correct answer SQL. SQL is a special-purpose programming language designed for managing data held in relational database management systems This question requires that you evaluate the underlined text to determine if it is correct. Converting a value type to a reference type in an object is called boxing. Select the correct answer if the underlined text makes the statement correct. Select "no change needed" if the underlined text makes the statement correct. - correct answer No change needed. Boxing is an implicit conversion of a Value Types (C# reference) to the type object or to any interface type implied by this value type. A queue's items are stored in the order they were added: A queue is a first-in, first-out (FIFO) data structure A queue has a limited number of items. - correct answer True True False You plan to create an application for your company. The application will run automated routines and write the results to a text-based log file. Little or no user interaction is required. Security requirements on the host computers prevent you from running applications on startup, and users must be able to see the status easily on the screen. The host computers also have limited memory and monitors that display only two colors. These computers will have no network connectivity. Which type of application should you use for this environment? - correct answer console-based You have a Windows Service running in the context of an account that acts as a non-privileged user on the local computer. The account presents anonymous credentials to any remote server. What is the security context of the Windows Service? - correct answer LocalService. Which runs in the context of an account that acts as a non-privileged user on the local computer and presents anonymous credentials to any remote server The purpose of the Finally section in an exception handler is to: - correct answer Execute code regardless of whether an exception is thrown. Which are three valid SQL keywords? (Choose three) - correct answer FROM, SELECT, WHERE example: SELECT * FROM customers WHERE country = Mexico