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

AI Explanation

To answer this question, you need to understand the concept of metadata. Metadata refers to data about data and provides information about the characteristics and properties of the data. Let's go through each option to understand why it is correct or incorrect:

Option A) Data about data - This option is correct because it accurately describes the concept of metadata.

Option B) Describe a data dictionary - This option is correct because a data dictionary is a type of metadata that provides descriptions and definitions of data elements.

Option C) Self-describing - This option is correct because metadata is designed to be self-describing, meaning it provides information about the structure, format, and organization of the data.

Option D) Includes user data - This option is incorrect because user data is not a characteristic of metadata. Metadata focuses on providing information about the data itself, rather than including user-specific data.

Option E) Supports its own structure - This option is correct because metadata often has its own structure and organization to ensure that it can effectively describe and represent the data it refers to.

The correct answer is Option D. This option is incorrect because including user data is not a characteristic of metadata. Metadata focuses on providing information about the data, rather than including specific user-related information.

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