单选题You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）A Microsoft SQL Server 2005 Mobile EditionB Microsoft SQL Server 2005 Express EditionC Microsoft SQL Server 2005 Standard EditionD Microsoft SQL Server 2005 Workgroup Edition

考题 ●In order to improve the performance of a network server，you need to select bus or local bus．The appropriate local bus is (69) ．(69) A．VESAB．ISAC．EISAD．PCI

查看答案

考题 You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.The net-libraries on SQL2000 are configured as shown in the exhibit.SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．On SQL2000, enable the multiprotocol net library.B．On SQL2000, select the force protocol encryption check box.C．On SQL7, select the force protocol encryption check box.D．On SQL2000, install a secure sockets layer (SSL) encryption certificate.E．On SQL2000 and SQL7, enable multiprotocol encryption.

查看答案

考题 You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.You cancel the SQL Server upgrade wizard.You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

查看答案

考题 You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

查看答案

考题 In order to improve the performance of a network server, you need to select bus or local bus. The appropriate local bus is(69).A．VESAB．ISAC．EISAD．PCI

查看答案

考题 You need to design a strategy to log access to the company Web site. What should you do？（）A、Enable logging on the company Web site and select the NCSA Common Log File Format. Store the log files on a SQL Server computerB、Use System Monitor to create a counter log that captures network traffic to the Web server by using the Web Service object. Store the log files on a SQL Server computerC、Run the Network Monitor on the Web server. Create a capture filter for the SNA protocol and save the results to a capture file. Store the capture file on a SQL Server computerD、Enable logging on the company Web site and select ODBC Logging. Configure the ODBC logging options by using a nonadministrative SQL account

查看答案

考题 You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal？（）A、Named PipesB、TCP/IPC、Shared MemoryD、Virtual Interface Adapter （VIA）E、Multiprotocol

查看答案

考题 TestKing.com has a server named SQL1 that runs SQL Server 2005 Enterprise Edition.SQL1 has 2 GB of RAM， 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log？（）A、MSAS 2005：CacheB、MSAS 2005：MemoryC、MSAS 2005：Proactive CachingD、SQLServer：Buffer Manager

查看答案

考题 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 an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（） A、You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured B、You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured C、You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured D、You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA

查看答案

考题 You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.

查看答案

考题 You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new RD configuration， which will include the Research， Parts， and Engineering databases.Which two combinations will be the most appropriate？（）A、Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise EditionB、Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise EditionC、Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise EditionD、Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition

查看答案

考题 You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）A、a domain user accountB、a local user accountC、the NETWORK SERVICE accountD、the LOCAL SYSTEM account

查看答案

考题 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. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1， and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you. So what action should you perform to achieve this goal？（） A、All the SQL Server logins of the application developers have to be added to a fixed server role. B、All the database users of the application developers have to be added to a fixed database role C、All SQL Server logins of the application developers should be given the appropriate server-level permissions. D、All database users of the application developers should be given the appropriate database-level permissions.

查看答案

考题 You deploy mobile devices that run Microsoft Windows Mobile 5.0. A Microsoft Windows Server 2003 server that runs Routing and Remote Access is configured to allow virtual private network （VPN） connections that are as secure as possible. You need to connect the Windows Mobilebased devices to the VPN server. You also need to ensure that both ends of the VPN tunnel are authenticated. Which two actions should you perform？（）A、Select L2TP/IPSec on each Windows Mobilebased device.B、Obtain and install a certificate on each Windows Mobilebased device.C、Configure the appropriate pre-shared key on each Windows Mobilebased device.D、Select Point-to-Point Tunneling Protocol （PPTP） on each Windows Mobilebased device.

查看答案

考题 You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）A、DBCC DBREINDEXB、SELECT * FROM sys.dm_db_index_physical_statsC、DBCC INDEXDEFRAGD、SELECT * FROM sys.indexes

查看答案

考题 You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）A、 Named Pipes B、 TCP/IP C、 Shared Memory D、 Virtual Interface Adapter (VIA) E、 Multiprotocol

查看答案

考题 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. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）A、For the SQL Server Agent, you should enable a fail-safe operator B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

查看答案

考题 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 Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? （）A、ServiceGreatUser should be added to the appropriate fixed database roles. B、You should assign the appropriate object-level permissions to ServiceGreatUser C、You should assign the appropriate server-level permissions to ServiceGreatLogin D、You should assign the appropriate database-level permissions to ServiceGreatUser

查看答案

考题多选题You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）ASet the appropriate local password policies for all computers on which SQL Server is installed.BSet the server authentication mode of all SQL Server instances to Windows Authentication mode.CInstall all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.DCreate SQL Server logins that have CHECK_POLICY 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 an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（）A You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured B You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured C You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured D You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA

查看答案

考题单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A Use the bcp utility.B Use the dta utility.C Use the SQL Server Import and Export Wizard.D Attach each SQL Server database to SQL Azure.

查看答案

考题多选题You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）ANamed PipesBTCP/IPCShared MemoryDVirtual Interface Adapter (VIA)EMultiprotocol

查看答案

考题单选题You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）A a domain user accountB a local user accountC the NETWORK SERVICE accountD the LOCAL SYSTEM account

查看答案

考题多选题Servers in your environment run Windows Server 2003. You plan to configure a highly available file server. You need to choose the appropriate high-availability technology and the minimum Windows Server 2003 edition for this server. Which technology and edition should you choose？（）Afailover clusteringBNetwork Load BalancingCWindows Server 2003， Standard EditionDWindows Server 2003， Enterprise Edition

查看答案

考题单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）A one SQL Server 2005 computer with one instanceB two SQL Server 2005 computers， each with two instancesC two SQL Server computers， one with one instance and one with three instancesD one SQL Server 2005 computer with two instances

查看答案

考题单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A Join the two servers by using the four-part syntax of server.database.schema.table.B Reference SQL2 by using an alias.C Add SQL2 as a remote server to SQL1.D Add SQL2 as a linked server to SQL1.

查看答案

考题多选题You are adatabase solutions architect.Your company plans to develop asolution by using a SQLServer 2008 instance. The solutionhas the following business requirements: Import datafromvarious datasources suchas MicrosoftOffice Excel, Microsoft SQL Server2000, Microsoft SQL Server 2005, and CSV files. Profile the source data before it is imported. Provide collaboration andoffline capabilities to mobile users. Allowmobile users to use heterogeneous data stores. You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum amount of administrative effort. Which two SQL Server components should you use?（）AAnalysis ServicesBReporting ServicesCIntegration ServicesDNotification ServicesEMicrosoft Sync Framework

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：