Coordinating with database administrator for best location for data

Q.  In a distributed database environment, while coordinating with the database administrator to determine the best location for the data, which of these issues will be considered?
- Published on 19 Oct 15

a. Number of transactions posted from each location
b. Amount of data (portion of table) used by each node
c. Performance characteristics and reliability of the network
d. Speed of various nodes, capacities of disks
e. All mentioned above

ANSWER: All mentioned above

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - In a distributed database environment, coordinate with the database administrator to determine the best location for the data.

    - Some issues to consider are:

    1. Number of transactions posted from each location

    2. Amount of data (portion of table) used by each node

    3. Performance characteristics and reliability of the network

    4. Speed of various nodes, capacities of disks

    5. Importance of a node or link when it is unavailable

    6. Need for referential integrity among tables

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