Study Guides and Actual Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA


Advertise

Submit Braindumps

Forum

Tell A Friend

    Contact Us

 Home

 Search

Latest Brain Dumps

 BrainDump List

 Certifications Dumps

 Microsoft

 CompTIA

 Oracle

  Cisco
  CIW
  Novell
  Linux
  Sun
  Certs Notes
  How-Tos & Practices 
  Free Online Demos
  Free Online Quizzes
  Free Study Guides
  Free Online Sims
  Material Submission
  Test Vouchers
  Users Submissions
  Site Links
  Submit Site

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Online Training Demos and Learning Tutorials for Windows XP, 2000, 2003.

 

 

 

 





Braindumps for "4H0-028" Exam

Hyperion Certified Consultant-Hyperion System 9

 Question  1.
A Hyperion Business Rule (HBR) is being created to calculate benefit expense by Entity based on total salaries, which have been calculated for individual employees. Total Entity benefits need to be displayed when the calculation is complete. 

What is the correct sequence order of the components within HBR?

A. custom calculation, aggregate benefits, aggregate salaries
B. custom calculations, aggregate salaries, aggregate benefits
C. aggregate salaries, custom calculation, aggregate benefits
D. aggregate benefits, aggregate salaries, custom calculations

Answer:  C

Question  2.
Which Financial Reporting features are specific to using the Planning Details ADM driver? (CHOOSE THREE)

A. Planning Unit Annotations
B. Meta Data Security
C. Row and Column Templates
D. Supporting Details
E. Account Annotations

Answer:  A, B, D

Question  3.
The budget process is now closed. The application contains a User Group that all users are included in. They want to change access on the budget Scenario from write to read only for all budget users. 

What is the correct way to change access?

A. modify the NT User Group access to read only
B. update the User Group Web Forms access to read only
C. edit the User Group Access on the budget Scenario to Read
D. change the Group Security Filters to read only in Essbase Application Manager

Answer:  C

Question  4.
Which three choices describe the functionality of time periods that apply to Scenarios? (CHOOSE THREE)

A. Modify the start and end year
B. Add years to the application
C. Specify to use Beginning Balance for a time period
D. Years and periods outside of the range are read-only on Web forms

Answer:  A, C, D

Question  5.
If you choose the Use Calculator Cache option in the Aggregate Data component, what two statements are true? (CHOOSE TWO)

A. The CALCCACHE setting must be included in the Essbase.cfg file.
B. It can significantly improve calculation performance.
C. It only improves calculation performance on two pass calculations.
D. In the Analytic Services setting, the CALCCACHE setting must be selected.

Answer:  A, B

Question  6.
What option contributes to making an Enhanced Calc Script more flexible over a native Calc Script?

A. Can be run from the Planning web
B. @CALCMODE function
C. Run-time prompts
D. Run on save

Answer:  C

Question  7.
When refreshing the database in a multi-currency application, what can be selected to create a Currency Conversion Calc Script?

A. Currency, Scenario, Version Type, and Version
B. Currency, Scenario, Year, Exchange Rate Type, and Version
C. Currency, Scenario, Year, Version Type, and Version
D. Currency, Scenario, Year, and Exchange Rate Type

Answer:  A

Question  8.
Which two are valid steps to help identify the relational databases associated with Hyperion Planning applications? (CHOOSE TWO)

A. View the Hsp Js Home. properties file.
B. View the HSX_DATASOURCES table in the repository.
C. View the Connection tab in the relevant UDL files.
D. Within the Planning Desktop, view Application Creator Security Group.

Answer:  A, C

Question  9.
What are three valid variables to consider about Hyperion Planning application Web performance? (CHOOSE THREE)

A. Network bandwidth
B. Number of users that exist within the application
C. Server hardware specifications
D. Design of existing web forms

Answer:  A, C, D

Question  10.
In an application outline, Product is a custom dimension, Accounts is dense, and the summary time periods (Quarters and Year Total) on the Time Periods dimension are set to Dynamic Calc. 

How can an administrator accurately build a calculation for Gross Margin % by product for all Time Periods?

A. Use a Hyperion Business Rule (HBR)
B. Use Hyperion Analytic Services MaxL
C. Use an Analytic Services calc script
D. Use a member formula with dynamic calc storage

