exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 83 discussion

Actual exam question from Microsoft's 70-761
Question #: 83
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
Dieter
Highly Voted 5 years, 10 months ago
In addition, the calculation is not correct... +1.1 is not an increase by 10%
upvoted 14 times
daniel_yes23
5 years, 2 months ago
Dieter you are right, that will make 101.1 because is addition, to increase it with 10% should be * 1.1
upvoted 2 times
...
...
Billybob0604
Most Recent 4 years, 5 months ago
If there's a * instead of a +, the answer is A. 0 stays 0 when you multiply it by whichever amount. No need to exclude these products, since their prices are listed 0.
upvoted 1 times
...
mamarach
5 years ago
List price = list price + (10%*list price)
upvoted 3 times
...
Vanesa30
5 years, 3 months ago
the calculation is not correct, ti shoulb be ListPrice =ListPrice *1.1. Inaddition to this, it's missing some field that specify the state of the product, something like that and StateProduct = 1
upvoted 1 times
Vanesa30
5 years, 3 months ago
in this case it would be 'AND ListPrice <>0.00
upvoted 1 times
jacenty
4 years, 8 months ago
I think if you use <>0.00 then You will update also prices above 100
upvoted 1 times
...
...
...
anonimdom
5 years, 5 months ago
0 * 1.1 = 0, so it doesn't impact the 0 values. Looks correct to me (if there is * instead of +)
upvoted 4 times
...
BenAsare
5 years, 7 months ago
It is absolutely fine! (100%+10%=110%)=1.1
upvoted 1 times
fe
5 years, 6 months ago
It must be * 1.1 then, not +
upvoted 8 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 ...