Month End Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

ExamsBrite Dumps

WGU Data Management – Foundations Exam Question and Answers

WGU Data Management – Foundations Exam

Last Update Apr 28, 2025
Total Questions : 60

We are offering FREE Data-Management-Foundations WGU exam questions. All you do is to just go and sign up. Give your details, prepare Data-Management-Foundations free exam questions and then go for complete pool of WGU Data Management – Foundations Exam test questions that will help you more.

Data-Management-Foundations pdf

Data-Management-Foundations PDF

$36.75  $104.99
 Add to Cart
Data-Management-Foundations Engine

Data-Management-Foundations Testing Engine

$43.75  $124.99
 Add to Cart
Data-Management-Foundations PDF + Engine

Data-Management-Foundations PDF + Testing Engine

$57.75  $164.99
 Add to Cart
Questions 1

Which property of an entity can become a column in a table?

Options:

A.  

Modality

B.  

Uniqueness

C.  

Attribute

D.  

Non-null values

Discussion 0
Questions 2

Which clause or statement in a CREATE statement ensures a certain range of data?

Options:

A.  

CHECK

B.  

FROM

C.  

WHERE

D.  

SET

Discussion 0
Questions 3

What is the last step in the logical design process for designing a database?

Options:

A.  

Analyze data requirements

B.  

Apply a normal form

C.  

Determine cardinality

D.  

Discover entities

Discussion 0
Questions 4

What is the role of the transaction manager within the database system architecture?

Options:

A.  

The transaction manager uses information from the catalog to perform query optimization.

B.  

The transaction manager is composed of a query processor, storage manager, transaction manager, log, and catalog.

C.  

The transaction manager logs insert, update, and delete queries, and the result is sent back to the application.

D.  

The transaction manager translates the query processor instructions into filesystem commands and uses an index to quickly locate the requested data.

Discussion 0
Questions 5

Which keyword is used to introduce a limiter in a SELECT statement?

Options:

A.  

FROM

B.  

DROP

C.  

INTO

D.  

WHERE

Discussion 0
Questions 6

Which elements are represented by attributes in the database design documents?

Options:

A.  

Synonyms

B.  

Names

C.  

Repositories

D.  

Relationships

Discussion 0
Questions 7

Which designation is an individual value, such as a salary?

Options:

A.  

Glossary

B.  

Entity type

C.  

Attribute type

D.  

Relationship

Discussion 0
Questions 8

Which relationship is shown in the following diagram?

Options:

A.  

Many-to-many

B.  

Associative entity

C.  

Unary relationship

D.  

Intersection data

Discussion 0
Questions 9

Which type of join selects all the rows from both the left and right table, regardless of match?

Options:

A.  

Full Join

B.  

Outer Join

C.  

Inner Join

D.  

Cross Join

Discussion 0
Questions 10

Which expression can be used to create a temporary name for a table?

Options:

A.  

HAVING

B.  

NEW

C.  

ALIAS

D.  

UNION

Discussion 0
Questions 11

Which primary key values consist of a single field only?

Options:

A.  

Simple

B.  

Partition

C.  

Stable

D.  

Meaningless

Discussion 0
Questions 12

Which term refers to a path from a top-level block to a bottom-level block?

Options:

A.  

Fan-out

B.  

Crow’s foot

C.  

Branch

D.  

Sparse index

Discussion 0
Questions 13

Which command is used to filter group results generated by the GROUP BY clause?

Options:

A.  

REPLACE

B.  

HAVING

C.  

WITH

D.  

WHERE

Discussion 0
Questions 14

Which type of join is demonstrated by the following query?

sql

SELECT *

FROM Make, Model

WHERE Make.ModelID = Model.ID;

Options:

A.  

NON-EQUIJOIN

B.  

SELF JOIN

C.  

EQUIJOIN

D.  

CROSS JOIN

Discussion 0
Questions 15

What is the first step of the analysis phase for designing a database?

Options:

A.  

Determine cardinality

B.  

Identify entities

C.  

Draw an entity-relationship (ER) diagram

D.  

Implement attributes

Discussion 0
Questions 16

How many bytes of storage does a BIGINT data type hold in MySQL?

Options:

A.  

1 byte

B.  

3 bytes

C.  

4 bytes

D.  

8 bytes

Discussion 0
Questions 17

Which operator defines the field that the index is using in a CREATE TABLE statement?

Options:

A.  

ON

B.  

IN

C.  

UNIQUE

D.  

CHECK

Discussion 0
Questions 18

Which statement is associated with two separate entities?

Options:

A.  

Reflexive relationship

B.  

Entity type

C.  

Relationship

D.  

Attribute

Discussion 0