Answer:  D

Question  11.
Which step is necessary prior to loading attribute values using Hyperion Application Link?

A. collapse the dimension in the Hyperion Planning Dimension Editor
B. add the attribute dimension in Analytic Administration Services
C. assign the attribute to a dimension in the Hyperion Planning Dimension Editor
D. refresh the database

Answer:  C

Question  12.
Which two statements are true about assigning members to plan types? (CHOOSE TWO)

A. If you have more than one plan type in an application, you cannot assign more than one plan 
    type to an individual dimension member.
B. If the plan type is not assigned to a member, that member's children will not have access to 
    that plan type or its aggregation options.
C. If you use a User-defined custom dimension, you can specify the source plan type for the 
    members.
D. If User-defined custom dimension has been assigned to a plan type in the application, you 
    cannot assign which members are valid in that plan type.

Answer:  B, D

Question  13.
Which Hyperion Application Link Adapter can be used for loading data values?

A. Hyperion Analytic Services Adapter
B. Hyperion Planning Adapter
C. Hyperion Business Rules Adapter
D. Hyperion Smart View for Office Adapter

Answer:  A

Question  14.
Supporting Detail can have which two properties? (CHOOSE TWO)

A. Data can be in hierarchical form and include aggregation of values.
B. It can only be text information, no data can be input.
C. Data can be filled across a series of columns.
D. Detail cannot be deleted once created.
E. Detail can be retrieved in the Spreadsheet Add-in.

Answer:  A, C

Question  15.
What is necessary prior to loading shared members using Hyperion Application Link?

A. Refresh the database
B. Load the base member
C. Expand the dimension in the Hyperion Planning Desktop
D. Create the shared member's parent members in Analytic Administration Services

Answer:  B


Google
 
Web www.certsbraindumps.com


Braindumps: Dumps for 70-431 Exam Brain Dump

Study Guides and Actual Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA


Advertise

Submit Braindumps

Forum

Tell A Friend

    Contact Us





Braindumps for "70-431" Exam

Microsoft® SQL Server 2005 - Implementation and Maintenance

 Question 1.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server. The ITCertKeys.com network contains a SQL Server 2000 database server named ITCertKeys-DB01 that runs on Windows 2000 Server. ITCertKeys-DB01 contains a database named ITK_Sales.

ITCertKeys.com intends migrating ITCertKeys-DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named ITCertKeys-SR31. You verify that ITCertKeys-SR31 exceeds the minimum recommended hardware requirements for SQL Server 2005. 

What should you do next?

A. Upgrade ITCertKeys-SR31 to Windows Sever 2003 and install Service Pack 1.
B. Install and run the SQL Server Upgrade Advisor on ITCertKeys-SR31.
C. Install SQL Server 2000 on ITCertKeys-SR31.
D. Download and install the .NET Framework 2.0.

Answer: D

Explanation: 
SQL Server 2005 requires the.NET Framework 2.0. This is automatically installed when SQL Server 2005 is installed but is not automatically installed when SQL Server 2005 Express is installed.

Incorrect Answers:
A: You do not need to upgrade ITCertKeys-SR31 to Windows Sever 2003 Service Pack 1 as SQL 
    Server 2005 Express can be installed on Windows 2000 Server. You will need to install Service 
    Pack 4 for Windows 2000 Server though.
B: You should run the SQL Server Upgrade Advisor when you want to upgrade an instance of a 
    SQL Server 2000 database to SQL Server 2005.
C: You do not need to install SQL Server 2000 before installing SQL Server 2005 Express.

Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server Express, before installing

Question 2.
You work as a database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003 with the latest Service Packs and Hotfixes, while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5. 

You have received instruction to prepare for a new installation of SQL Server 2005 on a member server named ITCertKeys-SR21. ITCertKeys-SR21 will host a database named CK_Sales. All ITCertKeys.com users must be able to connect to ITCertKeys-SR21 by computer name. A ITCertKeys.com network administrator named Rory Allen must ensure that the client computers will be able to connect to ITCertKeys-DB01.

Which protocols can ITCertKeys.com users use to ITCertKeys-SR21?

