Exam DP-203 topic 1 question 2 discussion

I did a test, waited for one minute and tried the query in a serverless sql pool and received 24 as the result, so I don't understand that B has been voted so much because the answer is A) 24 without a doubt

Answer is B, but not because of the lowercase. The case has nothing to do with the error. If you look attentively, you will notice that we create table mytestdb.myParquetTable, but the select statement contains the reference to table mytestdb.dbo.myParquetTable (!!! - dbo). Here is the error message I got: Error: spark_catalog requires a single-part namespace, but got [mytestdb, dbo].

Option A: dbo is the default schema where the object gets created in synapse if not specified explicitly.

Does the order of insertion doesn't matter here? As the column order is different in the table than the one used in insertion.

24 is correct answer Link : https://learn.microsoft.com/en-us/azure/synapse-analytics/metadata/table#create-a-managed-table-in-spark-and-query-from-serverless-sql-pool

As per ChatGPT, The query will fail with an error message as the table myParquetTable is created using Spark and the USING Parquet option, which means it is stored in a Parquet file format. Serverless SQL pool does not support querying Parquet files directly, so it cannot query myParquetTable in its current form. To make the table accessible from the serverless SQL pool, you need to create an external table that references the Parquet file. Then, you can query the external table instead. Assuming you have created an external table named myExternalParquetTable that references the Parquet file containing the data in myParquetTable, the query to select EmployeeID where EmployeeName is 'Alice' would be: SELECT EmployeeID FROM myExternalParquetTable WHERE EmployeeName = 'Alice';

The query will fail with an error because mytestdb.myParquetTable is a Spark table, not a SQL table. When you created the table using Spark, you used the Spark SQL syntax, and the table is stored in the Spark engine's metadata. Serverless SQL pool in Azure Synapse Analytics cannot directly query Spark tables; it can only query SQL tables. If you want to query the data stored in the mytestdb.myParquetTable table using a serverless SQL pool, you need to create an external table that maps to the same Parquet file. You can do this by using the CREATE EXTERNAL TABLE statement in a SQL pool.

Right answer is B. The query must run into Serverless SQL poll, not into Apache spark. "One minute later, you execute the following query from a serverless SQL pool in MyWorkspace." If we run that query into apache spark pool, using notebook for example, we must use "SELECT database.table". So, according the question, we must use serverless sql pool and, cause of that, we have to use "SELECT database.dbo.table" OR "use database; select table"

The given query is trying to select the EmployeeID from the Parquet table myParquetTable in the mytestdb database, where the EmployeeName is 'Alice'. However, it seems like there's a minor typo in the query. The query should be like this: SELECT EmployeeID FROM mytestdb.myParquetTable WHERE EmployeeName = 'Alice'; The given query is trying to select the EmployeeID from the Parquet table myParquetTable in the mytestdb database, where the EmployeeName is 'Alice'. However, it seems like there's a minor typo in the query. The query should be like this: sql Copy code SELECT EmployeeID FROM mytestdb.myParquetTable WHERE EmployeeName = 'Alice'; The corrected query would return: A. 24 So, the correct answer is A. The query will return the EmployeeID, which is 24.

The question is bad, the Spark database table created VIA Spark pool is not automatically generated in the SQL pool, the user should create one external table via serverless SQL pool first, the schema is not required in the external table. So whether schema dbo is needed in the 2nd query is depending on if dbo is included when creating external table.

The question is to query from Serverless to Spark. To query directly in Spark, must not use "dbo". To query from Serverless, "dbo" is required. I tested this myself just now. Correct: A.

Answer A is correct based on logic once you create a table in Spark DB it will automatically Create it under db.table for serverless so query returns the result

the right answer is A

Answer is A, because after Create a table in Spark pool the same one will be automatically created under dbo for Serverless SQL Pool. so the query returns 24

Answer A , You have inserted one row and the ID is 24 , The select query is correct so B is wrong and there is no Null value in the inserted records

Learning, unsure about answer first but after checking document, can confirm it's A. Question is nearly same example as of doc.

https://learn.microsoft.com/en-us/azure/synapse-analytics/metadata/table#examples