单选题You are the administrator of a Microsoft Windows Server 2003 computer named SQL1. SQL1 runs SQL Server 2005 and is a member of a Microsoft Active Directory domain named Contoso.com. The domain is configured with all of the default settings. Several members of the information security team have requested access to SQL1. The information security team uses the Microsoft Windows XP Professional, Linux, and Macintosh operating systems to perform vulnerability assessments. The information security team members ask you to create two new logon accounts for their use. They would like the logon accounts to have the following user names and passwords: User name/password for first account: pentest/P@ssw0rdUser name/password for second account: hacktest/password You need to provide the information security team with the requested access to SQL1.  Which Transact-SQL script should you use?()ACREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'BCREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = OFFCCREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'[HASHED]DCREATE LOGIN [CONTOSO/pentest]FROM WINDOWS CREATE LOGIN [CONTOSO/hacktest]FROM WINDOWS

单选题
You are the administrator of a Microsoft Windows Server 2003 computer named SQL1. SQL1 runs SQL Server 2005 and is a member of a Microsoft Active Directory domain named Contoso.com. The domain is configured with all of the default settings. Several members of the information security team have requested access to SQL1. The information security team uses the Microsoft Windows XP Professional, Linux, and Macintosh operating systems to perform vulnerability assessments. The information security team members ask you to create two new logon accounts for their use. They would like the logon accounts to have the following user names and passwords: User name/password for first account: pentest/P@ssw0rdUser name/password for second account: hacktest/password You need to provide the information security team with the requested access to SQL1.  Which Transact-SQL script should you use?()
A

CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'

B

CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = OFF

C

CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'[HASHED]

D

CREATE LOGIN [CONTOSO/pentest]FROM WINDOWS CREATE LOGIN [CONTOSO/hacktest]FROM WINDOWS 


参考解析

解析: 暂无解析

相关考题:

You want to upgrade a Windows NT Server 4.0 computer named Server34 to Windows 2000 Server. Server34 is a member server in a Windows 2000 domain named marketing.fabrikam.local. The domain runs in native mode.You want to change the role of Server34 from a member server to a domain controller in the same domain. What should you do? (Choose Two)A.Reinstall Windows NT Server 4.0 on Server34 in the same WINNT folder, and make Server34 a BDC in the marketing domain.B.Use Server Manager on Server34 and promote Server34 to a PDC for the marketing domain.C.Upgrade Server34 to Windows 2000 Server.D.Run the Active Directory installation wizard to make Server34 a domain controller in the marketing.fabrikam.local domain.E.Run the Active Directory installation wizard to convert Server34 to a domain controller in the marketing.fabrikam.local domain.

Your network consists of an Active Directory domain named contoso.com. You have a domain controllernamed Server1 that runs Windows Server 2003 Service Pack 2 (SP2).From Windows Backup, you run the Backup Wizard and select the All information on this computer option.You need to restore the data contained in the Netlogon share on Server1. You must achieve this goal by incurring the minimum amount of downtime.What should you restore? ()A. system stateB. %programfiles%\common files\microsoft shared folderC. %systemroot%\ntds folderD. %systemroot%\sysvol\sysvol\contoso.com\scripts folder

Your network contains an Active Directory domain named contoso.com. The functional level of the domain and the functional level of the forest are Windows Server 2003. All domain controllers run Windows Server 2008. You have a member server that runs Windows Server 2008 R2 named Server1. You install the Distributed Scan Server role service on Server1. From the Scan Management console, you attempt to add a scan process and you receive the following error. You need to ensure that you can add a scan process. What should you do?()A、Install the Fax Server role.B、Install the Print Server role service.C、Update the Active Directory schema.D、Set the functional level of the forest to Windows Server 2008.

Your network consists of a single Active Directory domain named Contoso.com. The domain contains a member server named Server1.  Server1 runs Windows Server 2003 Service Pack 2 (SP2). Server1 has Windows Support Tools and Resource Kit Tools installed. You need to view the Kerberos tickets issued to Server1.  Which tool should you run?()A、KerbtrayB、Sc/query kdcC、Netdiag/test:KerberosD、Nltest/sc_query:Contoso.com

