单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）Aby having each user run the report generation procedure at the scheduled time， supplying the necessary input variablesBby creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOBCby having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportDby having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportEby creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER
单选题
Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）
A
by having each user run the report generation procedure at the scheduled time， supplying the necessary input variables
B
by creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB
C
by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report
D
by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report
E
by creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER
参考解析
解析：
暂无解析
相关考题：
Which two statements are correct about database transportation? () A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
Which two statements are correct about database transportation?() (Choose two.) A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
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.
All client computers on your company network run Windows 7. The Finance department staff run an application that collects data from 09.30 hours to 15.00 hours everyday. After data collection, the application generates reports that contain data aggregation for the day and the previous week. During report generation, the Finance department staff experience slow performance on their computers. You discover that the usage of the processor on these computers is between 90 and 100 percent. You need to reduce the impact of report generation on the Finance computers. What should you do?（）A.Set the priority of the application to Low.B.Set the priority of the application to Real-time.C.Configure the processor affinity mask to ensure that the application uses all the available processors.D.Modify the memory settings of the computers to optimize the performance of the background applications.
All employee travel expense reports must be ___by the department supervisor.A. entitled B. journeyed C. signed D. treated
Which statement about WSA access logs that are to be processed by sawmill for cisco ironport istrue？（） A、 the default log format can be usedB、 the fields"%XC%X n" must be appended to the default access log formatC、 any log format can beused ， but all WSAs must use the same formatD、 any log format can be used. And different WSAs may use different formats
You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.C、Modify the format file to specify the same collation as the Dublin database. Import the table again.D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.
You need to design a monitoring strategy to meet business requirements for data on servers in the production department. What should you do？（）A、Use the Microsoft Baseline Security Analyzer （MBSA） to scan for Windows vulnerabilities on all servers in the production departmentB、Run Security and Configuration Analysis to analyze the security settings of all servers in the production departmentC、Enable auditing for data on each server in the production department. Run System Monitor on all servers in the production department to create a counter log that tracks activity for the Objects performance objectD、Create a Group Policy Object （GPO） that enables auditing for object access and link it to the product department’s Servers OU. Enable auditing for data on each server in the production department
A company has a business application that provides its users with many different reports： receivables reports， payables reports， revenue projects， and so on.The company has just purchased some new， state-of-the-art，wireless printers， and a programmer has been assigned the task of enhancing all of the reports to use not only the company’s old printers， but the new wireless printers as well.When the programmer starts looking into the application， the programmer discovers that because of the design of the application， it is necessary to make changes to each report to support the new printers. Which two design concepts most likely explain the situation？（）A、InheritanceB、Low cohesionC、Tight couplingD、High cohesionE、Loose couplingF、Object immutablility
You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（） A、 Flashback TableB、 Flashback QueryC、Flashback Version QueryD、 Flashback Transaction Query
Which two statements are correct about database transportation? （）A、The source and target platforms must be the sameB、Redo logs, control files and temp files are also transportedC、The transported database must have the same database identifier (DBID) as the source database and cannot be changedD、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE、Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.
You are the network administrator for Your network consists of two Active Directory domains. Each department has its own organizational unit (OU) for departmental user accounts. Each OU has a separate Group Policy object (GPO) A single terminal server named TestKingTerm1 is reserved for remote users. In addition, several departments have their own terminal servers for departmental use. Your help desk reports that user sessions on TestKingTerm1 remain connected even if the sessions are inactive for days. Users in the accounting department report slow response times on their terminal server. You need to ensure that users of TestKingTerm1 are automatically logged off when their sessions are inactive for more than two hours. Your solution must not affect users of any other terminal servers. What should you do?（）A、For all accounting users, change the session limit settings.B、On TestKingTerm1, use the Terminal Services configuration tool to change the session limit settings.C、Modify the GPO linked to the Accounting OU by changing the session limit settings in user-level group polices.D、Modify the GPO linked to the Accounting OU by changing the session limit settings in computer-level group polices.
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）A、 Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.B、 Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.C、 Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.D、 Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.
Your network has a single domain with 1，000 client computers that run Windows Vista. You are planning a deployment of Windows 7. Your company has multiple departments. Only the sales department will use the existing target computers to run Windows 7. You have the following requirements：Migrate the user state for each user. Preserve the file system and existing applications for only the sales department computers. You need to recommend the deployment method that is appropriate for the environment. Which combination of deployment scenarios should you recommend？（）A、 Use the Refresh Computer method for the sales department computers. Use the New Computer method for all other computers.B、 Use the Refresh Computer method for the sales department computers. Use the Replace Computer method for all other computers.C、 Use the Upgrade Computer method for the sales department computers. Use the Refresh Computer method for all other computers.D、 Use the Upgrade Computer method for the sales department computers. Use the Replace Computer method for all other computers.
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 are one of the network administrators for All network servers run Windows Server 2003. TestKing operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: 1. Track all performance changes on the servers. 2. Record performance data to anticipate the need for future upgrades. What should you do?（）A、On each server in your office, use Performance Logs and Alerts to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.B、From a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.C、On each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.D、From a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.
单选题You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）ADecrease the time between transaction log backups of the database.BDelete report snapshot history each week.CMinimize the use of session caching in the reports.DMinimize the use of report snapshots in the reports.
单选题Which statement about WSA access logs that are to be processed by sawmill for cisco ironport istrue？（）A the default log format can be usedB the fields%XC%X n must be appended to the default access log formatC any log format can beused ， but all WSAs must use the same formatD any log format can be used. And different WSAs may use different formats
单选题You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）A Flashback TableB Flashback QueryCFlashback Version QueryD Flashback Transaction Query
单选题You are the network administrator for Your network consists of two Active Directory domains. Each department has its own organizational unit (OU) for departmental user accounts. Each OU has a separate Group Policy object (GPO) A single terminal server named TestKingTerm1 is reserved for remote users. In addition, several departments have their own terminal servers for departmental use. Your help desk reports that user sessions on TestKingTerm1 remain connected even if the sessions are inactive for days. Users in the accounting department report slow response times on their terminal server. You need to ensure that users of TestKingTerm1 are automatically logged off when their sessions are inactive for more than two hours. Your solution must not affect users of any other terminal servers. What should you do?（）AFor all accounting users, change the session limit settings.BOn TestKingTerm1, use the Terminal Services configuration tool to change the session limit settings.CModify the GPO linked to the Accounting OU by changing the session limit settings in user-level group polices.DModify the GPO linked to the Accounting OU by changing the session limit settings in computer-level group polices.
单选题You are one of the network administrators for All network servers run Windows Server 2003. TestKing operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: 1. Track all performance changes on the servers. 2. Record performance data to anticipate the need for future upgrades. What should you do?（）AOn each server in your office, use Performance Logs and Alerts to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.BFrom a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.COn each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.DFrom a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.
多选题A company has a business application that provides its users with many different reports： receivables reports， payables reports， revenue projects， and so on. The company has just purchased somenew， state-of-the-art， wireless printers， and a programmer has been assigned the task of enhancing all ofthe reports to use not only the company’s old printers， but the new wireless printers as well. When the programmer starts looking into the application， the programmer discovers that because of the design of theapplication， it is necessary to make changes to each report to support the new printers. Which two designconcepts most likely explain this situation？ （）AInheritanceBLow cohesionCTight couplingDHigh cohesionELoose couplingFObject immutability
单选题You are one of the network administrators for your company. All network servers run Windows Server 2003. Your company operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: Track all performance changes on the servers. Record performance data to anticipate the need for future upgrades. What should you do? （）AOn each server in your office, use Performance Logs and Alers to create a baseline log. Configure the log tocollect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.BFrom a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.COn each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.DFrom a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.
单选题Your network has a single domain with 1，000 client computers that run Windows Vista. You are planning a deployment of Windows 7. Your company has multiple departments. Only the sales department will use the existing target computers to run Windows 7. You have the following requirements：Migrate the user state for each user. Preserve the file system and existing applications for only the sales department computers. You need to recommend the deployment method that is appropriate for the environment. Which combination of deployment scenarios should you recommend？（）A Use the Refresh Computer method for the sales department computers. Use the New Computer method for all other computers.B Use the Refresh Computer method for the sales department computers. Use the Replace Computer method for all other computers.C Use the Upgrade Computer method for the sales department computers. Use the Refresh Computer method for all other computers.D Use the Upgrade Computer method for the sales department computers. Use the Replace Computer method for all other computers.
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）A Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.B Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.C Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.D Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.
单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.