单选题You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?()Aone that uses an internal SQL Server Web service endpointBone that runs a SQL Server Integration Services (SSIS) packageCone that uses Service BrokerDone that runs a user-defined function

单选题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?()
A

one that uses an internal SQL Server Web service endpoint

B

one that runs a SQL Server Integration Services (SSIS) package

C

one that uses Service Broker

D

one that runs a user-defined function


参考解析

解析: 暂无解析

相关考题:

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 work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  You host the Web application in Microsoft Internet Information Services (IIS) 6.0. You browse theapplication and receive the following error message:  Server Application Unavailable  The web application you are attempting to access on this web server is currently unavailable.Please hit the "Refresh" button in your web browser to retry your request.  You view the Application event log and discover the following message:  It is not possible to run two different versions of ASP.NET in the same IIS process. Please use theIIS Administration Tool to reconfigure your server to run the application in a separate process.  To ensure productivity you need to solve this problem as quick as possible.  What should you do?()A、You should change the IIS isolation mode.B、You should assign the application to another application pool.C、You should configure all applications that are part of your application's application pool in orderto use the same version of ASP.NET.D、You should run the Aspnet_regiis.exe Tool.E、You should restart the application pool that hosts the application.

You are designing a plan to migrate an existing application to Windows Azure.  The application currently resides on a server that has 768 MB of memory and multiple cores. You need to recommend the smallest compute instance size that is equivalent to the existing server.  Which size should you recommend?()A、 SmallB、 MediumC、 LargeD、 ExtraSmall

You are designing a Windows Azure application.   Corporate policy dictates that you must retain all application logs.   You need to recommend an approach for complying with the corporate policy.  What should you recommend?()A、 Perform on-demand transfers.B、 Configure scheduled transfers.C、 Configure a diagnostic trace listener.D、 Increase the diagnostics buffer quotas.

You are designing a Windows Azure application.   The application contains one web role and three worker roles.  You need to recommend an approach for updating only one role without interrupting the other roles.   What should you recommend?()A、 Perform a VIP swap.B、 Perform an in-place upgrade.C、 Delete the current deployment and then redeploy the application.D、 Copy the cloud package to blob storage and then restart the service.

You are designing a Windows Azure application.  The application includes a web role and a worker role that communicate by using a Windows Azure Queue.  The worker role processes each message within 10 seconds of retrieving it from the queue. The worker role must process each message exactly one time.  If a process does not complete, the worker role must reprocess the message.  You need to recommend an approach for the worker role to manage messages in the queue.  What should you recommend?()A、 Process the message and then delete it from the queue.B、 Delete the message from the queue when retrieving the message.C、 Set the visibility timeout of the message to 1 when retrieving the message.D、 Process the message and then set the visibility timeout of themessage to the maximum value.

You are designing an integration test plan for a Windows Azure .NET 3.5 application.   You need to recommend a testing environment that allows developers to debug the application while accessing data in the cloud.  What should you recommend?()A、 Run the application on Windows Azure.  Use the development storage account.B、 Run the application on Windows Azure.  Use a Windows Azure Storage account.C、 Run the application in the development fabric.  Use the development storage account.D、 Run the application in the development fabric.  Use a Windows Azure Storage account

You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 20 GB of hard disk space.  You need to recommend the smallest compute instance size that provides local storage equivalent to that of the existing server.  Which size should you recommend?()A、 ExtraSmallB、 ExtraLargeC、 SmallD、 Large

You are designing a Windows Azure web application.   The application will be accessible at a standard cloudapp.net URL.  You need to recommend a DNS resource record type that will allow you to configure access to the application through a custom domain name.  Which type should you recommend?()A、 AB、 CNAMEC、 MXD、 SRV

You are a network administrator of your network. You want to install Windows 2000 professional on 100 computers from a central location. You want to copy a customized application with theinstallation process to all the 100 computers.  What should you do to copy that application during the installation process to the computers.()A、 It cannot be done.B、 Copy the application to the temp folder of the distribution server.C、 Create a folder named $OEM$ as a sub folder in the distribution folder of  source files.D、 Create a folder named $COPYDIR$ as a sub folder in the distribution folder of source files.

You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?()A、one that uses an internal SQL Server Web service endpointB、one that runs a SQL Server Integration Services (SSIS) packageC、one that uses Service BrokerD、one that runs a user-defined function

You are designing a strategy to install the new scheduling application. Which two actions should you perform?()A、Assign the scheduling application package to the Instructor OU.B、Publish the scheduling application package to the Instructor OU.C、Ensure that the scheduling application can install across slow WAN links.D、Prevent the scheduling application from installing across slow WAN links.

You are designing an automated deployment process for a Windows Azure application.   The process must deploy the application to Windows Azure without any user interaction. You need to recommend a deployment strategy.  What should you recommend?()A、 Use the Service Management API to deploy the application package.B、 Use the cspack and csrun command-line utilities and pass the cloud project as an argument.C、 Publish the cloud project to a local directory and upload the application package to Windows Azure Blob storage.D、 Publish the cloud project to a localdirectory and use the Windows Azure Developer Portal to upload the application.