You are the administrator of a SQL Server 2005 computer named SQL1. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain, local, and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object (GPO). Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on SQL1. You need to ensure that these computers can access the Services database without violating the company’s written security policy.  What should you do?()A、Create a domain account for each of the company’s users. Provide each domain account with access to SQL1 and the Services database.B、Create a local logon account on SQL1 for each of the company’s users. Provide each logon account with access to SQL1 and the Services database.C、Create a SQL Server logon account for each of the company’s users. Enable the Enforce password policy option for each logon account. Provide each logon account with access to the Services database.D、Configure a virtual directory through Internet Information Services (IIS) for access to SQL1. Direct users to the virtual directory for data access.E、Create one SQL Server logon account for all of the company’s computers running MS-DOS or UNIX-based operating systems. Enable the Enforce password policy option for users’ accounts. Provide the logon accounts with access to the Services database.

Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). The domain contains a member server named Server1. Server1 is a file server. You accidentally delete the computer account for Server1 from the domain. You need to ensure that users can access the file shares on Server1 by using their domain user accounts. You must achieve this goal by using the minimum amount of administrative effort. What should you do? ()A、On Server1, run the Netdom reset command.B、On Server1, add the computer to a workgroup and then add the computer to the domain. Restart Server1.C、From Active Directory Users and Computers, create a new computer account named Server1 in the domain. Restart Server1.D、On a domain controller, perform an authoritative restore in Active Directory for the Server1 computer account. Restart Server1.

Your network contains an Active Directory domain named contoso.com. All domain controllers  and member servers run Windows Server 2008. All client computer run Windows 7.  From a client computer, you create an audit policy by using the Advanced Audit Policy  Configuration settings in the Default Domain Policy Group Policy object (GPO).   You discover that the audit policy is not applied to the member servers.    The audit policy is  applied to the client computers.   You need to ensure that the audit policy is applied to all member servers and all client computers.     What should you do()A、Add a WMI filter to the Default Domain Policy GPOB、Modify the security settings of the Default Domain Policy GPOC、Configure a startup script that runs auditpol.exe on the member servers.D、Configure a startup script that runs auditpol.exe on the domain controllers.

You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing7 runs Microsoft SQL Server and hosts several mission critical databases. TestKing7 contains a mirrored volume. A routine review of TestKing7 shows failed redundancy on the mirrored volume. TestKing7 is still running and the databases are still functioning correctly. You need to correct the error and restore redundancy. What should you do first?()A、Initialize the failed disk.B、Select the failed disk and reactivate the diskC、Defragment the mirrored volume.D、Perform a disk cleanup on the mirrored volume.

Your network consists of an Active Directory domain named contoso.com. You have a domain controller named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). From Windows Backup, you run the Backup Wizard and select the All information on this computer option. You need to restore the data contained in the Netlogon share on Server1. You must achieve this goal by incurring the minimum amount of downtime. What should you restore? ()A、system stateB、%programfiles%/common files/microsoft shared folderC、%systemroot%/ntds folderD、%systemroot%/sysvol/sysvol/contoso.com/scripts folder

Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). The domain contains a member server named Server1. Server1 is a file server. You accidentally delete the computer account for Server1 from the domain. You need to ensure that users can access the file shares on Server1 by using their domain user accounts. You must achieve this goal by using the minimum amount of administrative effort. What should you do? ()A、On Server1, run the Netdom reset command.B、On Server1, add the computer to a workgroup and then add the computer to the domain. Restart Server1.C、From Active Directory Users and Computers, create a new computer account named Server1 in the domain. Restart Server1.D、On a domain controller, perform an authoritative restore in Active Directory for the Server1 computer account. Restart Server1.

Your network consists of an Active Directory domain named contoso.com. You have a domain controller named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). From Windows Backup, you run the Backup Wizard and select the All information on this computer option. You need to restore the data contained in the Netlogon share on Server1. You must achieve this goal by incurring the minimum amount of downtime. What should you restore? ()A、system stateB、%programfiles%/common files/microsoft shared folderC、%systemroot%/ntds folderD、%systemroot%/sysvol/sysvol/contoso.com/scripts folder

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 the administrator of a SQL Server 2005 computer, and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy, strong passwords are mandated for all domain, local, and application accounts. The company utilizes a Group Policy object (GPO) to deploy the proper domain password policy. MS-DOS-based or UNIX-based operating systems are run by many of the company’s computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator, you are required to confirm that the Services database can be accessed by these computers. And the company’s written security policy should not be violated.  Which action should be performed by you?()A、A domain account should be created for each of the company’s users. And then, each domain account should be offered with access to SQL1 and the Services database.B、A local logon account should be created on SQL1 for each of the company’s users. And then, each logon account should be offered with access to SQL1 and the Services database.C、One SQL Server logon account should be created for all of the company’s computers running MS-DOS or UNIX-based operating systems. And then, the Enforce password policy option should be enabled for users’ accounts. At last, the logon accounts should be provided with access to the Services database.D、A SQL Server logon account should be created for each of the company’s users. And then, the Enforce password policy option should be enabled for each logon account. At last, each logon account should be offered with access to the Services database.E、A virtual directory should be configured through Internet Information Services (IIS) for access to SQL1. And then, users should be directed to the virtual directory for data access.

