You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? ()A、Ensure that the source database is Microsoft SQL Server.B、Ensure that the destination database is Microsoft SQL Server.C、Ensure that the column names in the source table match the column names in the destination table.D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.

You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? ()

  • A、Ensure that the source database is Microsoft SQL Server.
  • B、Ensure that the destination database is Microsoft SQL Server.
  • C、Ensure that the column names in the source table match the column names in the destination table.
  • D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.

相关考题:

You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do?() A. Ensure that the source database is Microsoft SQL Server.B. Ensure that the destination database is Microsoft SQL Server.C. Ensure that the column names in the source table match the column names in the destination table.D. Ensure that the bulk copy program (bcp) utility is installed on the destination server.

You need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center. What should you do?()A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process,each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus,referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do?()A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the LINQ ParallelEnumerable. AsParallel method to perform multiple queries on a database. You need to ensure that queries can execute on separate threads concurrently. What should you do? ()A、Use the AsOrdered method.B、Use the SelectMany method.C、Use the AutoBuffered option in the WithMergeOptions method.D、Use the WithExecutionMode method with the ParallelExecutionMode.ForceParallelism parameter.

You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?()A、Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.B、Ensure that the stored procedure and the tables are owned by the same database user.C、Ensure that the stored procedure and the tables use the same database schema.D、Configure the multiuser database option on both databases.E、Configure the cross-database ownership chaining option on both databases.

You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?()A、Ensure that port 1433 is open in your firewall. B、Ensure that port 443 is open in your firewall. C、Ensure that client computers connect by using Shared Memory protocol. D、Ensure that the server is not paused.

You are creating a templated Web control for use in your Web application. You need to add the Web control to your Web application pages without compiling your control into a .dll file. What should you do?()A、Ensure that the Web control inherits from the WebControl class.B、Ensure that the Web control inherits from the Control class.C、Ensure that the Web control inherits from the CompositeControl class.D、Ensure that the Web control inherits from the UserControl class.

You develop an ASP.NET Web page that includes multiple WebPartZone controls, an EditorZone. Users report that they cannot customize the layout of the page by moving WebParts from one.You need to ensure that users can successfully move Web Parts from one zone to another. What should you do?()A、Configure the Web site to enable session state.B、Configure the Web site to require authentication and to use personalization.C、Add a ProxyWebPartManager control to the page.D、Add a AppearanceEditorPart control to the page.

You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend?()A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding, the Session objects are not lost.  What should you do?()A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm.

You work as an application developer at Certkiller .com. Certkiller .com has been contracted to develop an application for the local bank.You have been given the responsibility of creating this application and need to store each transaction record, which is identified using a complex transaction identifier,in memory. The bank informs you that the total amount of transaction records could reach 200 per day. To achieve this, you decide to utilize one of the existing collection classes in the .NET 2.0 class library. You need to ensure that you the collection class you select is the most efficient one for storing transaction records.What should you do?()A、 Select the ListDictionary collection class.B、 Select the HashTable collection class.C、 Select the Queue collection class.D、 Select the StringCollection collection class.

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The Contoso.com network contains a Microsoft SQL Server 2005 server named DB01. Your application retrieve records from a  database named Trades that resides on DB01. The application connects to Trades by using an instance of the SqlConnection class with the following connection string.   "Data Source=DB01;UID=’mhamm’;PWD=’password’;"   When the application calls the Open method of the SqlConnection object, it displays the following: "Cannot open user default database. Login failed. Login failed for user ’mhamm’".  You need to make sure that you can connect to Trades when the user account for the connection is mhamm.   What should you do? ()A、 Change the connection string as follows:Data Source=DB01;Initial Catalog=Trades;UID=mhamm; PWD=password;"B、 Create a login for Mia Hamm on DB01.C、 Create a database user object in Trades and map the object to the SQL Server 2005 Login of Mia Hamm.D、 Change the connection string as follows:"Server=DB01;Database=Trades;UID=mhamm;PWD=password;"

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application must redirect the original URL to a different ASPX page.  You need to ensure that the users cannot view the original URL after the page is executed. You also need to ensure that each page execution requires only one request from the client browser. What should you do?()A、Use the Server.Transfer method to transfer execution to the correct ASPX page.B、Use the Response.Redirect method to transfer execution to the correct ASPX page.C、Use the HttpContext.Current.RewritePath method to transfer execution to the correct ASPX page.D、Add the Location: new URL value to the Response.Headers collection. Call the Response.End() statement. Send the header to the client computer to transfer execution to the correct ASPX page.

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You create a custom control named Wheel. You need to ensure that the Speed property of Wheel can be animated. What should you do?()A、Inherit the DependencyObject class.B、Declare the Speed property as a dependency property.C、Declare an animation of the Speed property from within the code-behind file.D、Implement the System.Windows.Media.Animation.IAnimatable interface with the Wheel class.

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? () A、You should use the Database Engine Tuning Advisor tool B、You should use the Windows System Monitor tool C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? () A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. B、You should identify whether the SQL Server Agent is started on the primary server. C、You should identify whether the AdventureWorks database uses the Simple recovery model. D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases.  The SQL Azure database contains many tables that have circular foreign key relationships.  You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database.  What should you recommend?()A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.

