单选题You work for a company that sells books. You are creating a report for a SQL Server 2005 database. The report will list sales representatives and their total sales for the current month. The report must include only those sales representatives who met their sales quota for the current month. The monthly sales quota is $2，000. The date parameters are passed in variables named @FromDate and @ToDate. You need to create the report so that it meets these requirements. Which SQL query should you use？（）ASELECT s.AgentName,SUM（ISNULL（o.OrderTotal，0.00））AS SumOrderTotalFROM SalesAgents JOIN OrderHeader o ON s.AgentID=o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY s.AgentNameBSELECT s.AgentName， SUM（ISNULL （o.OrderTotal，0.00））AS SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate AND o.OrderTotal = 2000GROUP BY s.AgentNameCSELECT s.AgentName， SUM（ISNULL （o.OrderTotal，0.00）） AS SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID=o.AgentID WHERE o.OrderDate BETWEEN @FromDate AND@ToDateGROUP BY s.AgentNameHAVING SUM（o.OrderTotal）=2000DSELECT s.AgentName， SUM（ISNULL（o.OrderTotal，0.00）） AS SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID=o.AgentIDWHERE o.ordertotal=2000 AND o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY s.AgentNameHAVING SUM（o.OrderTotal） = 2000
单选题
You work for a company that sells books. You are creating a report for a SQL Server 2005 database. The report will list sales representatives and their total sales for the current month. The report must include only those sales representatives who met their sales quota for the current month. The monthly sales quota is $2，000. The date parameters are passed in variables named @FromDate and @ToDate. You need to create the report so that it meets these requirements. Which SQL query should you use？（）
A
SELECT s.AgentName,SUM（ISNULL（o.OrderTotal，0.00））AS SumOrderTotalFROM SalesAgents JOIN OrderHeader o ON s.AgentID=o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY s.AgentName
B
SELECT s.AgentName， SUM（ISNULL （o.OrderTotal，0.00））AS SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate AND o.OrderTotal >= 2000GROUP BY s.AgentName
C
SELECT s.AgentName， SUM（ISNULL （o.OrderTotal，0.00）） AS SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID=o.AgentID WHERE o.OrderDate BETWEEN @FromDate AND@ToDateGROUP BY s.AgentNameHAVING SUM（o.OrderTotal）>=2000
D
SELECT s.AgentName， SUM（ISNULL（o.OrderTotal，0.00）） AS SumOrderTotalFROM SalesAgent s JOIN OrderHeader o ON s.AgentID=o.AgentIDWHERE o.ordertotal=2000 AND o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY s.AgentNameHAVING SUM（o.OrderTotal） >= 2000
参考解析
解析：
暂无解析
相关考题：
Your hard work over the years for the company _____________. A、is worth of a creditB、gives him creditC、does you creditD、has lots of credit to you
Do you commute to work? No, I work at home.（）A、You work?B、How about you?C、You do not work.D、You work by train.
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.you are responsible for managing a mailbox server named -ex01 that contains one mailbox database.A Company.com user named kara lang informs you that her mailbox contains a number of corrupted e-mail messages.you are in the process of recovering the e-mail messages of kara lang； however， other e-mail messages in the mailbox database should not be deleted.What should you do？（）A、You should consider creating a database availability group （DAG）. Then a backup of the mailbox database file should be restored. Thereafter the Export-Mailbox cmdlet should be run.B、You should consider creating a new Mailbox Recovery Database. Then a backup of the database file should be restored. Thereafter the Export-Mailbox cmdlet should be run.C、You should consider creating a new Mailbox Recovery Database. Then a backup of the database file should be restored. Thereafter the Restore-Mailbox cmdlet should be run.D、You should consider creating a database availability group （DAG）. Then a backup of the mailbox database file should be restored. Thereafter the Restore-Mailbox cmdlet should be run.
You are employed as the exchange administrator at Company.com.the Company.com network contains an exchange 2010 organization.you are responsible for managing an exchange server 2010 mailbox server named -ex01.You are in the process of implementing a policy that deletes e-mail messages automatically after 60 days.You receive an instruction from management to identify another location where users can store their messages after 60 days.However， administrators need to locate the e-mail messages in both locations when executing multi- mailbox searches. What should you do？（）A、You should consider creating a Retention Policy.B、You should consider creating a.pst file for each user that is stored in a shared folder.C、You should consider creating a Personal Archive for each user.D、You should consider creating a journal rule.
You work as the exchange administrator at Company.com.the Company.com network contains an exchange server 2010 organization.Company.com has its headquarters in stockholm where you are located.you are responsible for an exchange 2010 edge transport server named -ex01.during the course of the week you receive an instruction from the cio to make sure that e-mail messages sent to unknown addresses in the organization is rejected automatically.What should you do？（）A、You should consider configuring recipient filtering.B、You should consider configuring sender reputation.C、You should consider configuring content filtering.D、You should consider configuring sender filtering.
You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization named Company.com.All Company.com users make use of their Personal Archive. A new Company.com directive states hat messages be moved from the mail box of users to their Personal Archive after 60 days.What should you do？（）A、You should consider running the New Managed Content Settings wizard and creating a new managed folder mailbox policy.Thereafter the policy should be applied to all users.B、You should consider creating a managed custom folder.Then the New Managed Content Settings wizard should be run and a journal rule created.C、You should consider having a retention tag created.Then the retention tag should be assigned to a retention policy.Thereafter the retention policy should be applied to all users.D、You should consider having a retention tag created.Then the retention tag should be assigned to a retention policy. Thereafter a journal rule should be created.
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to ensure that a newly created room mailbox automatically accepts meeting requests.What should you do？（）A、You should consider having a managed folder mailbox policy assigned.B、You should consider having the resource booking attendant enabled.C、You should consider having the mailbox permissions modified.D、You should consider having the moderation for the mailbox enabled.
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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） A、You should use local Service accountB、You should use network Service accountC、You should use domain accountD、You should use local System account
You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization.The organization contains the subsequent servers： the Company.com organization contains one mailbox database as well as one public folder database.You receive an instruction from the cio to ensure that in the event of -ex03 failure the public folders will remain available.What should you do？（）A、You should consider creating a database availability group （DAG）. Thereafter -ex03 and mbx2 should be added to the dag.B、You should consider creating a public folder database on -ex04.Thereafter the replication settings should be changed on every public folder.C、You should consider creating a public folder database on -ex04.Thereafter the replication settings should be changed on the public folder database.D、You should consider creating a Failover Cluster.Thereafter -ex03 and -ex04 should be added to the failover cluster.
You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.Company.com has merged with another company.The users at Company.com have complained that they are not able to share contacts with the users in the merge company.However， they can share free/busy information.The users at Company.com need to share contacts.What should you do？（）A、You should consider changing the EWS virtual directory.B、You should consider changing the Federation Trust.C、You should consider changing the Organizational Relationship.D、You should consider changing the default sharing policy.
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the week you receive an instruction from the CIO to stop internal users from sending e-mail messages containing the words "Classified Data" to users outside the organization. What should you do？（）A、You should consider creating a message classification.B、You should consider creating a Transport rule.C、You should consider creating a Send connector.D、You should consider creating a managed folder mailbox policy.
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 configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （） A、You should backup the master databaseB、You should backup the default.trc fileC、You should backup the SQL Server registry hive.D、You should backup the resource database
You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）A、You should consider creating a Host （A） resource record.B、You should consider creating a Text （TXT） resource record.C、You should consider creating a Pointer （PTR） resource record.D、You should consider creating a Mail exchange （MX） resource record.
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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） A、You should use SQLServer:Buffer ManagerB、You should use SQLServer:Memory Manager C、You should use SQLServer:Databases D、You should use SQLServer:Access Methods
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 your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （） A、You should configure SQL Server VSS Writer B、You should configure Distributed File System C、You should configure SQL Server D、You should configure SQL Server Full Text
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 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task to you. On the cluster, you have to implement a manual failover. What should you do? （） A、The contents of a shared folder on the active node should be encrypted by using Encrypting File System (EFS) B、You should restore a backup to the active node C、You should get rid of the shared array from the active node D、From the active node, you have to uplug the network cable(s)
问答题Practice 1 ● You work for a large company. You are going to be transferred to another department within your company. ● Write an email to all staff: ● telling them which department you are moving to ● saying when you will be moving department ● explaining what your new responsibility will be. ● Write 40-50 words.
单选题You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the week you receive an instruction from the CIO to stop internal users from sending e-mail messages containing the words "Classified Data" to users outside the organization. What should you do？（）AYou should consider creating a message classification.BYou should consider creating a Transport rule.CYou should consider creating a Send connector.DYou should consider creating a managed folder mailbox policy.
单选题You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）AYou should consider creating a Host （A） resource record.BYou should consider creating a Text （TXT） resource record.CYou should consider creating a Pointer （PTR） resource record.DYou should consider creating a Mail exchange （MX） resource record.
单选题You are employed as the exchange administrator at Company.com.the Company.com network contains an exchange 2010 organization.you are responsible for managing an exchange server 2010 mailbox server named -ex01.You are in the process of implementing a policy that deletes e-mail messages automatically after 60 days.You receive an instruction from management to identify another location where users can store their messages after 60 days.However， administrators need to locate the e-mail messages in both locations when executing multi- mailbox searches. What should you do？（）AYou should consider creating a Retention Policy.BYou should consider creating a.pst file for each user that is stored in a shared folder.CYou should consider creating a Personal Archive for each user.DYou should consider creating a journal rule.
多选题You work as an ASP.NET Web Application Developer for SomeCompany. The company uses Visual Studio .NET 2010 as its application development platform. You are creating an ASP.NET Web application using .NET Framework 4.0. The application holds a Web page named MyHome.aspx. You are creating a button with a rolloverimage on MyHome.aspx. However， when mouse hovered over the button image， the rolloverimage is retrieved from the server in a separate request. You need to use an improved rollover button in which the button„s rolloverimage is already downloaded and stored in the browser’s cache， as a result when you hover over the button， it is instantly displayed. What will you do to accomplish this？（）AUse JavaScript Object Notation.BUse the RegisterClientScriptBlock method.CUse the RegisterClientScriptlnclude method.DBuild a JavaScript function.EUse the RegisterClientScriptResource method.
单选题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. Now you get an order from your company CIO， you have to identify whether a database integrity check （DBCC CHECKDB） was run for a particular database. Which log file should you examine？（）Alog.trc Bdefault.trc CERRORLOG DSQLAGENT
单选题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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below， which utility should you choose to use？（）Abcp.exe Bdta.exe Cdtexec.exe Dsqlmaint.exe
单选题You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.you are responsible for managing a mailbox server named -ex01 that contains one mailbox database.A Company.com user named kara lang informs you that her mailbox contains a number of corrupted e-mail messages.you are in the process of recovering the e-mail messages of kara lang； however， other e-mail messages in the mailbox database should not be deleted.What should you do？（）AYou should consider creating a database availability group （DAG）. Then a backup of the mailbox database file should be restored. Thereafter the Export-Mailbox cmdlet should be run.BYou should consider creating a new Mailbox Recovery Database. Then a backup of the database file should be restored. Thereafter the Export-Mailbox cmdlet should be run.CYou should consider creating a new Mailbox Recovery Database. Then a backup of the database file should be restored. Thereafter the Restore-Mailbox cmdlet should be run.DYou should consider creating a database availability group （DAG）. Then a backup of the mailbox database file should be restored. Thereafter the Restore-Mailbox cmdlet should be run.
单选题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. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?（）ASQLServer:Buffer Manager BSQLServer:Access Methods CSQLServer:General Statistics DSQLServer:Exec Statistics
单选题You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization.The organization contains the subsequent servers： the Company.com organization contains one mailbox database as well as one public folder database.You receive an instruction from the cio to ensure that in the event of -ex03 failure the public folders will remain available.What should you do？（）AYou should consider creating a database availability group （DAG）. Thereafter -ex03 and mbx2 should be added to the dag.BYou should consider creating a public folder database on -ex04.Thereafter the replication settings should be changed on every public folder.CYou should consider creating a public folder database on -ex04.Thereafter the replication settings should be changed on the public folder database.DYou should consider creating a Failover Cluster.Thereafter -ex03 and -ex04 should be added to the failover cluster.
多选题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 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task to you. On the cluster, you have to implement a manual failover. What should you do? （）AThe contents of a shared folder on the active node should be encrypted by using Encrypting File System (EFS)BYou should restore a backup to the active nodeCYou should get rid of the shared array from the active nodeDFrom the active node, you have to uplug the network cable(s)