Microsoft Certified: Power BI Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 2

  * Answer: - Some values in the [answer choice] column are repeated: Customer Name (Distinct = 8,390 vs Unique = 8,175 indicates duplicates in names.) - To standardize the values in the Phone column to 10 digits and exclude country calling codes: extract the text after the “)” delimiter (This removes the country code portion before the closing parenthesis.)

• 7

  1. Customer Name 2. Extract the last 12 characters -Customer Name because it has a greater number of distinct vs unique values in the column. This implies that there are repeating values in it. -Second statement requires 10 digits in the phone number. If choose "extract the text after the ")" delimiter", it will leave a leading whitespace for certain rows since there is a space after the ")" in certain rows and this counts as a digit which would make it 11 digits which does NOT meet the requirement. BUT, if we use the other option "Extract the last 12 characters", then it will NOT include the leading whitespace and correctly satisfy the 10 digit requirement as well as not including whitespace which can throw off calculations, sort orders, etc.

• 1

  correct!