Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

Exam 98-364 topic 1 question 107 discussion

Actual exam question from Microsoft's 98-364
Question #: 107
Topic #: 1
[All 98-364 Questions]

You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:

You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)

  • A. ChapterId
  • B. LanguageId
  • C. Country
  • D. Region
  • E. City
  • F. LanguageName
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by cdc at May 19, 2019, 1:14 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
cdc
Highly Voted 4 years, 11 months ago
The answer is ChapterID and LanguageID. To create a relationship between the Chapter table and the Language table, we would create the table ChapterLanguage with a composite primary key of (ChapterID, LanguageID). ChapterID would then serve ad the foreign key reference back to the Chapter table and LanguageID would serve as the foreign key reference back to the Language table.
upvoted 36 times
...
Pryns
Highly Voted 4 years, 5 months ago
Answer is A and B.
upvoted 8 times
...
dim37
Most Recent 7 months, 3 weeks ago
Selected Answer: AB
The answer is ChapterID and LanguageID.
upvoted 1 times
...
OgYrKo
1 year, 9 months ago
Selected Answer: AB
A and B correct
upvoted 2 times
...
dzoni68
1 year, 10 months ago
The correct answer is A and B.
upvoted 2 times
...
mco2l
2 years ago
Selected Answer: AB
ChapterID and LanguageID
upvoted 2 times
...
M_Ti
2 years, 2 months ago
Selected Answer: AD
Relacionamento de tabelas requer chave primária e chave estrangeita
upvoted 1 times
...
CertMeUp
3 years, 6 months ago
Answer is A and B.
upvoted 2 times
...
goodidea
3 years, 8 months ago
A and b
upvoted 1 times
...
NinjaTurtle
4 years, 1 month ago
I totally agree with cdc's explanation on the selection! A & B
upvoted 2 times
...
bcstokes
4 years, 2 months ago
It is ChapterID and LanguageID. City and language are mutually exclusive. CREATE TABLE ChapterLanguage ( ID INT NOT NULL PRIMARY KEY IDENTITY (1,1), ChapterID INT NOT NULL FOREIGN KEY REFERENCES Chapter (ID), LanguageID INT NOT NULL FOREIGN KEY REFERENCES Language (ID) ); I'm wondering if this is the result of a scan or other machine-generated process. There are not only misspellings but wrong answers that are obvious even to a novice like me.
upvoted 6 times
Jovial
3 years, 10 months ago
shouldnt it be as follows CREATE TABLE CHAPTERLANGUAGE ( CHAPTERID INT NOT NULL, LANGUAGEID INT NOT NULL, CONSTRAINT PK_CHAPTERLANGUAGE PRIMARY KEY CLUSTERED(CHAPTERID,LANGUAGEID) ); ALTER TABLE CHAPTERLANGUAGE ADD CONSTRAINT FK_CHAPTERLANGUAGE FOREIGN KEY (CHAPTERID) REFERENCES CHAPTER(CHAPTERID); ALTER TABLE CHAPTERLANGUAGE ADD CONSTRAINT FK_CHAPTERLANGUAGE2 FOREIGN KEY (LANGUAGEID) REFERENCES LANGUAGE(LANGUAGEID); meaning primary composite key on chapter id and language id
upvoted 1 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel