exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 18 discussion

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

You attempt to connect Power BI Desktop to a Cassandra database.

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

  • A. Microsoft SQL Server database
  • B. ODBC
  • C. OLE DB
  • D. OData
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
GuerreiroJunior
Highly Voted 2 years, 3 months ago
Selected Answer: B
B is Correct because, B´cause it allows you to connect to data sources that aren't identified in the Get Data lists. The ODBC connector lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver. List details a few examples of data sources to which Power BI Desktop can connect by using the generic ODBC interface: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces
upvoted 52 times
...
Pinha
Highly Voted 2 years, 1 month ago
The anwer is B * Cassandra has an ODBC driver available that can be used to connect to the database using the ODBC connector in Power BI. * Microsoft SQL Server database is specifically designed to connect to SQL Server databases, * OLE DB is designed to connect to Microsoft databases and other third-party databases, * OData is designed to connect to web-based data sources
upvoted 35 times
...
rcaliandro
Most Recent 8 months, 2 weeks ago
Selected Answer: B
ODBC is correct
upvoted 1 times
...
Kiran37
9 months, 1 week ago
ODBC allows to connect other DB
upvoted 1 times
...
AZFabio
1 year, 1 month ago
Selected Answer: B
correct
upvoted 1 times
...
Igetmyrole
1 year, 7 months ago
B is the correct answer. ODBC (Open Database Connectivity) is a general-purpose data access that allows us to connect to a wide range of databases, including Cassandra, using ODBC drivers.
upvoted 4 times
...
Nunya101
1 year, 8 months ago
Open database connector
upvoted 1 times
...
Chenemi
1 year, 9 months ago
Selected Answer: B
odbc allows connection to third party database
upvoted 1 times
...
MoxieTT
1 year, 9 months ago
This was on the exam
upvoted 4 times
...
kayani29
1 year, 9 months ago
Given answer is correct
upvoted 1 times
...
sergeyitaly
1 year, 10 months ago
To connect Power BI Desktop to a Cassandra database when there is no specific connector available, you should choose option B: ODBC (Open Database Connectivity) connector. ODBC is a widely-used standard for connecting to various types of databases, including Cassandra. It provides a common interface that allows applications like Power BI to communicate with different database systems using the same API. By leveraging the ODBC connector, you can establish a connection to the Cassandra database and retrieve data for analysis and visualization in Power BI.
upvoted 4 times
...
inejo
1 year, 10 months ago
La respuesta es correcta :)
upvoted 1 times
...
MoxieTT
1 year, 11 months ago
Awful question. This is a prime example of why the current exam, is not fit for purpose and needs revamped. How is this relevant to the day-to-day role of a data analyst?
upvoted 10 times
Sophieeeeee
10 months ago
Totally agree. There are too many questions should be related to the data engineer instead of data analyst...I don't need to know this to provide a good analysis to solve clients' business problems...
upvoted 1 times
...
...
Shalaleh
1 year, 12 months ago
Microsoft open database connectivity
upvoted 1 times
...
Shalaleh
1 year, 12 months ago
Selected Answer: B
B is the correct answer.
upvoted 1 times
...
DUVANES
2 years, 1 month ago
Selected Answer: B
B. ODBC
upvoted 1 times
...
jsking
2 years, 3 months ago
Selected Answer: B
Answer is correct. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces
upvoted 2 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago