Sophia Database
MILESTONE 1 RETAKE GUIDE
Southern New Hampshire University
Actual Questions & Verified Answers with Rationales
100% Guarantee Pass
,5/31/22, 7:50 AM Sophia :: Welcome
Score 30/36
30/36 that's 83%
Retake
30 questions were answered correctly.
5 questions were answered incorrectly.
1 question was skipped. These were marked incorrect.
Milestone Tips
Remember that Milestones are open-book.
Take the Practice Milestone before taking the Milestone.
Take the Milestone at a time and in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Milestone Retake
UNIT 1 — MILESTONE 1
You are allowed one retake per Milestone.
The retake score will replace your original score.
Make sure you're ready. Review our list of Milestone Tips.
Retake Now Maybe Later
Milestone Retake
Before you begin, please make sure you're in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Begin Retake
Cancel
1. Milestone Retakes
Sophia allows one retake per Milestone. If you ever want to retake a Milestone, click this button.
Got it
1
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14431601 1/30
,5/31/22, 7:50 AM Sophia :: Welcome
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Using the WHERE clause, filter the employee table to include individuals that live in Edmonton.
Identify the title of the individual(s) listed.
Sales Support Agent
IT Sales Manager
Andrew
General Manager
RATIONALE
Common mistakes when using a WHERE clause include using the wrong inequality operator, filtering on the
wrong column of data, using the wrong data table, omitting the single quotes on string data, and forgetting that
string data is case sensitive.
CONCEPT
WHERE to Filter Data
Report an issue with this question
Reported. Thanks for your feedback.
2
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Using the GROUP BY and HAVING clauses, filter the customer table by country.
How many countries have more than 3 customers?
18
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14431601 2/30
, 5/31/22, 7:50 AM Sophia :: Welcome
6
5
7
RATIONALE
Common mistakes when using the HAVING clause with the GROUP BY clause in a SELECT statement
include: not using aggregate functions in the SELECT clause; not including each column in the SELECT clause
in the GROUP BY clause; using the incorrect aggregate function; and incorrectly including the filter in the
WHERE clause instead of the HAVING clause.
CONCEPT
HAVING to Filter On Aggregates
Report an issue with this question
Reported. Thanks for your feedback.
3
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Which of these constraints verifies that data in a column is based on columns in other tables?
FOREIGN KEY
PRIMARY KEY
UNIQUE
CHECK
RATIONALE
The foreign key constraint ensures that the data entered in the column is based on columns in other tables and
must exist.
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14431601 3/30
MILESTONE 1 RETAKE GUIDE
Southern New Hampshire University
Actual Questions & Verified Answers with Rationales
100% Guarantee Pass
,5/31/22, 7:50 AM Sophia :: Welcome
Score 30/36
30/36 that's 83%
Retake
30 questions were answered correctly.
5 questions were answered incorrectly.
1 question was skipped. These were marked incorrect.
Milestone Tips
Remember that Milestones are open-book.
Take the Practice Milestone before taking the Milestone.
Take the Milestone at a time and in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Milestone Retake
UNIT 1 — MILESTONE 1
You are allowed one retake per Milestone.
The retake score will replace your original score.
Make sure you're ready. Review our list of Milestone Tips.
Retake Now Maybe Later
Milestone Retake
Before you begin, please make sure you're in a place where you can be focused and undisturbed for the entire
Milestone time limit.
Begin Retake
Cancel
1. Milestone Retakes
Sophia allows one retake per Milestone. If you ever want to retake a Milestone, click this button.
Got it
1
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14431601 1/30
,5/31/22, 7:50 AM Sophia :: Welcome
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Using the WHERE clause, filter the employee table to include individuals that live in Edmonton.
Identify the title of the individual(s) listed.
Sales Support Agent
IT Sales Manager
Andrew
General Manager
RATIONALE
Common mistakes when using a WHERE clause include using the wrong inequality operator, filtering on the
wrong column of data, using the wrong data table, omitting the single quotes on string data, and forgetting that
string data is case sensitive.
CONCEPT
WHERE to Filter Data
Report an issue with this question
Reported. Thanks for your feedback.
2
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Using the GROUP BY and HAVING clauses, filter the customer table by country.
How many countries have more than 3 customers?
18
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14431601 2/30
, 5/31/22, 7:50 AM Sophia :: Welcome
6
5
7
RATIONALE
Common mistakes when using the HAVING clause with the GROUP BY clause in a SELECT statement
include: not using aggregate functions in the SELECT clause; not including each column in the SELECT clause
in the GROUP BY clause; using the incorrect aggregate function; and incorrectly including the filter in the
WHERE clause instead of the HAVING clause.
CONCEPT
HAVING to Filter On Aggregates
Report an issue with this question
Reported. Thanks for your feedback.
3
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Which of these constraints verifies that data in a column is based on columns in other tables?
FOREIGN KEY
PRIMARY KEY
UNIQUE
CHECK
RATIONALE
The foreign key constraint ensures that the data entered in the column is based on columns in other tables and
must exist.
https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/14431601 3/30
