Tag: architecture

Questions Related to architecture

A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes a(n):
technology architecture

  1. logical model

  2. data flow diagram

  3. entity-relationship diagram

  4. data tree

Show answer
Correct Option: C

Which of the following is not a data modeling tool?
technology architecture

  1. Visio

  2. ERwin

  3. ER/Studio

  4. Data Builder

  5. empowER

Show answer
Correct Option: D

What is the goal of Data Architecture
technology architecture

  1. Design logical data systems

  2. Design physical storage system

  3. Define data entities relevant to the enterprise

  4. All of the above

Show answer
Correct Option: C

Data architecture document dos not include:

technology architecture

  1. Business Data Model

  2. Logical Data Model

  3. Data Management Process Model

  4. Data entity/business function Matrix

  5. Data Interface requirements

Show answer
Correct Option: E

What is an alternate key?
technology architecture

  1. The relationship between more than one entity which has more than one attribute

  2. An attribute that cannot easily identify a record, but can easily viewed as a field

  3. An attribute, other than primary key, that can be used to identify an instance of an entity

  4. A non-distinguishable primary key which is not used to identify fields or records

  5. A primary key with two or more columns on a non-clustered index

Show answer
Correct Option: C 
CREATE TABLE Purchaser{ 
      name string,
      credit_card integer (PRIMARY KEY), 
      address string 
}
CREATE TABLE Product{ 
    product_id integer (PRIMARY KEY), 
    product_name string 
}
CREATE TABLE Purchaser_Product{ 
    credit_card integer, 
    product_id integer, 
    purchase_date date 
}

Based on the sample code above, what is the primary key in the Purchaser_Product table?
technology architecture

  1. purchase_date

  2. Credit_card

  3. null

  4. credit_card & product_id

  5. product_id

Show answer
Correct Option: D

A company has a model consisting of eight entities. The parent entity, "Company," has three child entities: "Employee," "Product," and "Order." The Product entity has a categorization of four entities: "Computer," "Software," "Accessory," and "Clearance." Each entity has only one attribute making up the key attribute. Based on the scenario above, what foreign key appears in the model exactly three times ?
technology architecture

  1. computer_id

  2. product_id

  3. company_id

  4. employee_id

  5. order_id

Show answer
Correct Option: C

If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?

technology architecture

  1. Identifying

  2. Normalizing

  3. Categorizing

  4. Non-identifying

  5. Emphasizing

Show answer
Correct Option: A

Which one of the following is NOT a characteristic of metadata?
technology architecture

  1. Data about data

  2. Describe a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure

Show answer
Correct Option: D

What can a mandatory one to one relationship indicate?
technology architecture

  1. More entities are needed

  2. The model should be denormolized

  3. The tables are not properly indexed

  4. The model cannot be implemented physically

  5. More attributes are needed

Show answer
Correct Option: E