Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 20 discussion

Actual exam question from Microsoft's PL-300

Question #: 20
Topic #: 1

HOTSPOT
-

You are using Power BI Desktop to connect to an Azure SQL database.

The connection is configured as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct solution is worth one point.

Show Suggested Answer

Suggested Answer:

by Kai_don at Jan. 9, 2023, 3:02 p.m.

Comments

Submit Cancel

Sushvij

Highly Voted 2 years, 5 months ago

10min Only tables with data If navigate using full hierarchy is unchecked you can see only tables(rows n columns) with data. Otherwise you can see all tables

upvoted 76 times

CookieMingkee

1 year, 4 months ago

If you only follow the documentation from Microsoft, it is open to interpretation unless you stepped through the process. I cannot add a screenshot in this post but use the this link to use as a reference on how exactly the Navigator would look like using with the "Navigate using full hierarchy" is checked and unchecked. I connected to an Azure SQL Database with tables containing data and others are blank. Marking the "Navigate using full hierarchy" will list the Schemas first and the hierarchy for each object under each schema (e.g. dbo, db_onwer, etc.). Unmarking the "Navigate using full hierarchy" will show all the tables whether with data or without data.

upvoted 9 times

...

GuerreiroJunior

Highly Voted 2 years, 5 months ago

The defaut time out is 10 minutes, but if it takes more than it you can enter another value in minutes to keep the connection open longer. 1. 10 minutes 2. All the tables Reference: https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase

upvoted 31 times

Mo2011

1 year, 1 month ago

Wrong, as per Microsoft-> If cleared, the navigator displays only the tables whose columns and rows contain data (copied from MS)

upvoted 6 times

...

RedRoss

1 year, 3 months ago

it says in your reference link for "Navigate using full hierarchy" : If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. Which means, it'll only show the tables with data and not all tables.

upvoted 6 times

...

Hansen_G

2 years, 5 months ago

Navigate using full hierarchy is unchecked. Only table with data will be displayed.

upvoted 15 times

...

ppt_powerbi

2 years, 5 months ago

Only tables with data. From your reference link, under Connect using advanced options, it clearly shows that "Navigate using full hierarchy If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data."

upvoted 30 times

Throneroom

2 years, 2 months ago

True, I have seen it

upvoted 3 times

...

Load full discussion...

...

BP215

Most Recent 1 month, 3 weeks ago

Correct answer

upvoted 1 times

...

627628c

5 months, 1 week ago

10 Minutes Only tables with data Per Microsoft Learn: "Navigate using full hierarchy - If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data." https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database

upvoted 2 times

...

rcaliandro

10 months, 2 weeks ago

10 minutes, only tables that contain data

upvoted 1 times

...

Kiran37

11 months, 1 week ago

correct answer

upvoted 1 times

...

Jane97

1 year ago

10 MINUTES ONLY TABLES WITH DATA

upvoted 1 times

...

SilentAnalyst

1 year, 4 months ago

The solution is correct. 10 minutes default timeout Only tables that contain data reference to https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database

upvoted 4 times

...

WRTopics

1 year, 8 months ago

10 Min. All Tables. I work with DirectQuery in my job.

upvoted 2 times

...

Ibritics

1 year, 9 months ago

and what does fialeover do?

upvoted 2 times

...

Igetmyrole

1 year, 9 months ago

The correct answers are: ** 10 minutes . The default timeout for the connection from Power BI Desktop to Azure SQL database is 10 minutes. ** All the tables : the navigator will display all the tables available in the specified database, regardless of whether they contain data or hierarchies.

upvoted 2 times

...

Unzi_

1 year, 10 months ago

Correct!: Command timeout in minutes: If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop. Navigate using full hierarchy: If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. Include relationship columns: If checked, includes columns that might have relationships to other tables. If this box is cleared, you won’t see those columns. https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database

upvoted 4 times

...

Bamlaku

1 year, 10 months ago

Answer is correct: 10 minutes (default) Only tables with Data Navigate using full hierarchy: If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database

upvoted 6 times

...

Makaroni

1 year, 11 months ago

Is the answer ALL Tables or Only tables that contain data? I think the real confusing is there?

upvoted 2 times

...

ahhida

2 years, 1 month ago

Yes answer is 10 min , only tables with data as this is azure sql server not on premises sql server https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database

upvoted 4 times

...

SanaCanada

2 years, 1 month ago

Please ignore my first answer, after reviewing in detail Correct answer is 10 Minutes and Only Table with Data If "Navigate using full hierarchy" is unchecked in the Fields pane in Power BI Desktop, then only the tables and fields that contain data will be displayed in the report view. Any tables or fields that do not have data will be hidden from view. However, it's important to note that this option controls the behavior of the Fields pane in the report view, and does not affect the data that is loaded into the report. Even if the option is unchecked, all tables and fields in the data model will still be available for use in the report. They just won't be visible in the Fields pane unless they contain data. So, if you want to ensure that only the tables and fields with data are shown in the report view, you can uncheck "Navigate using full hierarchy" in the Fields pane. But if you want to include all tables and fields in the data model, even if they don't currently contain data, you should leave the option checked.

upvoted 5 times

...

SanaCanada

2 years, 1 month ago

So, if you want to ensure that only the tables and fields with data are shown in the report view, you can uncheck "Navigate using full hierarchy" in the Fields pane. But if you want to include all tables and fields in the data model, even if they don't currently contain data, you should leave the option checked.

upvoted 1 times

...

Load full discussion...