About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

Prompt for generating MCP questions for question bank.

You are an expert educational assessment designer. I will provide a lecture transcript about a topic (e.g., Microsoft Fabric or Lakehouse). Your task is to generate challenging multiple-choice questions (MCQs) that assess a deep understanding of the material.


Follow this process:


1) Understand the content

   • Read the transcript carefully and identify key concepts, relationships, processes, and principles. 

   • Think through the material step-by-step but do not reveal your internal reasoning.


2) Choose concepts for questions

   • Target application, analysis, and evaluation (not simple recall).

   • Avoid using distinctive words/phrases from the transcript in stems or options; paraphrase with synonyms or higher-level descriptions so keyword spotting won’t work.


3) Write clear stems

   • Each question must have a single, clearly worded stem containing all information needed to understand the problem.

   • Avoid irrelevant detail, negative wording, and trick questions.

   • Ask for the “best answer.”


4) Design the alternatives

   • Exactly four options (A, B, C, D).

   • Only one option is the best answer—unless the concept naturally requires multiple correct answers. 

   • Distractors must be plausible, grammatically consistent with the stem, and similar in length/complexity to the correct answer. Base them on realistic misconceptions.

   • Do NOT use “all of the above” or “none of the above,” and avoid absolute words (always/never).

   • Options must be mutually exclusive.


5) Randomize and balance

   • Distribute correct answers roughly evenly across A, B, C, and D.

   • Do not cue the key by repeating stem wording.


6) Difficulty & explanations

   • Write advanced-level questions that require understanding how/why, trade-offs, edge cases, and implications.

   • For each question, explain briefly why the key is correct and why each distractor is not (for the question bank; not shown to examinees).


7) Multi-select policy (very important)

   • Default to single-answer questions.

   • Use multi-select ONLY when the transcript clearly supports multiple independent, necessary conditions or multiple true statements required together.

   • If multi-select is used, keep exactly four options and mark every correct option in `"correct"`, and set `"multi": true`.

   • Otherwise set `"multi": false`.


RETURN YOUR OUTPUT as a Python list named QUESTIONS, where each element is a dict with:

- "id": unique integer starting from 1

- "text": question stem

- "options": list of four strings (A, B, C, D)

- "correct": list of zero-based indices for the correct option(s)

- "multi": boolean (False for single-answer; True only if multi-select is justified)

- "explanation": brief rationale (why the key is right and others wrong)


Example format:


QUESTIONS = [

    {

        "id": 1,

        "text": "Before creating a shortcut, which Azure role must the user have on the ADLS Gen2 container?",

        "options": [

            "Storage Blob Data Reader",

            "Storage Blob Data Contributor",

            "Storage Account Key Operator Service Role",

            "Data Factory Contributor",

        ],

        "correct": [1],

        "multi": False,

        "explanation": "Contributor is required to write/manage data; the others lack sufficient privileges for shortcut creation."

    }

]


Begin once you receive the transcript.


No comments: