单选题You need to ensure that old data and current data can be queried according to the business requirements. What should you do?()ASpecify a view based on the archival data table and current data tables.BSpecify that the data must be queried by using a stored procedure.CSpecify that both the archival data table and the current data tables must have indexes created on the same columns.DSpecify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

单选题
You need to ensure that old data and current data can be queried according to the business requirements. What should you do?()
A

Specify a view based on the archival data table and current data tables.

B

Specify that the data must be queried by using a stored procedure.

C

Specify that both the archival data table and the current data tables must have indexes created on the same columns.

D

Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.


参考解析

解析: 暂无解析

相关考题:

Certkiller.com has given you the task of serializing an object and writing it to a data file using binary serialization.You need to ensure that you meet these requirements.What should you do?() A.B.C.D.

You delete content from a file named Speed.doc that is stored in the C:\Data folder. You edit 20 files in this folder over the next two days. You need to restore the version of the file that had the correct data. You also need to ensure that the other fiels in the folder remain unaffected.What should you do?()A.AB.BC.CD.D

You need to ensure that you can recover system configuration and data if your computer hard disk fails.What should you do?() A.AB.BC.CD.D

You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.What should you do?()A.AB.BC.CD.D

You are the network administrator for Active Directory.Another system administrator installs Software Update Services (SUS) on a production Windows Server 2003 computer. You are assigned to manage the SUS computer. You need to ensure that you can recover SUS if the server fails.You need to back up all components that are required to restore SUS to its current configuration. Because of limited space, you must not back up unnecessary data.What action or actions should you perform? Select all that apply.()A. Back up the SUS folder that contains synchronized content.B. Back up the folder in which the SYSAdmin site was created.C. Back up the System State data fro the Windows Server 2003 computer.D. Back up the IIS metabase

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 are the network administrator for Active Directory. Another system administrator installs Software Update Services (SUS) on a production Windows Server 2003 computer. You are assigned to manage the SUS computer. You need to ensure that you can recover SUS if the server fails. You need to back up all components that are required to restore SUS to its current configuration. Because of limited space, you must not back up unnecessary data. What action or actions should you perform? Select all that apply.()A、Back up the SUS folder that contains synchronized content.B、Back up the folder in which the SYSAdmin site was created.C、Back up the System State data fro the Windows Server 2003 computer.D、Back up the IIS metabase

Which two statements are true regarding the usage of the SQL*Loader utility()A、You can load data into multiple tables during the same load session.B、You can load data from multiple files to a table during the same load session.C、You cannot perform selective data loading based on the values available in the records.D、You can use an export file generated by the EXPDP utility as an input data file to load the data.E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

You have a computer that runs Windows 7. The computer is a member of a domain. You share D:/data asData. You assign Everyone Full control share permissions to the folder. No other share permissions areassigned to the folder. From another computer, you attempt to create a file in the Data share by using a domain account named User1. You receive the following error message: Destination Folder Access Denied.You need to ensure that you can create files in the Data share by using the User1 account.  What should you do?()A、Create a local user named User1.B、Add User1 to the local Power Users group.C、Assign User1 Write NTFS permission on the D:///data folder.D、Assign User1 Full control share permissions to the Data share.

You are implementing an ASP.NET MVC 2 Web application that allows users to view and edit data. You need to ensure that only logged-in users can access the Edit action of the controller. What are two possible attributes that you can add to the Edit action to achieve this goal? ()A、[Authorize(Users = "")]B、[Authorize(Roles = "")]C、[Authorize(Users = "*")]D、[Authorize(Roles = "*")]

You design a Business Intelligence (BI) solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services (SSRS) solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met: Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform?()A、 Filter data by using expressions.B、 Specify the default values for each parameter.C、 Create an available values list for each parameter.D、 Create report parameters by using query parameters to filter data at the data source.

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 are creating an undo buffer that stores data modifications.You need to ensure that the undo functionality undoes the most recent data modifications first.You also need to ensure that the undo buffer permits the storage of strings only.Which code segment should you use?()A、Stackstring undoBuffer=new Stackstring();B、Stack undoBuffer=new Stack();C、Queuestring undoBuffer=new Queuestring();D、Queue undoBuffer=new Queue();

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application has multiple data entry windows. Each window contains controls that allow the user to type different addresses for shipping and mailing. All addresses have the same format. You need to ensure that you can reuse the controls. What should you create?()A、a user controlB、a data templateC、a control templateD、a control that inherits the Canvas class