A. TCP/IP and Named Pipes
B. TCP/IP and IPX/SPX
C. Virtual Interface Adapter (VIA)
D. Shared Memory

Answer: A

Explanation: 
By default, clients have TCP and Named Pipes as available protocols. You can manipulate the protocol ordering by using the SQL Server Client utility. The client application uses the protocols in the order specified on the client computer. If you are using SQL Server 2005, the protocol order is stored in the ProtocolOrder registry entry under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0

Incorrect Answers:
B: SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as 
    NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.
C: The Virtual Interface Adapter (VIA) can be used only by VIA hardware.
D: Shared Memory can only be used on the local computer and cannot be used as a network 
    protocol.

Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: client connections [SQL Server], about client network connections, choosing a network protocol

Question 3.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server. The ITCertKeys.com network contains a SQL Server 2000 database server named ITCertKeys-DB01 that runs on Windows 2000 Server. ITCertKeys-DB01 contains a database named ITK_Sales.

ITCertKeys.com intends migrating ITCertKeys-DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named ITCertKeys-SR23. ITCertKeys-SR31 was used for previously used by application developer and contains Microsoft Visual Studio 2003, .NET Framework 1.2 and Internet Explorer 5.5. You verify that ITCertKeys-SR23 exceeds the minimum recommended hardware requirements for SQL Server 2005.

What should you do next? (Each correct answer provides part of the solution. Choose THREE.)

A. Upgrade ITCertKeys-SR23 to Windows Sever 2003 and install Service Pack 1 for Windows 
    Sever 2003.
B. Install Service Pack 4 for Windows 2000 Sever on ITCertKeys-SR23.
C. Upgrade the .NET Framework 1.2 to .NET Framework 2.0 on ITCertKeys-SR23.
D. Uninstall the .NET Framework 1.2 and install the .NET Framework 2.0 on ITCertKeys-SR23.
E. Upgrade Internet Explorer 5.5 to Internet Explorer 6.0 and install Service Pack 1 for Internet 
    Explorer 6.0 on ITCertKeys-SR23.
F. Upgrade Microsoft Visual Studio 2003 to Microsoft Visual Studio 2005 and install Service Pack 
    1 for Microsoft Visual Studio 2005 on ITCertKeys-SR23.

Answer: B, D, E

Explanation: 
SQL Server 2005 requires Service Pack 4 for Windows 2000 Sever, Internet Explorer 6.0 with Service Pack 1 and the .NET Framework 2.0. The .NET Framework 2.0 is automatically installed with other versions of SQL Server 2005 but is not automatically installed with SQL Server 2005 Express. You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework 2.0 but .NET Framework 1.2 must be uninstalled first.

Incorrect Answers:
A: You do not need to upgrade ITCertKeys-SR31 to Windows Sever 2003 Service Pack 1 as SQL 
    Server 2005 Express can be installed on a Windows 2000 Server once you install Service 
    Pack 4 for Windows 2000 Server.
C: You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework 
    2.0 but .NET Framework 1.2 must be uninstalled first.
F: SQL Server 2005 Express does not require any version of Microsoft Visual Studio.

Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server Express, before installing

Question 4.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server. The ITCertKeys.com network contains a SQL Server 2000 database server named ITCertKeys-DB01 that runs on Windows 2000 Server Service Pack 4. ITCertKeys-DB01 contains a database named ITK_Trading.

ITCertKeys.com wants to migrate ITCertKeys-DB01 to SQL Server 2005 but wants to retain the ITK_Trading database with the same instance name. You decide to perform an in-place upgrade to SQL Server 2005. You verify that ITCertKeys-DB01 exceeds the minimum recommended hardware requirements for SQL Server 2005.

What should you do next?

A. Upgrade ITCertKeys-DB01 to Windows Sever 2003 Service Pack 1.
B. Run the SQL Server Upgrade Advisor on ITCertKeys-DB01.
C. Detach the ITK_Trading database on ITCertKeys-DB01.
D. Run the SQL Server 2005 Setup utility.

Answer: B

Explanation: 
Before you perform an in-place upgrade of an existing database, you should run the SQL Server Upgrade Advisor. The SQL Server Upgrade Advisor produces a list of items that must be addressed before and after performing the upgrade. This list of items is specific to the existing installation. 

