exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 85 discussion

Actual exam question from Microsoft's 70-761
Question #: 85
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 between $0.00 and $100 will be increased, while products with a price of $0.00 would not 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
Vanesa30
Highly Voted 5 years, 3 months ago
I think the between is ok but the 'SET ListPrice=ListPrice +1' is wrong because it just add a 1.1 for all products
upvoted 7 times
...
Dieter
Highly Voted 5 years, 10 months ago
The calculation is not the required (+ 10%)
upvoted 6 times
...
Billybob0604
Most Recent 4 years, 5 months ago
hang on. this is B because this calculation excludes prices of for instance 0.05 which is a valid customer price.
upvoted 2 times
...
Billybob0604
4 years, 5 months ago
something is wrong with the question and the answer. I think the core thing that they want you to do is to exclude the 0 priced articles anyway
upvoted 1 times
...
BabyBee
4 years, 7 months ago
The between will work, but the mathematical operation is incorrect. B is the correct answer. ;DECLARE @numbers AS TABLE (number float) INSERT INTO @numbers VALUES (0), (0.5), (1), (2), (3), (50), (85), (90), (99.99), (100) SELECT number FROM @numbers WHERE number BETWEEN 0.1 AND 99.99
upvoted 2 times
...
Oooo
4 years, 9 months ago
If the + sign is just a typo then answer is A(Yes).
upvoted 3 times
...
shumba1993
5 years ago
Answer B. No. ListPrice = Listprice + 1.1, Incorrect. ListPrice = ListPrice + 0.1, (0.1 = 10%) to keep + operator, ListPrice = Listprice * 1.1, keep 1.1 but change operator
upvoted 2 times
...
Shanuramasubbu
5 years, 4 months ago
The Listprice should be multiplied by 1.1 and should not be added I think.
upvoted 6 times
...
raja1234567890
5 years, 7 months ago
I think its meet the goal by not updating amount as $0
upvoted 5 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 ...