Exam PL-300 topic 1 question 18 discussion

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

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

Oh my god this is such a random, increbily specific and difficult question to answer, how many people will actually know this? this is nonsense

B is correct

ODBC is correct

ODBC allows to connect other DB

correct

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.

Open database connector

odbc allows connection to third party database

This was on the exam

Given answer is correct

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.

La respuesta es correcta :)

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?

Microsoft open database connectivity

B is the correct answer.