اضغط هنا للانضمام الى قروب فوجي للإختبارات على تيليقرام

اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

السؤال 19 من 50

كل الأسئلة

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.

Sheet1 contains the following table named Table1:
Products:

abc
def
ghi
jkl
mno

Sheet2 contains the following table named Table2:
Products:

abc
xyz
tuv
mno
pqr
stu

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

Products:

abc
def
ghi
jkl
mno
xyz
tuv
pqr
stu

Which three actions should you perform in sequence?

الخيارات

  • A From Power BI Desktop, import the data from Excel, and select Table1 and Table2.
  • B From Power Query Editor, append Table2 to Table1.
  • C From Power Query Editor, select Table1, and then select Remove duplicates.

النقاشات

لا توجد نقاشات منشورة لهذا السؤال حالياً.