You have a workbook that contains one data source and you need to combine data from another database. What should you do first?

Question

Options

• ACreate an extract
• BEdit the existing connection
• CAdd a new data source from the data source canvas
• DAdd a new connection

• A
  2% (1)
• B
  7% (4)
• C
  2% (1)
• D
  89% (50)

Explanation

Adding a new connection (D) is the correct first step because it allows you to bring in data from an additional database within your existing data source, enabling you to join or union that data alongside what you already have - all in one unified data source.

Why the distractors are wrong:

• A (Create an extract): An extract saves a snapshot of your current data; it doesn't bring in new data from another database.
• B (Edit the existing connection): This modifies where your current connection points, potentially breaking your existing data rather than adding to it.
• C (Add a new data source): This creates a completely separate data source, which would require data blending rather than a direct join - a more limited and less flexible approach than combining via a shared connection.

Memory tip: Think of it as plumbing - a connection is a pipe to one database. To combine databases inside the same data source, you add another pipe (new connection) before the water reaches the tank. Adding a new data source builds a whole separate tank.

No community discussion yet for this question.