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.
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.
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.
Design a parameterized report for Susan that includes all territory information. Then, design a linked report for Joe that links to Susans report.
第1题:
You are the domain administrator for your company. Roaming profiles are enabled for all users in the sales department. Roaming profiles are stored on a server named Server1, in a shared folder named Profiles. Roger is a user in the sales department. Susan is Roger's manager. Susan reports that Roger modifies his desktop settings, which results in the need for help desk assistance and in lost productivity for Roger. You want to ensure that Roger cannot modify his roaming profile. What should you do?()
第2题:
Which statement creates a new user?()
第3题:
A. CREATIVE USER susan;
B. CREATIVE OR REPLACE USER susan;
C. CREATE NEW USER susan DEFAULT
D. CREATE USER susan IDENTIFIED BY blue;
E. CREATE NEW USER susan IDENTIFIED BY blue;
F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;
第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?()
第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 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?()
第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. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?()
第7题:
You are the desktop administrator for your company's sales department. Susan is a user in the sales department. Susan's computer currently runs Microsoft Windows NT Workstation 4. 0. Susan uses a legacy application that is compatible with only Windows NT Workstation. You want to install Windows XP Professional on Susan's computer. You plan to set up a dual-boot configuration so that Susan can run either Windows XP Professional or Windows NT Workstation. Susan's computer has two hard disks, named drive C and drive G. You install Windows XP Professional on drive G. After Windows XP Professional is installed, Susan reports that Windows NT Workstation is no longer available. You need to ensure that both operating systems are available on Susan's computer. What should you do?()
第8题:
Which statement creates a new user?()
第9题:
You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003, and all client computers run Windows XP Professional. You create and share a folder named Sales on a member server. You apply the default share permission and NTFS permissions to Sales. Then you create a folder named SalesForecast in Sales. You apply the default NTFS permissions to SalesForecast. Managers in the sales department are members of a domain user group named SalesManagers. When members of SalesManagers try to add files to SalesForecast,they receive the "Access is denied" error message. You need to configure permissions on these folders to fulfil the following requirements: 1. Members of SalesManagers must be able to create, modify, and delete files in both folders. 2. All other domain users must only be able to read files in both folders. What should you do?()
第10题:
You are the administrator of your company’s network. A user named Paul in the service department has a Windows 2000 Professional computer. Paul needs to access the files that are in a shared folder on his computer. A local group named Sales has permissions to access the data. Paul is a member of the Sales local group but he cannot access the file he needs. What should you do? ()