单选题An online retailer is considering deploying a database application on xSeries and Windows to serve their Web-based transactions. The database will need about 4TB of usable storage.  Downtime costs the customer tens of thousands of dollars per minute， s

题目
单选题
An online retailer is considering deploying a database application on xSeries and Windows to serve their Web-based transactions. The database will need about 4TB of usable storage.  Downtime costs the customer tens of thousands of dollars per minute， so system availability will be of highest priority.  The customer needs to acquire the system within a certain budget but will pay for things that provide higher system availability.   Which of the following will be the most appropriate solution？（）
A

A dual pathed switched DS4000 Solution with Clustering， Remote replication， Redundant NICs， and Fibre attached backup

B

A single path Direct attach DS4000 solution implemented with Clustering and SAN Based Backup combined with IBM Director for PFA management

C

A dual pathed Direct Attach fibre solution， along with dual NICs and memory mirroring

D

An iSCSI solution with dual NIC’s with the Flashcopy option enabled on the DS300

相似考题

1. A customer has 4 application and 2 database servers that will be installed in partitions on a Power 750. They are concerned that the database software vendor will charge based on every processor core in the server. Which action will reduce the potential vendor software costs?（）A、Create capped partitions for the database servers.B、Create workload partitions for the database servers.C、Create a separate shared processor pool for the database servers.D、Create virtual processors equal to the entitlement for database servers.

2. A customer with a small IT budget has one data center. Their main application is a database running on an IBM System Storage DS8000. The database has a data change rate of 50% per day. Once a week， they must do a point-in-time backup from the database to tape. The time it takes to run the backup now exceeds the backup window allowed. The customer requests a proposal to reduce database downtime caused by running backups， with nearly no impact to production volumes.    In addition to the tape backup， which DS8000 feature should a technical specialist propose（）A、FlashCopyB、FlashCopy SEC、Metro MirrorD、Global Mirror

3.A retailer is considering deploying an online transaction application on xSeries to serve their buyers.  The server will need no more than four processors and will run on Red Hat Linux AS.  The storage requirement is for 5TB of usable storage， and the maximum memory requirement is 4GB of RAM.  Which solution will provide the best price and performance while maintaining fault tolerance？（）A、An x260 with dual fault tolerant ServeRAID adapters and 12 internal drivesB、An x366 with dual fault tolerant NICs with a single Fibre HBA directly attached to a DS4300 with three EXP710s fully populated with 146GB Fibre DrivesC、An x366 with dual fault tolerant NICs and two Fibre HBAs directly attached to a DS4300 Turbo with three EXP700s fully populated with 146GB drivesD、An x445 server with dual fault tolerant HBAs and a DS4500 with two additional EXP710s fully populated with 146GB Drives

4.A customer is running system management software on one of their Windows xSeries servers， and the software seems to slow down their database application over time.  The customer is running IBM Director in their environment.  Which IBM Director tool can they utilize to guarantee processor time for the different applications and optimize the server performance？（）A、Software RejuvenationB、Capacity ManagerC、Capacity Workload ManagerD、Aurema Application Workload Manager

