@Abdelhak ㅤ Correct. You can test it for yourself: CREATE TABLE [dbo].[MyTable] ( c1 INT NOT NULL, c2 INT ); ALTER TABLE [dbo].[MyTable] ADD CONSTRAINT PK_MyTable PRIMARY KEY NONCLUSTERED ([c1]) NOT ENFORCED; INSERT INTO dbo.MyTable VALUES (1, 2), (1,3)

@Nachiket Kamat I think it's because they removed that capability - and so now they just redirect the original documentation page to the semantic model relationship page 👍

@Nachiket Kamat it's for select statements mainly, so manipulation here refers to data transformations within a SELECT statement. You can do a Create Table As Select though if you want to write the output 👍 read more here: https://learn.microsoft.com/en-us/fabric/data-warehouse/visual-query-editor

Hi there Lazaro - the spreadsheet is up-to-date, I update it everytime there is a new tutorial added to the Dojo! And yes correct - if there is a blank in either column it will mean that it's unlikely to come up in that particular exam. Which ones are you talking about which are linked to in the bootcamp, but don't have ticks in that column? If so, I will update those rows 😀

@Michael Flesch Similar approach to the one mentioned in this other q/a https://www.skool.com/microsoft-fabric/quick-fire-fabric-questions-and-answers-thread?p=6149decc But instead of auto-increasing the SKU, you can set up an email 😀

@Amier musstaqim Sawalludin I don't think there's a unified logging solution yet in Fabric. There is the Monitor tab which shows the basics (each run is monitored and you can see the status of all jobs in fabric). I think what you're asking about is more of a custom solution. What I tend to do is create a separate Lakehouse to write custom logs to. It you want to maintain the raw JSON for a log, point it to the Lakehouse Files area, and then you might want to try/ take a look at the new Shortcut File Transformations which autoconverts the JSON into a structured delta table. That feature is in Preview still though, so be careful with it.

@Guram Jalagonia Hu Guram, sorry for the delay! I can't remember exactly the question, but I believe it was a Workspace Viewer, right? At the time I created the video, Workspace Viewers could execute a data pipeline, but now they've changed that setting (need to be a Contributor for that!). Run read-only t-sql scripts is still possible as a viewer.

@Bernardo Rainha Hi there Bernardo - yes you're right, whenever I screenshot something, I (try to) always link to the source, so that you can see the up-to-date version. The documentation (and your real-world experience) should always be the source-of-truth!