You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation S
题目
You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.
A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.
After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.
You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.
What should you do?
A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.
B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.
C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.
D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
相似考题
更多“You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation S”相关问题
-
第1题：
You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.
You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.
You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
A．Implement merge replication.
B．Implement snapshot replication.
C．Implement transactional replication.
D．Schedule replication to run continuously.
E．Schedule replication to run during off-peak hours.
正确答案：BE
解析：Explanation:
B: Snapshot replication is the best solution since we will not be making changes to the Accounting database but need to replicate data from the database to another SQL Server computer and as the accounting department needs to have the ability to run reports that only need to be accurate through the last full working day.
E: Only one snap-shot replication would be necessary per day, and to make as little impact on the daily use of the server this replication should be scheduled during off-peak hours.
Note: SQL Server 2000 provides three types of replication that can be used in distributed applications. These are snapshot replication, transactional replication and merge replication. Each type provides different capabilities.
Snapshot replication is the process of copying and distributing data and database objects exactly as they were at the time the snapshot was taken. Snapshot replication does not require continuous monitoring of changes because changes made to published data are not propagated to the Subscriber incrementally. Subscribers are updated with a complete data set and not individual transactions. As snapshot replication replicates an entire data set at one time, it may take longer to propagate data modifications to Subscribers. This type of replication in helpful in situations when data is mostly static and does not change often; it is acceptable to have copies of data that are out of date for a period of time; replicating small volumes of data; and when sites are often disconnected and high latency (the amount of time between when data is updated at one site and when it is updated at another) is acceptable.
In transactional replication, an initial snapshot of data is propagated to Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers. SQL Server 2000 monitors INSERT, UPDATE, and DELETE statements, and changes to stored procedure executions and indexed views. SQL Server 2000 stores the transactions affecting replicated objects and then it propagates those changes to Subscribers continuously or at scheduled intervals. Transaction boundaries are preserved. Transactional replication is used when data modifications must be propagated to Subscribers, often as they occur; transactions must be atomic; subscribers are mostly connected to the Publisher and when the application will not tolerate high latency for Subscribers receiving changes.
Merge replication allows various sites to work autonomously and merge data modifications made at multiple sites into a single, uniform. result at a later time. The initial snapshot is applied to Subscribers and then SQL Server 2000 tracks changes to published data at the Publisher and at the Subscribers. The data is synchronized between servers either at a scheduled time or on demand. Updates are made independently at more than one server, so the same data may have been updated by the Publisher or by more than one Subscriber. Therefore, conflicts can occur when data modifications are merged. This type of replication is helpful when multiple Subscribers need to update data at various times and propagate those changes to the Publisher and to other Subscribers; Subscribers need to receive data, make changes offline, and synchronize changes later with the Publisher and other Subscribers; the application latency requirement is either high or low, and when site autonomy is critical.
Incorrect Answers:
A: No data at the second server will not be changed so there is no need to use merge replication.
C: We don’t need the accuracy of transactional replication. In this scenario high latency is permissible as the reports must be accurate only through the last full working day.
Note: Transactional replication is used when data modifications must be propagated to Subscribers, often as they occur; transactions must be atomic; subscribers are mostly connected to the Publisher and when the application will not tolerate high latency for Subscribers receiving changes.
D: As the reports must be accurate through the last full working day, it not necessary to run replication continuously. Running replication continuously will place locks on the destination database, which would hamper the performance of queries and actions run against the destination database.
-
第2题：
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.
正确答案:B -
第3题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）
- A、To finish the task，the Products database should be backed up.
- B、To finish the task，your server should be set to utilize the full recovery model.
- C、To finish the task，your server should be set to utilize the bulk-logged recovery model.
- D、To finish the task， the msdb database should be backed up.
正确答案:D -
第4题：
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. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）
- A、You should implement Differential backup
- B、You should implement Database snapshots
- C、You should implement Primary filegroup backup
- D、You should implement Transaction log backup
正确答案:B -
第5题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）
- A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
- B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
- C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
- D、You should place a unique index on the PartNum column.
正确答案:A -
第6题：
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 DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use? （）
- A、You should use database snapshots
- B、You should use database backup and restore
- C、You should use database backup and restore along with compression
- D、You should use schema-bound views in a read-only database. The database resides on the same instance.
正确答案:A -
第7题：
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
正确答案:D -
第8题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy， strong passwords are mandated for all domain， local， and application accounts. The company utilizes a Group Policy object （GPO） to deploy the proper domain password policy. MS-DOS-based or UNIX-based operating systems are run by many of the company’s computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator， you are required to confirm that the Services database can be accessed by these computers. And the company’s written security policy should not be violated. Which action should be performed by you？（）
- A、A domain account should be created for each of the company’s users. And then， each domain account should be offered with access to SQL1 and the Services database.
- B、A local logon account should be created on SQL1 for each of the company’s users. And then， each logon account should be offered with access to SQL1 and the Services database.
- C、One SQL Server logon account should be created for all of the company’s computers running MS-DOS or UNIX-based operating systems. And then， the Enforce password policy option should be enabled for users’ accounts. At last， the logon accounts should be provided with access to the Services database.
- D、A SQL Server logon account should be created for each of the company’s users. And then， the Enforce password policy option should be enabled for each logon account. At last， each logon account should be offered with access to the Services database.
- E、A virtual directory should be configured through Internet Information Services （IIS） for access to SQL1. And then， users should be directed to the virtual directory for data access.
正确答案:D -
第9题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）
- A、To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.
- B、To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
- C、To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
- D、To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
正确答案:B -
第10题：
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）AFirst， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
BFirst， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
CFirst， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
DYou should place a unique index on the PartNum column.
正确答案： C解析： 暂无解析 -
第11题：
单选题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? （）AServiceGreatUser should be added to the appropriate fixed database roles.
BYou should assign the appropriate object-level permissions to ServiceGreatUser
CYou should assign the appropriate server-level permissions to ServiceGreatLogin
DYou should assign the appropriate database-level permissions to ServiceGreatUser
正确答案： C解析： 暂无解析 -
第12题：
单选题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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （）AYou should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.
BYou should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances.
CYou should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances.
DYou should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
正确答案： C解析： 暂无解析 -
第13题：
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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （）
- A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.
- B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances.
- C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances.
- D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
正确答案:B -
第14题：
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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）
- A、For the database, you should turn on the TRUSTWORTHY database option
- B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM
- C、For the database, the database compatibility level option should be set to 10
- D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
正确答案:B -
第15题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a user in the Windows SalesManagers group， and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group， and he is called Jack. He is responsible to report to Simon. A report is required by Jack， and the report is limited to his sales territory， but the same detailed sales data is still displayed， and the detailed sales data is on Simon’s report. A secure solution should be designed to meet the requirements of the users listed above， and the least amount of server resources should be utilized. Which action should be performed？（）
- A、First， all territory information should be contained by a parameterized report which is designed for Simon. Second， a linked report that links to Simons report should be designed for Jack.
- B、First， two data regions should be contained by a report which is designed for Simon. Second， one data region should be utilized for summary sales data. Third， the other data region should be utilized for the detailed sales data for each sales representative. Four， a report that displays the detailed sales data should be designed for Jack.
- C、First， two reports should be designed for Simon. Second， the territory information should be contained by one， and the detailed sales data should be contained by another. At last， a report that displays the detailed sales data for Jack’s territories should be designed for Jack.
- D、First， the territory information should be contained by a report which is designed for Simon. Second， a report which detailed sales data for Jack’s territories is contained should be designed for Jack. Third， Simon’s report should be set to have the data in Jacks report contained.
正确答案:A -
第16题：
You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）
- A、Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.
- B、Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.
- C、Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.
- D、Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.
正确答案:D -
第17题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）
- A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
- B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
- C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
- D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
正确答案:A -
第18题：
You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）
- A、Decrease the amount of time between transaction log backups.
- B、Configure the database to use the simple recovery model.
- C、Configure the RECOVERY INTERVAL option to be a smaller value.
- D、Run DBCC SHRINKFILE on the transaction log file.
正确答案:A -
第19题：
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. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （）
- A、You should create a cached data collection
- B、You should create an on-demand non-cached data collection
- C、You should create a scheduled non-cached data collection.
- D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
正确答案:C -
第20题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）
- A、To achieve the goal， a Linked Server connection should be configured to the application database.
- B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.
- C、To achieve the goal， a Remote Server connection to the application database should be configured.
- D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
正确答案:D -
第21题：
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. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. In the options below， which compression technology should you use？（）
- A、You should use row compression
- B、You should use page compression
- C、You should use backup compression
- D、You should use windows NTFS file system compression
正确答案:B -
第22题：
单选题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. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （）AYou should create a cached data collection
BYou should create an on-demand non-cached data collection
CYou should create a scheduled non-cached data collection.
DYou should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
正确答案： A解析： 暂无解析 -
第23题：
单选题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. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）AYou should implement Differential backup
BYou should implement Database snapshots
CYou should implement Primary filegroup backup
DYou should implement Transaction log backup
正确答案： D解析： 暂无解析