WGU C175 – PA, Top Exam Questions and answers, 100% Accurate, graded A+ What is a broad definition of data?

Document Content and Description Below

WGU C175 – PA, Top Exam Questions and answers, 100% Accurate, graded A+ What is a broad definition of data? A) Numbers that are captured on digital media B) Raw facts that are captured on prin... ted or digital media C) Alphanumeric combinations that can be captured on media that a computer can read D) Any information that can be transferred from print to digital - ✔✔-Raw facts that are captured on printed or digital media What are data? A) Facts that have been organized in a meaningful way B) Facts that are the result of a query of a database system C) Facts that are collected and stored in a database system D) Facts that have been processed and used for decision making - ✔✔-Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? A) It does not allow copying and pasting. B) It is easy to query and retrieve by business applications. C) It does not follow a data model. D) It is stored in rows and columns. - ✔✔-It does not follow a data model Refer to this diagram. Inputs: A. Training Video Content B. SQL tables of training instructors Output: C. Relational database for training tracking Backup: D. Training database backup Which item represents unstructured data? A) A B) B C) C D) D - ✔✔-A Which is true about flat files? A) They contain no internal hierarchical organization. B) They have a limit of 256 records. C) They can only contain two-dimensional data. D) They are always encrypted. - ✔✔-They contain no internal hierarchical organization Which technology has no internal hierarchy? A) Flat files B) Heap files C) Hashed tables D) Relational databases - ✔✔-Flat files How were data retrieved before database management systems? A) Randomly from linked files B) Sequentially from simple files C) Using set operations on complex files D) Using relationships between logical entities - ✔✔-Sequentially from simple files What is the uniquely identifiable element about which data can be categorized in an entity-relationship diagram? A) Entity types B) Primary keys C) Unary relationships D) Intersection data points - ✔✔-Entity types Refer to this diagram. {{ Crow's Foot One or more "Salesperson" sells "Quantity" of one or more "One Product" "Quantity" of one or more "One product" sold by one or more "Salesperson" }} Which classification is correct for the box marked "Quantity" in the given entity-relationship diagram? A) Quantity data B) Modality data C) Intersection data D) Product sales data - ✔✔-Intersection data Which data classification is an entity? A) Event B) Duration C) Directions D) Attendance - ✔✔-Event Refer to this diagram. {{ Crow's Foot One and only one "Manufacterer" manufactured one or more "Car" One or more "Car" manufactured by one and only one "Manufacturer" }} What is the entity-relationship diagram about a car rental agency showing? A) An agency's cars were provided by multiple manufacturers. B) One manufacturer created at least one of the agency's cars. C) The model, year, and class of the car are part of the primary key. D) The manufacturer maintains database records for its sales representatives. - ✔✔-One manufacturer created at least one of the agency's cars A salesperson is authorized to sell 12 products; a product can be sold by 10 salespersons. Which kind of binary relationship is described in this example? A) One-to-one B) One-to-many C) Many-to-many D) Associative - ✔✔-Many-to-many Refer to this diagram. {{ Crow's Foot Many "One Customer" purchased many "One Product" Many "One Product" purchased by many "One Customer" }} Which relationship does the cardinality in the diagram represent? A) Many customers to many products B) One customer to many products C) One customer to many product numbers D) One customer to one product number E) Many customers to one product - ✔✔-Many customers to many products Refer to this entity-relationship diagram. {{ Crow's Foot One 'Salesperson' sells to one 'Customers' One 'Customers' buys from one 'Salesperson' }} How is the cardinality of the customers misrepresented? A) There is one customer number, but the cardinality indicates many customers. B) There are many customers, but the cardinality indicates one customer. C) There is more than one salesperson, but the cardinality indicates multiple salespersons. D) The cardinality of the salesperson number and the customer number do not match. - ✔✔-There are many customers, but the cardinality indicates one customer. Refer to this diagram. {{ Crow's Foot One and only one "Salesperson" sells to zero or more "Customer" Zero or more "Customer" buys from one and only one "Salesperson }} What is the correct way to read the modality on the right side of the association? A) A maximum of one customer B) A maximum of many customers C) A minimum of zero customers D) A maximum of zero customers - ✔✔-A minimum of zero customers Refer to this entity-relationship diagram. {{ Crow's Foot At least one "SALES" sold one and only one "Product" One and only one "Product" sold product of at least one "SALES" }} What is the modality of the product? A) Two B) At least one C) Two or more D) Dependent on the quantity - ✔✔-At least one Refer to this entity-relationship diagram. {{ Crow's Foot One and only one "SALESPERSON" Backs-up one and only one "SALESPERSON" One and only one "SALESPERSON" Backed-up by one and only one "SALESPERSON" }} Which kind of relationship does this diagram depict? A) Unary one-to-on [Show More]

Last updated: 2 years ago

Preview 1 out of 19 pages