You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable?()A、Internet Information ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on SQL1. You perform most of the management of SQL1 from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to SQL1. What should you do?()A、Create a Group Policy object (GPO) that is configured for success and failure auditing of the Audit account logon events setting. Ask the domain administrator to link the GPO to the object containing SQL1.B、Configure the SQL Server service on SQL1 to audit all successful and failed logon attempts.C、Edit the local security policy of SQL1. Then, configure success and failure auditing on the Audit logon events setting.D、Run the SQL Server Profiler and use a standard default template.

单选题Your network contains an Active Directory domain named contoso.com. All domain controllers  run Windows Server 2008 R2. The functional level of the domain is Windows Server 2008 R2.     The functional level of the forest is Windows Server 2008. You have a member server named  Server1 that runs Windows Server 2008. You need to ensure that you can add Server1 to  contoso.com as a domain controller.     What should you run before you promote Server1()Adcpromo.exe /CreateDCAccountBdcpromo.exe /ReplicaOrNewDomain:replicaCSet-ADDomainMode -Identity contoso.com -DomainMode Windows2008DomainDSet-ADForestMode -Identity contoso.com -ForestMode Windows2008R2Forest

单选题You are the network administrator for TestKing.com. The network consists of a single Active Directory domain named testking.com. All network servers run Windows Server 2003. You place computer accounts for servers in OUs that are organized by server roles. You apply GPOs to these servers at the OU level. You need to add a new server to the domain. You need to ensure that the appropriate GPOs are applied to this server. What should you do?()APrestage a domain computer account for the new server in the appropriate OU. Join the server to the domain by using the prestaged computer account.BOn the server, add the domain name for the Active Directory domain to the DNS suffix setting. Join the server to the domain.CAssign a user account the Allow - Create permission for the appropriate OU. Join the new server to the domain by using the user account.DJoin the new server to the Active Directory domain. On the new server, run the gpupdate /force command.

单选题Your network contains an Active Directory domain named contoso.com. All domain controllers  and member servers run Windows Server 2008. All client computer run Windows 7.  From a client computer, you create an audit policy by using the Advanced Audit Policy  Configuration settings in the Default Domain Policy Group Policy object (GPO).   You discover that the audit policy is not applied to the member servers.    The audit policy is  applied to the client computers.   You need to ensure that the audit policy is applied to all member servers and all client computers.     What should you do()AAdd a WMI filter to the Default Domain Policy GPOBModify the security settings of the Default Domain Policy GPOCConfigure a startup script that runs auditpol.exe on the member servers.DConfigure a startup script that runs auditpol.exe on the domain controllers.

单选题You are the administrator of a SQL Server 2005 computer named SQL1. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain, local, and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object (GPO). Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on SQL1. You need to ensure that these computers can access the Services database without violating the company’s written security policy.  What should you do?()ACreate a domain account for each of the company’s users. Provide each domain account with access to SQL1 and the Services database.BCreate a local logon account on SQL1 for each of the company’s users. Provide each logon account with access to SQL1 and the Services database.CCreate a SQL Server logon account for each of the company’s users. Enable the Enforce password policy option for each logon account. Provide each logon account with access to the Services database.DConfigure a virtual directory through Internet Information Services (IIS) for access to SQL1. Direct users to the virtual directory for data access.ECreate one SQL Server logon account for all of the company’s computers running MS-DOS or UNIX-based operating systems. Enable the Enforce password policy option for users’ accounts. Provide the logon accounts with access to the Services database.

单选题Your network contains an Active Directory domain named contoso.com. The functional level of the domain and the functional level of the forest are Windows Server 2003. All domain controllers run Windows Server 2008. You have a member server that runs Windows Server 2008 R2 named Server1. You install the Distributed Scan Server role service on Server1. From the Scan Management console, you attempt to add a scan process and you receive the following error. You need to ensure that you can add a scan process. What should you do?()AInstall the Fax Server role.BInstall the Print Server role service.CUpdate the Active Directory schema.DSet the functional level of the forest to Windows Server 2008.

单选题Your network consists of a single Active Directory domain named Contoso.com. The domain contains a member server named Server1. Server1 runs Windows Server 2003 Service Pack 2 (SP2). Server1 has Windows Support Tools and Resource Kit Tools installed. You need to view the Kerberos tickets issued to Server1.  Which tool should you run?()AKerbtrayBSc /query kdcCNetdiag /test:KerberosDNltest /sc_query:Contoso.com

单选题You have a computer that runs Windows XP Professional. The computer is a member of an Active Directory domain. A server administrator installs and shares a new printer on a server that runs Windows Server 2003. You need to configure the computer to print to the new printer. What should you do?()AFrom the computer, install a local printer.BFrom the computer, install a network printer. CFrom the Active Directory domain, add the computer account for the Windows XP Professional computer to the Print Operators group. DFrom the Windows Server 2003 server, add the computer account for the Windows XP Professional computer to the Print Operators group.

