单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operat

题目
单选题
You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）
A

 Implement parameterized Transact-SQL queries in the application. 

B

 Implement Transact-SQL stored procedures in the database. 

C

 Implement CLR stored procedures in the database. 

D

 Implement distributed Web services.

相似考题

1.You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

2. You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.

3. 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. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.B、In a query execution plan， you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.D、In a query execution plan， you should look for queries with a large number of table scans.

4. 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. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）A、To achieve the goal， DBCC DBREINDEX should be utilized.B、To achieve the goal， SELECT * FROM sys.indexes should be utilized.C、To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.D、To achieve the goal， DBCC INDEXDEFRAG should be utilized.

参考答案和解析
正确答案： D
解析： 暂无解析
更多“You are creating a SQL Server 2005 database for a mortgage c”相关问题

  • 第1题：

    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. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.  Which action should be performed to finish the task？（）

    • A、To finish the task，the Products database should be backed up.
    • B、To finish the task，your server should be set to utilize the full recovery model.
    • C、To finish the task，your server should be set to utilize the bulk-logged recovery model.
    • D、To finish the task， the msdb database should be backed up.

    正确答案:D

  • 第2题：

    ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

    • A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
    • B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
    • C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
    • D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

    正确答案:D

  • 第3题：

    You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）

    • A、Implement parameterized Transact-SQL queries in the application.
    • B、Implement Transact-SQL stored procedures in the database.
    • C、Implement CLR stored procedures in the database.
    • D、Implement distributed Web services.

    正确答案:C

  • 第4题：

    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. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）

    • A、To achieve the goal， a Linked Server connection should be configured to the application database.
    • B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.
    • C、To achieve the goal， a Remote Server connection to the application database should be configured.
    • D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.

    正确答案:D

  • 第5题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）

    • A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
    • B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
    • C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
    • D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

    正确答案:A

  • 第6题：

    单选题
    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）
    A

    Configure a Linked Server connection to the application database.

    B

    Write a query that uses an OPENDATASOURCE command.

    C

    Write a query that uses an OPENQUERY command.

    D

    Configure a Remote Server connection to the application database.


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

  • 第7题：

    单选题
    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. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）
    A

    To achieve the goal， DBCC DBREINDEX should be utilized.

    B

    To achieve the goal， SELECT * FROM sys.indexes should be utilized.

    C

    To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.

    D

    To achieve the goal， DBCC INDEXDEFRAG should be utilized.


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

  • 第8题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）
    A

    You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 

    B

    You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 

    C

    You should upgrade the SQL Server 2005 application to use SQL Server 2008. 

    D

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 


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

  • 第9题：

    单选题
    You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）
    A

    Install a separate instance of SQL Server 2005 for each of the databases on a single server.

    B

    Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.

    C

    Import the data from each of the databases into a single database in an instance of SQL Server 2005.

    D

    Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.


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

  • 第10题：

    单选题
    ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （）
    A

    You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 

    B

    You should upgrade the SQL Server 2005 application to use SQL Server 2008 

    C

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 

    D

    You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 


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

  • 第11题：

    单选题
    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 called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.

    B

    To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.

    C

    To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.

    D

    To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.


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

  • 第12题：

    单选题
    You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）
    A

     Implement parameterized Transact-SQL queries in the application. 

    B

     Implement Transact-SQL stored procedures in the database. 

    C

     Implement CLR stored procedures in the database. 

    D

     Implement distributed Web services.


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

  • 第13题：

    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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）

    • A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
    • B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
    • C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
    • D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

    正确答案:A

  • 第14题：

    You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do？（）

    • A、Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
    • B、Query the sys.server_permissions table on Server1.
    • C、Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
    • D、Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

    正确答案:D

  • 第15题：

    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 Services
    • B、SQL Server Browser
    • C、SQL Server Agent
    • D、Microsoft Distributed Transaction Coordinator

    正确答案:B,D

  • 第16题：

    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 called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases.  Which action should be performed to achieve the goal？（）

    • A、To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.
    • B、To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
    • C、To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
    • D、To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.

    正确答案:B

  • 第17题：

    单选题
    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. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）
    A

    In a SQL Trace log file， you should look for queries with low duration values and high read and write values.

    B

    In a query execution plan， you should look for queries with missing or out-of-date statistics.

    C

    In a SQL Trace log file， you should look for queries with high duration values and low read and write values.

    D

    In a query execution plan， you should look for queries with a large number of table scans.


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

  • 第18题：

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

    B

    Microsoft SQL Server 2005 Express Edition

    C

    Microsoft SQL Server 2005 Standard Edition

    D

    Microsoft SQL Server 2005 Workgroup Edition


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

  • 第19题：

    单选题
    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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）
    A

    The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.

    B

    The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.

    C

    The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.

    D

    The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.


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

  • 第20题：

    单选题
    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. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a Linked Server connection should be configured to the application database.

    B

    To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.

    C

    To achieve the goal， a Remote Server connection to the application database should be configured.

    D

    To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.


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

  • 第21题：

    单选题
    You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do？（）
    A

    Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.

    B

    Query the sys.server_permissions table on Server1.

    C

    Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.

    D

    Query the sys.database_permissions and sys.database_principals tables in the MedDB database.


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

  • 第22题：

    单选题
    You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）
    A

    Implement parameterized Transact-SQL queries in the application.

    B

    Implement Transact-SQL stored procedures in the database.

    C

    Implement CLR stored procedures in the database.

    D

    Implement distributed Web services.


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

  • 第23题：

    单选题
    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. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.  Which action should be performed to finish the task？（）
    A

    To finish the task，the Products database should be backed up.

    B

    To finish the task，your server should be set to utilize the full recovery model.

    C

    To finish the task，your server should be set to utilize the bulk-logged recovery model.

    D

    To finish the task， the msdb database should be backed up.


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

  • 第24题：

    多选题
    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 Services

    B

    SQL Server Browser

    C

    SQL Server Agent

    D

    Microsoft Distributed Transaction Coordinator


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

相关内容