Examen
PL-300 EXAM SAMPLES POWERBI QUESTIONS AND ANSWERS
- Cours
- Établissement
PL-300 EXAM SAMPLES POWERBI QUESTIONS AND ANSWERS
[Montrer plus]
Vendeur
S'abonner
selftest
Avis reçus
Aperçu du contenu
Name: Score:150 Multiple choice questions
,Term 1 of 150
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query
Editor.
You need to identify outliers in a text column within the data source.
Which information should you use from Power Query Editor?
Select only one answer.
1. the min and max values in Column profile
2. the top and bottom entries in Value distribution
3. the value of the Distinct entry in Column statistics
4. the value of the Unique entry in Column statistics
2
(MS)
Using Dual mode means that either an import query can be run when accessing data
from FactStoreSales, or a DirectQuery query can be run when accessing data from
FactOnlineSales.
Using Import mode means the queries are only optimized for FactStoreSales (Import).
Using DirectQuery mode means the queries are only optimized for FactOnlineSales
(DirectQuery).
A storage mode of Import, DirectQuery, or Dual must be assigned.
2
(MS)
The error message indicates that the Excel workbook does not contain a table. To create
it, in the Excel workbook, you need to select the data you want to import, press Ctrl+T or
choose the Table button, click OK and save the change.
Using the Data Validation button in Excel does not create a table.
Organizational and template apps provide a way to implement functionality within Power
BI, but, in this case, the issue is caused by an absence of a table in the Excel workbook,
so installing an app would have no effect on resolving the issue.
2
(MS)
The top and bottom entries in Value distribution identify outliers, which appear,
respectively, the greatest and the smallest number of times in that column.
,The value of the Distinct entry in Column statistics indicates the total count of different
values.
The value of the Unique entry in Column statistics indicates the total count of different
values that appear only once.
The min and max values in the Column profile of a text column designate the entries
which appear, respectively, first and last in alphabetical order.
1,2
(MS)
Adding synonyms to model fields will help users search for them. For example, you can
give a synonym of (Actuals) for the (Sales) measure.
A linguistic schema describes terms and phrases that Q&A should understand for
objects within a dataset, including parts of speech, synonyms, and phrasings that relate
to that dataset.
Composite models are not supported by Q&A today. Organizing fields by display folders
will not impact Q&A search capabilities.
, Term 2 of 150
You have a Power BI report that uses a dataset that is imported from a database.
You add a slicer to a report.
You need to sync the slicer to use it on other report pages.
What is required to sync slicers between report pages?
Select only one answer.
1 Each slicer must be the same slicer type.
2 Each slicer must be visible.
3 Each slicer must have the same title.
4 Each slicer must use the same column.
4
(MS)
The Performance analyzer will show the query timings for each object on a report page.
Session diagnostics measures Power Query query performance as it relates to refresh
times. It is unrelated to measuring DAX performance or report page query timings.
The Best Practices analyzer reviews the model for best practices around things like
model design, relationships, field naming conventions, and measures. But is unrelated to
any query timings for report page visuals.
2.
(MS)
By default, column profiling is only based on the first 1000 rows of the preview.
Changing the column profile status to entire dataset will query the entire dataset for the
column profiling information.
4
(MS)
The same column must be used in each slicer for them to recognize each other in the
sync slicers settings.
Slicers can sync even when hidden. Slicers do not need to be the same slicer type. One
slicer could be a list, and the other a dropdown. Slicers do not need the same title to
allow them to be synced.
3
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur selftest. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €8,53. Vous n'êtes lié à rien après votre achat.
Peut-on faire confiance à Stuvia ?
4.6 étoiles sur Google & Trustpilot (+1000 avis)
84669 résumés ont été vendus ces 30 derniers jours
Fondée en 2010, la référence pour acheter des résumés depuis déjà 14 ans