ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

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: AB 🗳️
by cdc at May 19, 2019, 1:14 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
cdc
Highly Voted 5 years, 6 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 5 years ago
Answer is A and B.
upvoted 8 times
...
dim37
Most Recent 1 year, 3 months ago
Selected Answer: AB
The answer is ChapterID and LanguageID.
upvoted 1 times
...
OgYrKo
2 years, 5 months ago
Selected Answer: AB
A and B correct
upvoted 2 times
...
dzoni68
2 years, 6 months ago
The correct answer is A and B.
upvoted 2 times
...
mco2l
2 years, 8 months ago
Selected Answer: AB
ChapterID and LanguageID
upvoted 2 times
...
M_Ti
2 years, 10 months ago
Selected Answer: AD
Relacionamento de tabelas requer chave primária e chave estrangeita
upvoted 1 times
...
CertMeUp
4 years, 2 months ago
Answer is A and B.
upvoted 2 times
...
goodidea
4 years, 4 months ago
A and b
upvoted 1 times
...
NinjaTurtle
4 years, 9 months ago
I totally agree with cdc's explanation on the selection! A & B
upvoted 2 times
...
bcstokes
4 years, 10 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
4 years, 6 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
...
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago