ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 20 discussion

Actual exam question from Microsoft's PL-300
Question #: 20
Topic #: 1
[All PL-300 Questions]

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 Hide Answer
Suggested Answer:
by Kai_don at Jan. 9, 2023, 3:02 p.m.

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
Submit Cancel
Sushvij
Highly Voted 2 years, 3 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 75 times
CookieMingkee
1 year, 2 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, 3 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
11 months, 1 week ago
Wrong, as per Microsoft-> If cleared, the navigator displays only the tables whose columns and rows contain data (copied from MS)
upvoted 5 times
...
RedRoss
1 year, 1 month 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, 3 months ago
Navigate using full hierarchy is unchecked. Only table with data will be displayed.
upvoted 15 times
...
ppt_powerbi
2 years, 3 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 ago
True, I have seen it
upvoted 3 times
...
...
Load full discussion...
...
627628c
Most Recent 3 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
8 months, 2 weeks ago
10 minutes, only tables that contain data
upvoted 1 times
...
Kiran37
9 months, 1 week ago
correct answer
upvoted 1 times
...
Jane97
10 months, 1 week ago
10 MINUTES ONLY TABLES WITH DATA
upvoted 1 times
...
SilentAnalyst
1 year, 2 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, 6 months ago
10 Min. All Tables. I work with DirectQuery in my job.
upvoted 2 times
...
Ibritics
1 year, 7 months ago
and what does fialeover do?
upvoted 2 times
...
Igetmyrole
1 year, 7 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, 8 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, 8 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, 9 months ago
Is the answer ALL Tables or Only tables that contain data? I think the real confusing is there?
upvoted 2 times
...
ahhida
1 year, 11 months 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
1 year, 11 months 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
1 year, 11 months 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
...
Shalaleh
1 year, 11 months ago
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 1 times
Shalaleh
1 year, 11 months ago
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.
upvoted 1 times
...
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago