exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 131 discussion

Actual exam question from Microsoft's 70-761
Question #: 131
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: A 🗳️
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-2017

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
Billybob0604
4 years, 5 months ago
Answer is B. There could be list prices lower than 0.01 which you exclude from the raise
upvoted 1 times
...
ellyg
4 years, 5 months ago
sure answer is A
upvoted 1 times
...
SimSql
4 years, 6 months ago
One can ask are the customers allowed to by a product that costs .001 ?
upvoted 1 times
...
SimSql
4 years, 6 months ago
Sorry I mean the numbers between 0.001 and 0.01. Actually these would be items that cost less than a penny. The mathematical aspect of it does make sense though!
upvoted 1 times
...
SimSql
4 years, 6 months ago
The answer is B. Think about those items that cost any where b/n a penny and a dime i.e. (0.01 to 0.1). This numbers are logically in the $0.0 to $100.00 range. They can't logically be neglected but the code excludes them, therefore it is not a solution. B is the correct answer.
upvoted 1 times
...
A_Cieluch
4 years, 9 months ago
Imo this is highly dependent on the data type of list pice. If it is money, then the anwser is A but if it is a decimal(18,3) for example, the anwser would be B.
upvoted 2 times
...
Oooo
4 years, 9 months ago
what is the cost of any product is 99.9998 or what if the cost of the product is 0.001? It wouldn't be considered in the limit of .1 to 99.99. The correct way to address this would be listprice >0 and listprice<100.
upvoted 2 times
sunz_1
4 years, 9 months ago
MONEY type decimal 2
upvoted 1 times
Hoglet
4 years, 6 months ago
MONEY goes to 4 decimal places, not 2.
upvoted 1 times
...
...
...
Minsire
4 years, 10 months ago
10 percent is 0.1 not 1.1
upvoted 1 times
Minsire
4 years, 9 months ago
Sorry DacPV is correct
upvoted 1 times
...
Hoglet
4 years, 6 months ago
If you want to set to 10%, then listprice * 0.1, but we want to INCREASE by 10%, so listprice * 1.1
upvoted 1 times
...
...
chaoxes
4 years, 11 months ago
A. Yes is correct. It won't update listprice =0 and listprice = 100
upvoted 1 times
...
DacPV
5 years, 3 months ago
list price*1.1=list price + list price*10% ==> A is correct
upvoted 3 times
...
supermario
5 years, 3 months ago
This is the only correct list price increase query. listprice=list price*1.1
upvoted 2 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 ...