单选题You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）ACreate a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.BCreate a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’CCreate a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）DCreate services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
单选题
You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）
A
Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
B
Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
C
Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
D
Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
参考解析
解析：
暂无解析
相关考题：
Exhibit: You are developing a Web application. The Web application uses a GridView control to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do?（）A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.B. Click the Change button, and change the data provider for the selected data source.C. Click the Advanced button, and change the Data Source property to the target provider.D. Click the Advanced button, and change the Application Name property to the target provider.
You install a custom application on a computer that runs Microsoft Windows XP. The application stores each user’s data in the %programfiles%\app1\data folder on the computer. You install the custom application on a computer that runs Windows Vista.On the Windows Vista computer, you back up the %programfiles%\app1\data folder and notice that the backup contains no data.You need to back up the application’s user data on the Windows Vista computer.What should you do?（）A.AB.BC.CD.D
Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App-V).You are creating an application virtualization package.Which should you use?（）A.Microsoft Application Virtualization SequencerB.Microsoft Application Virtualization Desktop ClientC.Microsoft System Center Application Virtualization Streaming ServerD.Microsoft System Center Application Virtualization Management Server
You work as an application developer at Certkiller .com. You are currently in the process of creating a new application for Certkiller .com. You are required to read compressed data files that has been sent by Certkiller .com‘s sales offices.These data files are less than 4 GB in size, but was compressed without cyclic redundancy. You want to write a method that receives the compressed files and return the uncompressed data as a byte array.What should you do?（）A.B.C.D.
You are in the process of creating a new application.This new application has to be able to read all data from a text file.What should you do?() A.B.C.D.
You are currently in the process of creating an application that reads binary information from a file.You need to ensure that the only the first kilobyte of data is retrieved.What should you do?() A.B.C.D.
You have recently completely creating a new application for Certkiller .com.This new application has to load an instance of the Inventory class from a large file named Inventory.dat.You need to ensure that the application executes the loading process in as little time as possible.What should you do?（）A.B.C.D.
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
You work as an application developer at Certkiller .com. You are in the process of creating an application for Certkiller .com’s Human Resources department that tracks employee benefits. You have to store current employee data without recompiling the application. You elect to store this employee data as a custom section in the application configuration file. The relevant portion of the application configuration file is shown in the following exhibit： ？xml version="1.0" encoding="utf-8" ？ You want to use the .NET 2.0 Configuration API to access the custom section. You need to ensure that programmatic access of the EmployeeSection element is enabled. What should you do？（）A、 Create a custom section handler class that inherits the ConfigurationSection interface.B、 Add a section element to the EmployeeSection element of the application configuration file.C、 Create a custom section handler class that implements the IConfigurationSectionHandler interface.D、 Add an EmployeeSection element to the configSections element of the application configuration file.E、 Create a custom section handler class that implements the IApplicatioSettingsProvider interface.F、 Add a section element to the configSections element of the application configuration file.
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
You perform a security audit of a server named DC1. You install the Microsoft Network Monitor 3.0 application on DC1. You plan to capture all the LDAP traffic that comes to and goes from the server between 20：00 and 07：00 the next day and save it to the e：/data.cap file. You create a scheduled task. You add a new Start a program action to the task. You need to add the application name and the application arguments to the new action. What should you do？（） A、 Add nmcap.exe as the application name. Add the /networks * /capture LDAP /file e：/data.cap / stopwhen /timeafter 11hours line as argumentsB、 Add netmon.exe as the application name. Add the /networks */capture LDA /file e：/data.cap /stopwhen / T.imeafter 11hours line as argumentsC、 Add nmcap.exe as the application name. Add the /networks * /capture !LDAP /file e：/data.cap /stopwhen /timeafter 11hours line as argumentsD、 Add nmconfig.exe as the application name. Add the /networks */capture LDAP /file e：/data.cap / stopwhen /timeafter 11hours line as arguments
You have a Web application that is configured for personalization. You need to access personalization data from one of the pages of the Web application by using the minimum amount of administrative effort. What should you do? （）A、Access the personalization data from the Session property of the HttpContext object.B、Access the personalization data from the Application property of the HttpContext object.C、Access the personalization data from the Cache property of the HttpContext object.D、Access the personalization data from the Profile property of the HttpContext object.
You run a 16-bit scientific data analysis package on your Windows 2000 Professional computer. Thepackage consists of three components.The first component is a data acquisition application that monitors continuous data output fromscientific instruments. The second component is a data analysis application that receives data from thedata acquisition application by using shared memory. The third component is a data graphingapplication that displays the processed data in real time.The data analysis application communicates with the data graphing application by using OLE. When youattempt to analyze large data sets, your computer is not able to display data in real time. You install asecond processor in your computer. Only one processor is used while the package is running, even thoughtask manager shows both processors.You want your data analysis package to use both processors. What should you do?（）A、Configure the data acquisition application to run in its own virtual DOS machine (VDM). B、Configure the data analysis application to run in its own virtual DOS machine (VDM). C、Configure the data graphing application to run in its own virtual DOS machine (VDM). D、Configure the virtual DOS machine for the data acquisition and data analysis applications to have a hard affinity for processor 0. Configure the VDM for the data graphing application to have a hard affinity for processor1. E、Configure the virtual DOS machine for the data acquisition to have a hard affinity for processor 0.Configure the VDM for the data graphing application to have a hard affinity for processor1.
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you. A database is utilized by the instance, and the database is utilized by a Web-based application. 15,000 transactions are processed by the application every minute. A column is contained by a table in the database, and the column is utilized only by the application. Sensitive data is stored in this column. The sensitive data should be stored with the highest security level. In addition, the least amount of memory space and processor time should be utilized. From the following four encryption types, which one should you utilize?（）A、Asymmetric key encryption should be utilized.B、Certificate-based encryption should be utilized.C、Symmetric key encryption should be utilized.D、Transparent data encryption should be utilized.
Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App - V). You are creating an application virtualization package. Which sh ould you use?（）A、Microsoft Application Virtualization SequencerB、Microsoft Application Virtualization Desktop ClientC、Microsoft System Center Application Virtualization Streaming ServerD、Microsoft System Center Application Virtualization Management Server
You are creating a Windows Forms application by using the .NET Framework 3.5 The application is used by a financial service provider.You discover that the service provider transfers large amounts of data by using XML.You need to read and validate the XMLdocuments in the most time efficient manner.Which technology should you use？（）A、The XmlReader classB、The XmlDocument classC、The XmlResolver classD、The LINQ to XML method
You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You use the ClickOnce deployment methodology to distribute the application. You need to store application-specific data along with read/write permissions without requiring elevated permissions for the application. Where should you store the application data?（）A、In isolated storage.B、On the database server.C、In the ClickOnce data directory.D、In the App.config file of the application.
You work as an application developer at Cer-Tech.com.You are in the process of creating an application for Cert-Tech.com’s Human Resources department that tracks employee benefits You have to store current employee data without recompiling the application. You elect to store this employee data as a custom section in the application configuration file. The relevant portion of the application configuration file is shown in the following exhibit： What should you do？（）A、 Create a custom section handler class that inherits the ConfigurationSection interfaceB、 Add a section element to the EmployeeSection element of the application configuration fileC、 Create a custom section handler class that implements the IConfigurationSectionHandler interface.D、 Add an EmployeeSection element to the configSections element of the application confguration fileE、 Create a custom section handler class that implements the IApplicationSettingsProvider interfaceF、 Add a section element to the configSections element of the application configuration file
多选题You work as an application developer at Certkiller .com. You are in the process of creating an application for Certkiller .com’s Human Resources department that tracks employee benefits. You have to store current employee data without recompiling the application. You elect to store this employee data as a custom section in the application configuration file. The relevant portion of the application configuration file is shown in the following exhibit： You want to use the .NET 2.0 Configuration API to access the custom section. You need to ensure that programmatic access of the EmployeeSection element is enabled. What should you do？（）ACreate a custom section handler class that inherits the ConfigurationSection interface.BAdd a section element to the EmployeeSection element of the application configuration file.CCreate a custom section handler class that implements the IConfigurationSectionHandler interface.DAdd an EmployeeSection element to the configSections element of the application configuration file.ECreate a custom section handler class that implements the IApplicatioSettingsProvider interface.FAdd a section element to the configSections element of the application configuration file.
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）Ause automatic extent allocationBdisable threshold for the tablespaceCuse freelists to manage the free spaceDuse automatic segment space managementEcreate the tablespace as a bigfile tablespaceFuse the RESIZE clause while creating the tablespaceGenable AUTOEXTEND for at least one of the data files in the tablespace
单选题You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You use the ClickOnce deployment methodology to distribute the application. You need to store application-specific data along with read/write permissions without requiring elevated permissions for the application. Where should you store the application data?（）AIn isolated storage.BOn the database server.CIn the ClickOnce data directory.DIn the App.config file of the application.
单选题You are creating a Windows Forms application by using the .NET Framework 3.5 The application is used by a financial service provider.You discover that the service provider transfers large amounts of data by using XML.You need to read and validate the XMLdocuments in the most time efficient manner.Which technology should you use？（）AThe XmlReader classBThe XmlDocument classCThe XmlResolver classDThe LINQ to XML method
多选题You run a 16-bit scientific data analysis package on your Windows 2000 Professional computer. The package consists of three components. The first component is a data acquisition application that monitors continuous data output from scientific instruments. The second component is a data analysis application that receives data from the data acquisition application by using shared memory. The third component is a data graphing application that displays the processed data in real time. The data analysis application communicates with the data graphing application by using OLE. When you attempt to analyze large data sets, your computer is not able to display data in real time. You install a second processor in your computer; only one processor is used while the package is running, even though task manager shows both processors. You want your data analysis package to use both processors. What should you do?（）AConfigure the data acquisition application to run in its own virtual DOS machine (VDM).BConfigure the data analysis application to run in its own virtual DOS machine (VDM).CConfigure the data graphing application to run in its own virtual DOS machine (VDM).DConfigure the virtual DOS machine for the data acquisition and data analysis applications to.have a hard affinity for processor 0. Configure the VDM for the data graphing application to.have a hard affinity for processor1.EConfigure the virtual DOS machine for the data acquisition to have a hard affinity for processor 0. Configure the VDM for the data graphing application to have a hard affinity for processor1.
单选题You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear. You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）AAdd an XML index to the table that contains the product data.BAdd the XSINIL argument to the ELEMENTS directive in the query.CAdd a HAVING clause to the query.DAdd the replace value of clause to the query.
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）AImplement parameterized Transact-SQL queries in the application.BImplement Transact-SQL stored procedures in the database.CImplement CLR stored procedures in the database.DImplement distributed Web services.
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）A Implement parameterized Transact-SQL queries in the application. B Implement Transact-SQL stored procedures in the database. C Implement CLR stored procedures in the database. D Implement distributed Web services.
单选题You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?（）ASymmetric key encryptionBAsymmetric key encryptionCCertificate-based encryptionDTransparent data encryption