单选题You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report 

题目
单选题
You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
A

Recreate the query and default the layout. 

B

Alter the query, default the layout and redo the boiler plates. 

C

Query and manually change the layout to save the boiler plate. 

D

Alter the query and make no further change.

相似考题

1.The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）A、Fixed B、Expand C、Contract D、Variable

2.You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?（）A、Source B、Print direction C、Maximum records per page D、Minimum Widow records E、Column mode

3. 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.

4.The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）A、Report wizard. B、Layout model. C、Data model. D、Life previewer.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report ”相关问题

  • 第1题：

    You are the network administrator for The sales department stores data on a server that runs Windows Server 2003. The backup schedule for the server includes a normal backup on Sundays and incremental backups on every other day of the week. The sales department data includes a report that is created by an automated process. The report is included in the standard backup schedule for the server. The automated process runs on Wednesdays and Sundays. The process overwrites the previous version of the report. You need to be able to restore the report if the standard backup is unavailable. You need to create an additional backup for the report. The backup for the report cannot interfere with other backup jobs. What should you do?（）

    • A、Perform a normal backup on Wednesday night and on Sunday night.
    • B、Perform a differential backup on Wednesday night and on Sunday night.
    • C、Perform a incremental backup on Wednesday night and on Sunday night.
    • D、Perform a copy backup on Wednesday night and on Sunday night.

    正确答案:D

  • 第2题：

    You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）

    • A、Use the report wizard to change the column label. 
    • B、Click and high light the column label and replace it with desired text. 
    • C、Click the column label and alter its property palette. 
    • D、Click the dept column and alter its property palette. 

    正确答案:B

  • 第3题：

    You are the network administrator for Testking.com. The network consists of a single Active Directory domain named testking.com. The sales department is hiring employees. An OU named TestKingSales is created to hold objects for the new sales department users. Each sales department user has a portable computer. Each portable computer runs Windows XP Professional. The sales department users are responsible for joining their portable computers to the domain. You need to ensure that the computer accounts for the Sales department user's portable computers are created in the TestKingSales OU. You need to achieve this goal without granting any unnecessary permissions. What should you do?（）

    • A、Assign the sales department users the Allow - Read permissions for the Computer container.
    • B、Configure the sales department users' user accounts to be trusted for delegation
    • C、Prestage the computer accounts in the TestKingSales OU for the sales department users' portable computers.
    • D、Assign the sales depertment users the Allow - Create all Child Objects permission for the TestKingSales OU.

    正确答案:C

  • 第4题：

    You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources.  What should you do？（）

    • A、Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then， design a report for Joe that displays the detailed sales data.
    • B、Design two reports for Susan. One report includes the territory information， and one report includes the detailed sales data. Then， design a report for Joe that displays the detailed sales data for his territories.
    • C、Design a report for Susan that includes the territory information. Then， design a report for Joe that includes detailed sales data for his territories. Finally， configure Susans report so that it includes the data in Joes report.
    • D、Design a parameterized report for Susan that includes all territory information. Then， design a linked report for Joe that links to Susans report.

    正确答案:D

  • 第5题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

    • A、 Use a subreport.
    • B、 Use a bookmark link.
    • C、 Use the drilldown functionality.
    • D、 Use a drillthrough report link.

    正确答案:D

  • 第6题：

    单选题
    You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
    A

    Recreate the query and default the layout. 

    B

    Alter the query, default the layout and redo the boiler plates. 

    C

    Query and manually change the layout to save the boiler plate. 

    D

    Alter the query and make no further change.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）
    A

    Report wizard. 

    B

    Layout model. 

    C

    Data model. 

    D

    Life previewer.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources.  What should you do？（）
    A

    Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then， design a report for Joe that displays the detailed sales data.

    B

    Design two reports for Susan. One report includes the territory information， and one report includes the detailed sales data. Then， design a report for Joe that displays the detailed sales data for his territories.

    C

    Design a report for Susan that includes the territory information. Then， design a report for Joe that includes detailed sales data for his territories. Finally， configure Susans report so that it includes the data in Joes report.

    D

    Design a parameterized report for Susan that includes all territory information. Then， design a linked report for Joe that links to Susans report.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You are the desktop administrator for Company. All users have Windows 2000 Professional computers.Users in the sales department have portable computers. The portable computers are used to createcustomer presentations and perform online ordering.Sales representatives want to be able to use large external monitors to display their presentations atcustomer locations. These users also want to use the displays on the portable computers to show theirspeaker notes and extra data.You verify that the video adapters in the portable computers support multiple monitor and dual-viewcapabilities. However, the sales representatives report that when they attach the external monitors totheir computers, the option to define separate desktop displays does not appear in the Display settings.You need to enable the sales representatives to display multiple desktops. What should you do?（）
    A

    Obtain and install an updated driver from the video adapter manufacturer. 

    B

    Instruct the sales representatives to disable all hardware video acceleration during their presentations. 

    C

    Configure the monitors on the sales representatives’ computers to use the Presentation power scheme. 

    D

    Create a monitor profile on the sales representatives’ computers for the external monitors at the customer sites. 


    正确答案： A
    解析： The video adapter supports external monitors so it must be a device driver problem. We need to obtain and install an updated video adapter device driver that supports the use of an external monitor.

  • 第10题：

    单选题
    You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）
    A

     List

    B

     Table

    C

     Matrix

    D

     Subreport


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You are the desktop administrator for your company's sales department. The IT manager for the sales department needs to distribute a custom application to the Windows XP Professional computers in the sales department. He deploys the software by using Group Policy. Susan is a user in the sales department. She reports that the custom application is not available. You examine her computer, and you verify that the application is not present on her computer. You want to ensure that the software is deployed the next time Susan logs on. Which command should you run?（）
    A

    Secedit /refreshpolicy user_policy /enforce

    B

    Secedit /refreshpolicy machine_policy /enforce

    C

    Gpupdate /target:computer /sync

    D

    Gpupdate /target:user /sync


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

    • A、After the query. 
    • B、Enter the report and change the column's position in the field tab. 
    • C、Alter the column's position in the object navigator. 
    • D、Enter the report wizard and change the column's position in the data tab. 
    • E、Alter the column's position within its group and change the layout. 

    正确答案:B

  • 第14题：

    The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）

    • A、In the template used. 
    • B、In the data model. 
    • C、In the life previewer. 
    • D、In the field property palette.

    正确答案:C

  • 第15题：

    You are the administrator of your company's network. You want to configure a Security Policy for the Windows 2000 Professional Computers that are in the sales department.   On one of the computers, you use Security Templates to configure the Security Policy based on the desired security settings. You then export those settings to an .inf file that will be used on all of the Computers in the sales department. You want to configure each Computer to have a customized Security Policy. What steps should you follow in order to achieve your goal?（）

    • A、Use Secedit.exe to import the security settings from the .inf file to the computers in the sales department.
    • B、Use a text editor to change the default security settings to the desired security settings. Then export those settings to the Computers in the sales department.
    • C、Create an organizational unit （OU） named Sales. Add the users in the sales department to the Sales OU. Then apply the security template to the users in the Sales OU.
    • D、Create an organizational unit （OU） named Sales. Add the computers in the sales department to the Sales OU. Then apply the security template to computers in the Sales OU.

    正确答案:D

  • 第16题：

    You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）

    • A、 List
    • B、 Table
    • C、 Matrix
    • D、 Subreport

    正确答案:D

  • 第17题：

    单选题
    You are the administrator of your company's network. You want to configure a Security Policy for the Windows 2000 Professional Computers that are in the sales department.   On one of the computers, you use Security Templates to configure the Security Policy based on the desired security settings. You then export those settings to an .inf file that will be used on all of the Computers in the sales department. You want to configure each Computer to have a customized Security Policy. What steps should you follow in order to achieve your goal?（）
    A

    Use Secedit.exe to import the security settings from the .inf file to the computers in the sales department.

    B

    Use a text editor to change the default security settings to the desired security settings. Then export those settings to the Computers in the sales department.

    C

    Create an organizational unit （OU） named Sales. Add the users in the sales department to the Sales OU. Then apply the security template to the users in the Sales OU.

    D

    Create an organizational unit （OU） named Sales. Add the computers in the sales department to the Sales OU. Then apply the security template to computers in the Sales OU.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    You are the network administrator for Testking.com. The network consists of a single Active Directory domain named testking.com. The sales department is hiring employees. An OU named TestKingSales is created to hold objects for the new sales department users. Each sales department user has a portable computer. Each portable computer runs Windows XP Professional. The sales department users are responsible for joining their portable computers to the domain. You need to ensure that the computer accounts for the Sales department user's portable computers are created in the TestKingSales OU. You need to achieve this goal without granting any unnecessary permissions. What should you do?（）
    A

    Assign the sales department users the Allow - Read permissions for the Computer container.

    B

    Configure the sales department users' user accounts to be trusted for delegation

    C

    Prestage the computer accounts in the TestKingSales OU for the sales department users' portable computers.

    D

    Assign the sales depertment users the Allow - Create all Child Objects permission for the TestKingSales OU.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）
    A

    Use the report wizard to change the column label. 

    B

    Click and high light the column label and replace it with desired text. 

    C

    Click the column label and alter its property palette. 

    D

    Click the dept column and alter its property palette. 


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?（）
    A

    Source 

    B

    Print direction 

    C

    Maximum records per page 

    D

    Minimum Widow records 

    E

    Column mode


    正确答案： E
    解析： 暂无解析

  • 第21题：

    单选题
    You are the network administrator for The sales department stores data on a server that runs Windows Server 2003. The backup schedule for the server includes a normal backup on Sundays and incremental backups on every other day of the week. The sales department data includes a report that is created by an automated process. The report is included in the standard backup schedule for the server. The automated process runs on Wednesdays and Sundays. The process overwrites the previous version of the report. You need to be able to restore the report if the standard backup is unavailable. You need to create an additional backup for the report. The backup for the report cannot interfere with other backup jobs. What should you do?（）
    A

    Perform a normal backup on Wednesday night and on Sunday night.

    B

    Perform a differential backup on Wednesday night and on Sunday night.

    C

    Perform a incremental backup on Wednesday night and on Sunday night.

    D

    Perform a copy backup on Wednesday night and on Sunday night.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）
    A

    Fixed 

    B

    Expand 

    C

    Contract 

    D

    Variable


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）
    A

     Use a subreport.

    B

     Use a bookmark link.

    C

     Use the drilldown functionality.

    D

     Use a drillthrough report link.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）
    A

    In the template used. 

    B

    In the data model. 

    C

    In the life previewer. 

    D

    In the field property palette.


    正确答案： D
    解析： 暂无解析

相关内容