Exam 70-761 topic 1 question 178 discussion

Actual exam question from Microsoft's 70-761

Question #: 178
Topic #: 1

SIMULATION -
You have a database that includes the following tables. All of the tables are in the Production schema.

You need to create a query that returns a list of product names for all products in the Beverages category.
Construct the query using the following guidelines:
✑ Use the first letter of the table name as the table alias.
✑ Use two-part column names.
✑ Do not surround object names with square brackets.
✑ Do not use implicit joins.
✑ Do not use variables.
✑ Use single quotes to surround literal values.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.

Show Suggested Answer

Suggested Answer: See the explanation below.
1. SELECT p.productname
2. FROM Production.Categories As c
3. JOIN Production.Products As p
ON ( c.categoryid = p.categoryid )
4. WHERE c.categoryname = 'Beverages'
References:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-2017

by xd1 at April 16, 2020, 7:56 a.m.