You use Microsoft Visual Studio 2010 and Microsoft . NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You create a WPF window in the application. You add the following code segment to the application. public class ViewModel { public CollectionView Data { get; set; } } public class BusinessObject { public string Name { get; set; } } The DataContext property of the window is set to an instance of the ViewModel class. The Data property of the ViewModel instance is initialized with a collection of BusinessObject objects. You add a TextBox control to the Window. You need to bind the Text property of the TextBox control to the Name property of the current item of the CollectionView of the DataContext object. You also need to ensure that when a binding error occurs, the Text property of the TextBox control is set to N/A . Which binding expression should you use?()A、{ Binding Path=Data/Name, FallbackValue='N/A' }B、{ Binding Path=Data.Name, FallbackValue='N/A' }C、{ Binding Path=Data/Name, TargetNullValue='N/A' }D、{ Binding Path=Data.Name, TargetNullValue='N/A' }

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?()A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.B、Back up the current transaction log. Restore the database to the point just before the data loss.C、Restore the database from the existing backup files to a time just before the data loss.D、Restore the database to the point of the last full backup.

You are designing an application that will use Windows Azure Table storage to store millions of data points each day.  The application must retain each day’s data for only one week.   You need to recommend an approach for minimizing storage transactions.  What should you recommend?()A、 Use a separate table for each date.  Delete eachtable when it is one week old.B、 Use a separate table for each week.  Delete each table when it is one week old.C、 Use a single table, partitioned by date.  Use Entity Group Transactions to delete data when it is one week old.D、 Use a single table, partitioned by week.  Use Entity Group Transactions to delete data when it is one week old.

You need to ensure that you can recover system configuration and data if your computer hard disk fails.  What should you do? ()A、Create a system restore point.B、Create a backup of all file categories.C、Create a Complete PC Backup and Restore image.D、Perform an Automated System Recovery (ASR) backup.

单选题You use Microsoft Visual Studio 2010 and Microsoft . NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You create a WPF window in the application. You add the following code segment to the application. public class ViewModel { public CollectionView Data { get; set; } } public class BusinessObject { public string Name { get; set; } } The DataContext property of the window is set to an instance of the ViewModel class. The Data property of the ViewModel instance is initialized with a collection of BusinessObject objects. You add a TextBox control to the Window. You need to bind the Text property of the TextBox control to the Name property of the current item of the CollectionView of the DataContext object. You also need to ensure that when a binding error occurs, the Text property of the TextBox control is set to N/A . Which binding expression should you use?()A{ Binding Path=Data/Name, FallbackValue='N/A' }B{ Binding Path=Data.Name, FallbackValue='N/A' }C{ Binding Path=Data/Name, TargetNullValue='N/A' }D{ Binding Path=Data.Name, TargetNullValue='N/A' }

单选题You are developing a data contract for a Windows Communication Foundation (WCF) service. The data in the data contract must participate in round trips. Strict schema validity is not required. You need to ensure that the contract is forward-compatible and allows new data members to be added to it. Which interface should you implement in the data contract class?()AICommunicationObjectBIExtensionCIExtensibleObjectDIExtensibleDataObject

单选题You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?()AREF cursor query. BStored function. CFrom clause query. DTransactional trigger.

单选题Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do?()AImplement horizontal partitioning.BImplement vertical partitioning.CImplement a raw partition.DImplement distributed partitioning.

多选题You are implementing an ASP.NET MVC 2 Web application that allows users to view and edit data. You need to ensure that only logged-in users can access the Edit action of the controller. What are two possible attributes that you can add to the Edit action to achieve this goal? ()A[Authorize(Users = )]B[Authorize(Roles = )]C[Authorize(Users = *)]D[Authorize(Roles = *)]

单选题You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to implement a test strategy for the application. You need to ensure that the test strategy meets the following requirements: Test data can be added to the test project without recompiling. Multiple variations of a test can be executed at run time. What should you do? ()AUse IntelliTrace.BUse data-driven tests.CCreate a single test class.DCreate a test method for each data variation.

单选题You need to ensure that old data and current data can be queried according to the business requirements. What should you do?()ASpecify a view based on the archival data table and current data tables.BSpecify that the data must be queried by using a stored procedure.CSpecify that both the archival data table and the current data tables must have indexes created on the same columns.DSpecify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

单选题You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database()AUse the database link.BUse the SQL*Loader utility.CUse the Oracle Data Pump utility.DCreate an external table and leave the data in the flat file

单选题You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application has multiple data entry windows. Each window contains controls that allow the user to type different addresses for shipping and mailing. All addresses have the same format. You need to ensure that you can reuse the controls. What should you create?()Aa user controlBa data templateCa control templateDa control that inherits the Canvas class

单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?()AUpgrade the hardware/memory to accommodate the data.BLoad the data into your database by using the PARALLEL clause.CGive analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.DUse an external table so you can have the metadata available in your database, but leave the data in the operating system files.