Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU C175
  4. Set 1
WGU C175 · Data Management – Foundations

WGU C175 Practice Questions – Set 1

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

A company requires that their database system be hosted on a service like Microsoft Azure or Amazon AWS. What type of database is most suitable for this?

Question 2 of 50

What term refers to a situation where the same data is stored unnecessarily in different locations?

Question 3 of 50

Which of the following best describes an "ad hoc query"?

Question 4 of 50

Which type of database is typically focused on historical data and business metrics for decision-making?

Question 5 of 50

Which of the following ensures that data remains accurate and consistent in a relational database?

Question 6 of 50

What does the term "data independence" refer to?

Question 7 of 50

What term is used to describe a collection of related data stored in a shared, integrated computer structure?

Question 8 of 50

Which database component is responsible for storing metadata and data definitions?

Question 9 of 50

In which type of relationship does one record in a table correspond to only one record in another table?

Question 10 of 50

What is the primary role of a DBMS (Database Management System)?

Question 11 of 50

Which of the following describes an OLAP system?

Question 12 of 50

What is a key characteristic of a distributed database?

Question 13 of 50

Which of the following is a condition in which the database schema affects data access?

Question 14 of 50

What is the purpose of a primary key in a relational table?

Question 15 of 50

Which of the following is an example of a NoSQL database?

Question 16 of 50

Which of the following is the result of processing raw data?

Question 17 of 50

Which type of key contains a unique value for every row in a relational table?

Question 18 of 50

What term refers to a specific collection of logically related fields?

Question 19 of 50

Which SQL clause is used to limit the rows returned by a query?

Question 20 of 50

What does a relational database primarily use to relate data in different tables?

Question 21 of 50

What is the key characteristic of "structured data"?

Question 22 of 50

Which database system function ensures that only authorized users can access specific data?

Question 23 of 50

What type of relationship exists when a single record in one table can be related to multiple records in another table?

Question 24 of 50

In the context of data warehousing, what is a "data mart"?

Question 25 of 50

What is an entity in the context of databases?

Question 26 of 50

What is the process of transforming raw data into useful information called?

Question 27 of 50

Which SQL command is used to add a new row of data to a table?

Question 28 of 50

Which attribute type can only have a single value for each entity occurrence?

Question 29 of 50

Which type of query involves a question issued by the end user of a database using SQL?

Question 30 of 50

Which SQL command permanently removes data from a table?

Question 31 of 50

What kind of relationship describes a connection between three entities?

Question 32 of 50

Which type of key is used strictly for data retrieval purposes?

Question 33 of 50

What term describes the collection of programs that manages a relational database?

Question 34 of 50

Which of the following best describes the term "data anomaly"?

Question 35 of 50

Which database management system allows users to manage data using objects, inheritance, and classes?

Question 36 of 50

Which of the following is a representation of a relational database's entities, attributes, and relationships?

Question 37 of 50

Which SQL command is used to modify the structure of an existing table?

Question 38 of 50

What type of attribute can be subdivided into additional attributes?

Question 39 of 50

In a star schema, what type of tables are used to classify or filter facts?

Question 40 of 50

What is a NoSQL database primarily designed to handle?

Question 41 of 50

Which SQL clause groups rows that share the same values in specified columns?

Question 42 of 50

What does the term "atomicity" refer to in database transactions?

Question 43 of 50

Which SQL command undoes changes made to a database since the last commit?

Question 44 of 50

What is a key feature of a hierarchical database model?

Question 45 of 50

Which of the following is an advantage of denormalization?

Question 46 of 50

Which SQL clause is used to filter rows after an aggregation is applied using GROUP BY?

Question 47 of 50

Which entity type cannot exist without another related entity?

Question 48 of 50

What term describes an attribute that does not physically exist within the entity but can be derived?

Question 49 of 50

What is the purpose of a composite entity?

Question 50 of 50

What does the term "functional dependence" refer to?

Set 1 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 2

Struggling with WGU C175?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now