ou work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?()A、You should use the http.sys listener to install the SSRS instance. B、You should configure the SSRS database, make it use Native mode C、You should configure the SSRS database, make it use SharePoint integrated mode D、You should use the Internet Information Services default Web site to install the SSRS instance

You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend?()A、 Remove all clustered indexes from the database.B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator (MSDTC) from the application.C、 Use SSL and SQL authentication to connect to the database.D、 Use SSL and Windows authentication to connect to the database.

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Web page to display photos and captions. The caption of each photo in the database can be modified by using the application. You write the following code fragment:         ’ runat="server"/             ’ runat="server" /             When you access the Web page, the application throws an error.  You need to ensure that the application successfully updates each caption and stores it in the database.  What should you do?()A、Add the ID attribute to the Label control. B、Add the ID attribute to the TextBox control. C、Use the Bind function for the Label control instead of the Eval function. D、Use the Eval function for the TextBox control instead of the Bind function.

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? ()A、ServiceGreatUser should be added to the appropriate fixed database roles. B、You should assign the appropriate object-level permissions to ServiceGreatUser C、You should assign the appropriate server-level permissions to ServiceGreatLogin D、You should assign the appropriate database-level permissions to ServiceGreatUser

You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication.  You decide to make use of Microsoft ASP.NET 3.5 in order to create the application. The followingmarkup is present on the page:      " ="" selectcommand="GetUsers" selectcommandtype="StoredProcedure" filterexpression="Active=1 AND Name LIKE ’{0}%’">            The page is used to retrieve the Users from a company database. However, only the active usersare displayed. The TextBox control allows you to also filter users by status. You do not specify astatus when you click the Filter button. You notice that the page does not filter by active users andshows all the users that are retrieved from the database. You need to make the necessary settingsto ensure that only the active users are being displayed on the page when a status is notspecified.  What should you do?()A、You should ensure that a default value for the Status property of the ControlParameter controlis set.B、You should ensure that the PropertyName property of the ControlParameter control is set toText.C、You should ensure that the ControlParameter control’s ConvertEmptyStringToNull property isset to false.D、You should ensure that the {0} placeholder in the FilterExpression property is replaced with the(?) symbol.

单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend?()A Use the bcp utility.B Use the dta utility.C Use the SQL Server Import and Export Wizard.D Attach each SQL Server database to SQL Azure.

单选题You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the LINQ ParallelEnumerable. AsParallel method to perform multiple queries on a database. You need to ensure that queries can execute on separate threads concurrently. What should you do? ()AUse the AsOrdered method.BUse the SelectMany method.CUse the AutoBuffered option in the WithMergeOptions method.DUse the WithExecutionMode method with the ParallelExecutionMode.ForceParallelism parameter.

单选题You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication.  You decide to make use of Microsoft ASP.NET 3.5 in order to create the application. The followingmarkup is present on the page:      "  SelectCommand="GetUsers" SelectCommandType="StoredProcedure"  FilterExpression="Active=1 AND Name LIKE ’{0}%’"            The page is used to retrieve the Users from a company database. However, only the active usersare displayed. The TextBox control allows you to also filter users by status. You do not specify astatus when you click the Filter button. You notice that the page does not filter by active users andshows all the users that are retrieved from the database. You need to make the necessary settingsto ensure that only the active users are being displayed on the page when a status is notspecified.  What should you do?()AYou should ensure that a default value for the Status property of the ControlParameter controlis set.BYou should ensure that the PropertyName property of the ControlParameter control is set toText.CYou should ensure that the ControlParameter control’s ConvertEmptyStringToNull property isset to false.DYou should ensure that the {0} placeholder in the FilterExpression property is replaced with the(?) symbol.

单选题You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? ()AEnsure that the source database is Microsoft SQL Server.BEnsure that the destination database is Microsoft SQL Server.CEnsure that the column names in the source table match the column names in the destination table.DEnsure that the bulk copy program (bcp) utility is installed on the destination server.

单选题ou work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?()AYou should use the http.sys listener to install the SSRS instance. BYou should configure the SSRS database, make it use Native mode CYou should configure the SSRS database, make it use SharePoint integrated mode DYou should use the Internet Information Services default Web site to install the SSRS instance