Incorrect Answers:
A: You do not need to upgrade ITCertKeys-DB01 to Windows Sever 2003 Service Pack 1 as SQL 
    Server 2005 can be installed on Windows 2000 Server with Service Pack 4.
C: You need to detach a database when you need to move the database to another database 
    instance or another database server. You do not need to detach the database before 
    performing an in-place upgrade.
D: You should run the SQL Server Upgrade Advisor before you run the SQL Server 2005 Setup 
    utility. The SQL Server Upgrade Advisor produces a list of items that must be addressed 
    before and after performing the upgrade. This list of items is specific to the existing installation.

Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: updating databases, detaching and attaching databases

Question 5.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows 2000 Server. The ITCertKeys.com network contains a SQL Server 7.0 database server named ITCertKeys-DB01 that runs on Windows 2000 Server. 

Service Pack 4 for Windows 2000 Server id installed on ITCertKeys-DB01. ITCertKeys.com wants to migrate ITCertKeys-DB01 to SQL Server 2005. You decide to perform an in-place upgrade to SQL Server 2005. You verify that ITCertKeys-DB01 exceeds the recommended hardware requirements for SQL Server 2005.

What should you do next?

A. Upgrade ITCertKeys-DB01 to Windows Sever 2003.
B. Install Service Pack 4 for SQL Server 7.0 on ITCertKeys-DB01.
C. Upgrade SQL Server 7.0 on ITCertKeys-DB01 to SQL Server 2000.
D. Run the SQL Server 2005 Setup utility on ITCertKeys-DB01 and upgrade directly to SQL 
    Server 2005.

Answer: B

Explanation: 
You can upgrade from SQL Server 7.0 with Service Pack 4 directly to SQL Server 2005. Thus you need only install Service Pack 4 for SQL Server 7.0. 

Incorrect Answers:
A: You do not need to upgrade ITCertKeys-DB01 to Windows Sever 2003 as SQL Server 2005 
    can be installed on Windows 2000 Server with Service Pack 4.
C: You do not need to upgrade ITCertKeys-DB01 to SQL Server 200 as SQL Server 7.0 with 
    Service Pack 4 can be upgraded directly to SQL Server 2005. Besides, you will need to install 
    Service Pack 3 for SQL Server 2000 before you can upgrade it to SQL Server 2005.
D: You need to install Service Pack 4 for SQL Server 7.0 before you can upgrade it directly to 
    SQL Server 2005.

Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: upgrading SQL Server, upgrading to SQL Server 2005

Question 6.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003 and all client computers run Windows XP Professional. The ITCertKeys.com network contains two SQL Server 2000 database servers named ITCertKeys-DB01 and ITCertKeys-DB02 that are configured fro log shipping. ITCertKeys-DB01 is the primary server and hosts a database named ITK_Trading. 

Both ITCertKeys-DB01 and ITCertKeys-DB02 have Service Pack 3 for SQL Server 2000 installed. ITCertKeys.com wants to upgrade ITCertKeys-DB01 and ITCertKeys-DB02 to SQL Server 2005 Enterprise Edition but the ITK_Trading database must remain available during the upgrade process. You verify that both ITCertKeys-DB01 and ITCertKeys-DB02 exceed the recommended hardware requirements for SQL Server 2005 Enterprise Edition. You then install Service Pack 1 for Windows Server 2003 on ITCertKeys-DB01 and ITCertKeys-DB02.

What should you do next?

A. Install Service Pack 4 for SQL Server 2000 on both database servers.
B. Enable failover in the SQL Server 2000 log shipping configuration and upgrade ITCertKeys-
    DB02 to SQL Server 2005.
C. Run the Database Maintenance Plan Wizard on ITCertKeys-DB01 to upgrade it to SQL Server 
    2005.
D. Upgrade ITCertKeys-DB02 to SQL Server 2005 and then upgrade ITCertKeys-DB01 to SQL 
    Server 2005.

Answer: B