单选题You work as an application developer at Certkiller .com. You have recently created an application that includes the code shown below. public delegate stringGetFileContentsDel (); public string GetFileContents () {  //Process file and return results }  You now need to invoke the GetFileContents method asynchronously.  You have to ensure that the code you use to invoke the GetFileContents method will continue to process other user instructions, and displays the results as soon as the GetFileContents method finishes processing.What should you do?()A AB BC CD D

单选题You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 20 GB of hard disk space.  You need to recommend the smallest compute instance size that provides local storage equivalent to that of the existing server.  Which size should you recommend?()A ExtraSmallB ExtraLargeC SmallD Large

单选题You are creating a Windows Forms application by using the .Net Framework 3.5.You create an instance of a Backgroundworker component named backgroundWorker1 to process operations that take a long time.You discover that when the application attempts to report the progress,you receive a System.InvalidOperationException exception when executing  thebackgroundWorker1.ReportProgress method.You need to configure the BackgroundWorker component appropriately to prevent the application from generating exceptions.    What should yo do?()ASet the Result property of the DoWorkEventArgs instance to True before you attempt to report the progress.BSet the CancellationPending property of backgroundWorker1 to True before you attempt to report the background processCSet the WorkerReportsProgress property of backgroundWorker1 to True before you attempt to report the background process.DReport the progress of the background process in the backgroundWorker1_ProgressChanged event.

单选题You are designing a Windows Azure application.   Corporate policy dictates that you must retain all application logs.   You need to recommend an approach for complying with the corporate policy.  What should you recommend?()A Perform on-demand transfers.B Configure scheduled transfers.C Configure a diagnostic trace listener.D Increase the diagnostics buffer quotas.

单选题You are designing a Windows Azure web application.   The application will be accessible at a standard cloudapp.net URL.  You need to recommend a DNS resource record type that will allow you to configure access to the application through a custom domain name.  Which type should you recommend?()A AB CNAMEC MXD SRV

单选题You are designing an automated deployment process for a Windows Azure application.   The process must deploy the application to Windows Azure without any user interaction. You need to recommend a deployment strategy.  What should you recommend?()A Use the Service Management API to deploy the application package.B Use the cspack and csrun command-line utilities and pass the cloud project as an argument.C Publish the cloud project to a local directory and upload the application package to Windows Azure Blob storage.D Publish the cloud project to a localdirectory and use the Windows Azure Developer Portal to upload the application.

单选题You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.  You host the application on a server named ContosoTest that runs Microsoft IIS 6.0. You set up remote debugging on the ContosoTest server.  You need to debug the application remotely from another computer named ContosoDev. What should you do? ()AAttach Microsoft Visual Studio.NET to the w3wp.exe process.BAttach Microsoft Visual Studio.NET to the inetinfo.exe process.CAttach Microsoft Visual Studio.NET to the Msvsmon.exe process.DAttach Microsoft Visual Studio.NET to the WebDev.WebServer.exe process.

多选题You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5.  You deploy the application on a Microsoft IIS 6.0 Web server. The server runs on a worker process isolation mode, and it hosts the .NET Framework version 1.1 Web applications. When you attempt to browse the application, the following error message is received:  "It is not possible to run different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process."    You need to ensure that the following requirements are met: all the applications run on the server  all the applications remain in process isolation mode all the applications do not change their configuration.   Which two actions should you perform?()ACreate a new application pool and add the new application to the pool.BConfigure the IIS 6.0 to run the WWW service in the IIS 5.0 isolation mode.CConfigure the new application to use the .NET Framework version 2.0 in the IIS 6.0 Manager.DSet autoConfig=false on the processModel property in the machine.config file.EDisable the Recycle worker processes option in the Application Pool Properties dialog box.

单选题You are a network administrator of your network. You want to install Windows 2000 professional on 100 computers from a central location. You want to copy a customized application with theinstallation process to all the 100 computers.  What should you do to copy that application during the installation process to the computers.()A It cannot be done.B Copy the application to the temp folder of the distribution server.C Create a folder named $OEM$ as a sub folder in the distribution folder of  source files.D Create a folder named $COPYDIR$ as a sub folder in the distribution folder of source files.

多选题You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  You host the Web application in Microsoft Internet Information Services (IIS) 6.0. You browse theapplication and receive the following error message:  Server Application Unavailable  The web application you are attempting to access on this web server is currently unavailable.Please hit the "Refresh" button in your web browser to retry your request.  You view the Application event log and discover the following message:  It is not possible to run two different versions of ASP.NET in the same IIS process. Please use theIIS Administration Tool to reconfigure your server to run the application in a separate process.  To ensure productivity you need to solve this problem as quick as possible.  What should you do?()AYou should change the IIS isolation mode.BYou should assign the application to another application pool.CYou should configure all applications that are part of your application's application pool in orderto use the same version of ASP.NET.DYou should run the Aspnet_regiis.exe Tool.EYou should restart the application pool that hosts the application.

单选题You are designing a strategy to enable the ATC application to successfully resolve computer names. Which name resolution method should you use?()ADNSBWINSCHosts fileDLmhosts file

单选题You are designing a strategy to enable the ATC application to successfully resolve computer names.  Which name resolution method should you use?()A DNSB WINSC Hosts fileD Lmhosts file

单选题You are designing a Windows Azure application.  Messages will be placed into a Windows Azure Queue and then processed by a worker role.  There is no requirement for adherence to the Windows Azure Service Level Agreement (SLA).   You need to recommend an approach for concurrently processing messages while minimizing compute cost.  What should you recommend?()A A single role instance that processes messages individuallyB A single role instance with multithreaded request processingC Multiple role instances that process messages individuallyD Multiple role instances, each with multithreaded request processing