更多“单选题An online retailer is considering deploying a database application on xSeries and Windows to serve their Web-based transactions. The database will need about 4TB of usable storage.  Downtime costs the customer tens of thousands of dollars per minute， s”相关问题

  • 第1题：

    An online retailer is considering deploying a database application on xSeries and Windows to serve their Web-based transactions. The database will need about 4TB of usable storage.  Downtime costs the customer tens of thousands of dollars per minute， so system availability will be of highest priority.  The customer needs to acquire the system within a certain budget but will pay for things that provide higher system availability.   Which of the following will be the most appropriate solution？（）

    • A、A dual pathed switched DS4000 Solution with Clustering， Remote replication， Redundant NICs， and Fibre attached backup
    • B、A single path Direct attach DS4000 solution implemented with Clustering and SAN Based Backup combined with IBM Director for PFA management
    • C、A dual pathed Direct Attach fibre solution， along with dual NICs and memory mirroring
    • D、An iSCSI solution with dual NIC’s with the Flashcopy option enabled on the DS300

    正确答案:A

  • 第2题：

    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

    • A、 Yes， if the database is in ARCHIVELOG mode
    • B、 Yes， if the database is in NOARCHIVELOG mode
    • C、 No， the backup is not usable in any way
    • D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

    正确答案:C

  • 第3题：

    You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend？（）

    • A、 Remove all clustered indexes from the database.
    • B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.
    • C、 Use SSL and SQL authentication to connect to the database.
    • D、 Use SSL and Windows authentication to connect to the database.

    正确答案:B,C

  • 第4题：

    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

  • 第5题：

    You are planning an upgrade strategy for a Windows Azure application.  You need to identify changes that will require application downtime.  Which change will always require downtime？（）

    • A、 Changing the virtual machine size
    • B、 Adding an HTTPS endpoint to a web role
    • C、 Changing the value of a configuration setting
    • D、 Upgrading the hosted service by deploying a new package

    正确答案:B

  • 第6题：

    单选题
    A customer has 4 application and 2 database servers that will be installed in partitions on a Power 750. They are concerned that the database software vendor will charge based on every processor core in the server. Which action will reduce the potential vendor software costs?（）
    A

    Create capped partitions for the database servers.

    B

    Create workload partitions for the database servers.

    C

    Create a separate shared processor pool for the database servers.

    D

    Create virtual processors equal to the entitlement for database servers.


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

  • 第7题：

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


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）
    A

     Yes， if the database is in ARCHIVELOG mode

    B

     Yes， if the database is in NOARCHIVELOG mode

    C

     No， the backup is not usable in any way

    D

     Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE


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

  • 第10题：

    单选题
    A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）
    A

    The application server，firewall，and database server on the same VLAN

    B

    The application server and firewall on one VLAN，and the database server on a second VLAN

    C

    The application server on one VLAN，and the database server and firewall on a second VLAN

    D

    The application server and firewall on one VLAN，and the firewall and database server on a second VLAN


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

  • 第11题：

    单选题
    A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution？（）
    A

    How many web servers will be connected to the database？

    B

    Will the database be run on a Windows solution？

    C

    How many concurrent users will be accessing the database？

    D

    What are the types of transactions run against the database？


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

  • 第12题：

    单选题
    A customer is running system management software on one of their Windows xSeries servers， and the software seems to slow down their database application over time.  The customer is running IBM Director in their environment.  Which IBM Director tool can they utilize to guarantee processor time for the different applications and optimize the server performance？（）
    A

    Software Rejuvenation

    B

    Capacity Manager

    C

    Capacity Workload Manager

    D

    Aurema Application Workload Manager


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

  • 第13题：

    A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）

    • A、The application server，firewall，and database server on the same VLAN
    • B、The application server and firewall on one VLAN，and the database server on a second VLAN
    • C、The application server on one VLAN，and the database server and firewall on a second VLAN
    • D、The application server and firewall on one VLAN，and the firewall and database server on a second VLAN

    正确答案:D

  • 第14题：

    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.

    正确答案:B

  • 第15题：

    You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?（）

    • A、Symmetric key encryption
    • B、Asymmetric key encryption
    • C、Certificate-based encryption
    • D、Transparent data encryption

    正确答案:A

  • 第16题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day， an application adds millions of fact rows and thousands of new customers. Currently， a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use？（）

    • A、 hybrid online analytical processing （HOLAP）
    • B、 relational online analytical processing （ROLAP）
    • C、 multidimensional online analytical processing （MOLAP）
    • D、 automatic multidimensional online analytical processing （automatic MOLAP）

    正确答案:A

  • 第17题：

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


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

  • 第18题：

    单选题
    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）
    A

     Create a database view to retrieve the data.

    B

     Use a clustered index on the SQL Azure database tables.

    C

     Open a new database connection when an operation times out.

    D

     Create SQL Azure database table indexes basedon application queries


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

  • 第19题：

    单选题
    A retailer is considering deploying an online transaction application on xSeries to serve their buyers.  The server will need no more than four processors and will run on Red Hat Linux AS.  The storage requirement is for 5TB of usable storage， and the maximum memory requirement is 4GB of RAM.  Which solution will provide the best price and performance while maintaining fault tolerance？（）
    A

    An x260 with dual fault tolerant ServeRAID adapters and 12 internal drives

    B

    An x366 with dual fault tolerant NICs with a single Fibre HBA directly attached to a DS4300 with three EXP710s fully populated with 146GB Fibre Drives

    C

    An x366 with dual fault tolerant NICs and two Fibre HBAs directly attached to a DS4300 Turbo with three EXP700s fully populated with 146GB drives

    D

    An x445 server with dual fault tolerant HBAs and a DS4500 with two additional EXP710s fully populated with 146GB Drives


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

  • 第20题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day， an application adds millions of fact rows and thousands of new customers. Currently， a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use？（）
    A

     hybrid online analytical processing （HOLAP）

    B

     relational online analytical processing （ROLAP）

    C

     multidimensional online analytical processing （MOLAP）

    D

     automatic multidimensional online analytical processing （automatic MOLAP）


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

  • 第21题：

    单选题
    You are planning an upgrade strategy for a Windows Azure application.  You need to identify changes that will require application downtime.  Which change will always require downtime？（）
    A

     Changing the virtual machine size

    B

     Adding an HTTPS endpoint to a web role

    C

     Changing the value of a configuration setting

    D

     Upgrading the hosted service by deploying a new package


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

  • 第22题：

    单选题
    A customer with a small IT budget has one data center. Their main application is a database running on an IBM System Storage DS8000. The database has a data change rate of 50% per day. Once a week， they must do a point-in-time backup from the database to tape. The time it takes to run the backup now exceeds the backup window allowed. The customer requests a proposal to reduce database downtime caused by running backups， with nearly no impact to production volumes.    In addition to the tape backup， which DS8000 feature should a technical specialist propose（）
    A

    FlashCopy

    B

    FlashCopy SE

    C

    Metro Mirror

    D

    Global Mirror


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

  • 第23题：

    单选题
    You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?（）
    A

    Symmetric key encryption

    B

    Asymmetric key encryption

    C

    Certificate-based encryption

    D

    Transparent data encryption


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

相关内容