Explanation: 
SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral to log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a SQL Server 2000 log shipping configuration directly to SQL Server 2005. To upgrade log shipping to SQL Server 2005, you must migrate the database servers to SQL Server 2005. If you want the database to remain available during the migration process, you must migrate with failover. To migrate with failover you must enable failover and upgrade ITCertKeys-DB02. Then you need to failover to ITCertKeys-DB02 and upgrade ITCertKeys-DB01. Then configure log shipping with the ITCertKeys-DB02 becoming the primary server and ITCertKeys-DB01 becoming the secondary server.

Incorrect Answers:
A: You do not need to install Service Pack 4 for SQL Server 2000 on the database servers as 
    SQL Server 2000 with Service Pack 3 can be upgraded to SQL Server 2005. However, SQL 
    Server 2005 does not support the Database Maintenance Plan Wizard which was integral to 
    log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a 
    SQL Server 2000 log shipping configuration directly to SQL Server 2005.
C: SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral 
    to log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a 
    SQL Server 2000 log shipping configuration directly to SQL Server 2005. 
D: Removing log shipping from ITCertKeys-DB02 and upgrading ITCertKeys-DB01 to SQL Server 
    2005 will not ensure that the CK_Trading database remains available.

Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], upgrading

Question 7.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run Windows Server 2003. The ITCertKeys.com network contains a Domain Controller named ITCertKeys-DC01 and a member server named ITCertKeys-SR21. 

ITCertKeys.com wants to implement a SQL Server 2005 database that will store sales data. All ITCertKeys.com users will require access to the Sales_DB database. You have been instructed to install SQL Server 2005 on ITCertKeys-SR21 and to create a database named Sales_DB. You need to ensure that ITCertKeys.com users and applications can connect to the database instance by using only the computer name. 

What should you do during the installation of SQL Server 2005 on Certkiller-SR21?

A. Select the Named Instance and use MSSQLSERVER as the instance name.
B. Select the Named Instance and use ITCertKeys-DC01 as the instance name.
C. Select the Default Instance and accept the default instance name.
D. Select the Named Instance and use ITCertKeys-SR21 as the instance name.

Answer: C

Explanation: 
To ensure that users and applications can connect to the instance using the computer name, you should select the Default Instance and accept the default instance name, MSSQLSERVER.

Incorrect Answers:
A, B, D: You cannot use a Named Instance as users and applications will need to specify the server name and the instance name when connection to the database.

Reference:

Question 8.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run on Windows Server2003 while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5. All computers are members of the ITCertKeys.com Active Directory domain. The ITCertKeys.com network contains a SQL Server 2005 database server named ITCertKeys-DB01 that hosts a database instance named MSSQLSERVR. 

ITCertKeys.com wants to implement another SQL Server 2005 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All ITCertKeys.com users will require access to the Sales_DB database. You have been instructed to create the SQL Server 2005 instance for the Sales_DB database. You need to ensure That all users will be able to connect to the Sales_DB database. You cannot make configuration changes to the client computers. Your solution must optimize network traffic.

What should you do?

A. Install the instance as a Named Instance and configure it to support Mixed Mode 
    Authentication. The enable TCP/IP for the instance.
B. Install the instance as a Default Instance and configure it to support Windows
    Authentication. The enable TCP/IP for the instance.
C. Install the instance as a Named Instance and configure it to support SQL
    Authentication. The enable IPX/SPX for the instance.
D. Install the instance as a Default Instance and configure it to support Windows
    Authentication. The enable IPX/SPX for the instance.

Answer: A

Explanation: 
The default instance is named MSSQLSERVER. This instance name is already in use; therefore you should use a Named Instance. You should use Mixed Mode Authentication to support NetWare users.

Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is 
    already in use. Furthermore, you need to use Mixed Mode Authentication as Windows 
    Authentication does not support NetWare users.
C: You can use SQL Authentication, but this will require that you create SQL Logins for all users 
    and groups. It would be easier to use Windows Authentication for clients that user Windows XP 
    Professional and Windows 98 SE, and create SQL Logins for the NetWare 6.5 users. Also, 
    SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as 
    NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.
D: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is 
    already in use. Furthermore, you need to use Mixed Mode Authentication as Windows 
    Authentication does not support NetWare users. Also, SQL Server 2005 does not support 
    IPX/SPX. The newer versions of NetWare, such as NetWare 6.5, support TCP/IP which makes 
    it the common protocol for all clients.

