exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 84 discussion

Actual exam question from Microsoft's 70-761
Question #: 84
Topic #: 1
[All 70-761 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a table named Products that stores information about products your company sells. The table has a column named ListPrice that stores retail pricing information for products.
Some products are used only internally by the company. Records for these products are maintained in the Products table for inventory purposes. The price for each of these products is $0.00. Customers are not permitted to order these products.
You need to increase the list price for products that cost less than $100 by 10 percent. You must only increase pricing for products that customers are permitted to order.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Products with a price of $0.00 would also be increased.

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
humpp
5 years, 2 months ago
we should "increase the list price for products that cost less than $100, while "between and" will include 100 as well, that's why the answer is incorrect even if it is * instead of +
upvoted 3 times
...
Vanesa30
5 years, 3 months ago
no, because between include the products that are not allowed to order (0) it should be somthing like this: 'BETWEEN 1 TO 100' and 'SET LISTPRICE = LISTPRICE *1.1'
upvoted 2 times
...
anonimdom
5 years, 4 months ago
0 * 1.1 = 0, so it doesn't impact the 0 values. Looks correct to me (if there is * instead of +)
upvoted 1 times
Jiacheng
5 years, 4 months ago
The reason is not +1.1 or *1.1, main reason is for those goods whose price = 0, they are not permitted to order. The question asks us to increase price for goods which can be ordered
upvoted 3 times
Billybob0604
4 years, 5 months ago
that is incorrect, as they are in the table anyway. you simply just don't touch them when you multiply by whichever amount.
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
Loading ...