单选题Your network consists of an Active Directory domain named contoso.com. You have a domain controller named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). From Windows Backup, you run the Backup Wizard and select the All information on this computer option. You need to restore the data contained in the Netlogon share on Server1. You must achieve this goal by incurring the minimum amount of downtime. What should you restore? ()Asystem stateB%programfiles%/common files/microsoft shared folderC%systemroot%/ntds folderD%systemroot%/sysvol/sysvol/contoso.com/scripts folder

单选题You are the administrator of a Microsoft Windows Server 2003 computer named SQL1. SQL1 runs SQL Server 2005 and is a member of a Microsoft Active Directory domain named Contoso.com. The domain is configured with all of the default settings. Several members of the information security team have requested access to SQL1. The information security team uses the Microsoft Windows XP Professional, Linux, and Macintosh operating systems to perform vulnerability assessments. The information security team members ask you to create two new logon accounts for their use. They would like the logon accounts to have the following user names and passwords: User name/password for first account: pentest/P@ssw0rdUser name/password for second account: hacktest/password You need to provide the information security team with the requested access to SQL1.  Which Transact-SQL script should you use?()ACREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'BCREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = OFFCCREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'[HASHED]DCREATE LOGIN [CONTOSO/pentest]FROM WINDOWS CREATE LOGIN [CONTOSO/hacktest]FROM WINDOWS

单选题You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on SQL1. You perform most of the management of SQL1 from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to SQL1. What should you do?()ACreate a Group Policy object (GPO) that is configured for success and failure auditing of the Audit account logon events setting. Ask the domain administrator to link the GPO to the object containing SQL1.BConfigure the SQL Server service on SQL1 to audit all successful and failed logon attempts.CEdit the local security policy of SQL1. Then, configure success and failure auditing on the Audit logon events setting.DRun the SQL Server Profiler and use a standard default template.

单选题You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing7 runs Microsoft SQL Server and hosts several mission critical databases. TestKing7 contains a mirrored volume. A routine review of TestKing7 shows failed redundancy on the mirrored volume. TestKing7 is still running and the databases are still functioning correctly. You need to correct the error and restore redundancy. What should you do first?()AInitialize the failed disk.BSelect the failed disk and reactivate the diskCDefragment the mirrored volume.DPerform a disk cleanup on the mirrored volume.

单选题You are a network administrator for your company. The network consists of a single Active Directory domain. The domain contains three Windows Server 2003 domain controllers, 20 Windows Server 2003 member servers, and 750 Windows XP Professional computers. The domain is configured to use only Kerberos authentication for all server connections.A user reports that she receives an "Access denied" error message when she attempts to connect to one of the member servers. You want to test the functionality of Kerberos authentication on the user’s client computer.  Which command should you run from the command prompt on the user’s computer?()AnetshBnetdiagCktpassDksetup

单选题Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). The domain contains a member server named Server1. Server1 is a file server. You accidentally delete the computer account for Server1 from the domain. You need to ensure that users can access the file shares on Server1 by using their domain user accounts. You must achieve this goal by using the minimum amount of administrative effort. What should you do? ()AOn Server1, run the Netdom reset command.BOn Server1, add the computer to a workgroup and then add the computer to the domain. Restart Server1.CFrom Active Directory Users and Computers, create a new computer account named Server1 in the domain. Restart Server1.DOn a domain controller, perform an authoritative restore in Active Directory for the Server1 computer account. Restart Server1.

单选题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 the administrator of a SQL Server 2005 computer, and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy, strong passwords are mandated for all domain, local, and application accounts. The company utilizes a Group Policy object (GPO) to deploy the proper domain password policy. MS-DOS-based or UNIX-based operating systems are run by many of the company’s computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator, you are required to confirm that the Services database can be accessed by these computers. And the company’s written security policy should not be violated.  Which action should be performed by you?()AA domain account should be created for each of the company’s users. And then, each domain account should be offered with access to SQL1 and the Services database.BA local logon account should be created on SQL1 for each of the company’s users. And then, each logon account should be offered with access to SQL1 and the Services database.COne SQL Server logon account should be created for all of the company’s computers running MS-DOS or UNIX-based operating systems. And then, the Enforce password policy option should be enabled for users’ accounts. At last, the logon accounts should be provided with access to the Services database.DA SQL Server logon account should be created for each of the company’s users. And then, the Enforce password policy option should be enabled for each logon account. At last, each logon account should be offered with access to the Services database.EA virtual directory should be configured through Internet Information Services (IIS) for access to SQL1. And then, users should be directed to the virtual directory for data access.