单选题Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?（）A Group left. B Form like. C Matrix W/group. D Group above. E Mailing label. F Form letter.

第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 need to design an access control strategy that meets business and security requirements. Your solution must minimize forestwide replication. What should you do？（）

• A、Create a global group for each department and a global group for each location. Add users to their respective departmental groups as members. Place the departmental global groups within the location global groups. Assign the location global groups to file and printer resources in their respective domains， and then assign permissions for the file and printer resources by using the location global groups
• B、Create a global group for each department， and add the respective users as members. Create domain local groups for file and printer resources. Add the global groups to the respective domain local groups. Then， assign permissions to the file and printer resources by using the domain local groups
• C、Create a local group on each server and add the authorized users as members. Assign appropriate permissions for the file and printer resources to the local groups
• D、Create a universal group for each location， and add the respective users as members. Assign the universal groups to file and printer resources. Then， assign permissions by using the universal groups

第3题：

第4题：

You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）

• A、Report level trigger. 
• B、Group filter. 
• C、Format trigger. 
• D、None of the above.

第5题：

Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）

• A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
• B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
• C、SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
• D、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
• E、SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
• F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

第6题：

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

第7题：

Your network consists of a single Active Directory domain. User accounts for engineering department  are located in an OU named Engineering.    You need to create a password policy for the engineering department that is different from your domain  password policy.    What should you do（）

• A、Create a new GPO. Link the GPO to the Engineering OU.
• B、Create a new GPO. Link the GPO to the domain. Block policy inheritance on all OUs except for the  Engineering OU.
• C、Create a global security group and add all the user accounts for the engineering department to the  group. Create a new Password Policy Object （PSO） and apply it to the group.
• D、Create a domain local security group and add all the user accounts for the engineering department to  the group. From the Active Directory Users and Computer console， select the group and run the  Delegation of Control Wizard.

第8题：

第9题：

Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

• A、Specify the break order on the gemp group Property palette. 
• B、Specify a break order on the dept_name and job columns property palettes. 
• C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
• D、Change the position of the dept_name and the job columns within the gemp group.

第10题：

The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（）

• A、Minimum widow records. 
• B、Column mode. 
• C、Spacing 
• D、Print direction. 
• E、Source F maximum records per page. 
• F、Maximum records per page.