Reference:

Question 9.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run on Windows Server2003 and all client computers run Windows XP Professional. The ITCertKeys.com network contains two SQL Server 2005 database servers that are configured in a cluster with two nodes named NodeA and NodeB. NodeA hosts a default database instance named MSSQLSERVR.

ITCertKeys.com wants to implement another SQL Server 2005 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All ITCertKeys.com users will require access to the Sales_DB database. You have been instructed to create the SQL Server 2005 instance for the Sales_DB database on Node 

A. You need to ensure that all users will be able to connect to the Sales_DB database.

What should you do?

A. Run the SQL Server 2005 Setup utility on NodeA and select a Named Instance for the 
    Sales_DB database.
B. Run the SQL Server 2005 Setup utility on NodeA and select the Default Instance for the 
    Sales_DB database.
C. Move the existing instance from NodeA to NodeB. Run the SQL Server 2005 Setup utility on 
    Node

A. Select the Default Instance and accept the default instance name
D. Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the 
    Sales_DB database.

Answer: A

Explanation: 
The default instance is named MSSQLSERVER. This instance name is already in use on NodeA; therefore you should use a Named Instance.

Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is 
    already in use.
C: You do not need to move the existing instance as you can install up to 50 instances on a SQL 
    Server 2005 database server.
D: You need to install the instance on NodeA not NodeB. You can install a new instance on 
    NodeA if you use a Named Instance.

Reference:

Question 10.
You work as the database administrator at ITCertKeys.com. The ITCertKeys.com network consists of a single Active Directory domain named ITCertKeys.com. All servers on the ITCertKeys.com network run on Windows Server2003 and all client computers run Windows XP Professional. The ITCertKeys.com network contains two SQL Server 2005 database servers that are configured in a cluster with two nodes named NodeA and NodeB. NodeA contains two physical hard disk drives, one of which hosts the Quorum resource and contains a single partition while the other contains two logical partitions. NodeB also has two physical hard disk drives each of which contain asingle logical partition. 

None of the hard disks in the cluster have any unallocated space left. The SQL Server 2005 cluster currently hosts four database instances. ITCertKeys.com wants to implement another SQL Server 2005 instance for a database named Manufacturing_DB. Manufacturing_DB will store data from the ITCertKeys.com Manufacturing department. You have been instructed to create the
SQL Server 2005 instance for the Manufacturing_DB database.

What should you do?

A. Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the 
    Manufacturing_DB database.
B. Create a second logical partition on one of the physical disk drives on NodeB. Run the SQL 
    Server 2005 Setup utility on NodeB and select a Named Instance for the Manufacturing_DB 
    database.
C. Add a third physical disk drive on one of the nodes. Run the SQL Server 2005 Setup utility on 
    that node and select Named Instance for the Manufacturing_DB database.
D. Run the SQL Server 2005 Setup utility on NodeA and select a Named Instance for the 
    Manufacturing_DB database.

Answer: C

Explanation: 
A single SQL Server 2005 database server can host up to 50 instances but a clustered SQL Server 2005 configuration can only host one instance per logical disk drive. There are currently five logical disk drives in the cluster but one is used for the Quorum resource this leaves you with four logical disk drives that can support a total of four instances. To add another instance, you would need to add another logical disk drive. As none of the hard disks have unallocated free
space, you would need to add another hard disk to the cluster.

Incorrect Answers:
A, D: You cannot add another instance to any of the two nodes as a clustered SQL Server 2005 
    configuration can only host one instance per logical disk drive. There are currently five logical 
    disk drives in the cluster but one is used for the Quorum resource this leaves you with four 
    logical disk drives that can support a total of four instances. To add another instance, you 
    would need to add another logical disk drive. As none of the hard disks have unallocated free 
    space, you would need to add another hard disk to the cluster.
B: You cannot create another partition on any of the physical drives on NodeB as none of the 
    hard disks in the cluster has unallocated free space that you can use to create another 
    partition. You will need to add another hard disk to the cluster for the new instance.


Google
 
Web www.certsbraindumps.com


Study Guides and Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA





              Privacy Policy                   Disclaimer                    Feedback                    Term & Conditions

www.helpline4IT.com

ITCertKeys.com

Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.