nerdexam
Amazon

DBS-C01 · Question #262

A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics. The company wants to migrate the database to the AWS Cloud…

The correct answer is B. Use Amazon Redshift for relational data and JSON data. https://docs.aws.amazon.com/redshift/latest/dg/super-overview.htm

Submitted by kevin_r· Mar 6, 2026Workload-Specific Database Design

Question

A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics. The company wants to migrate the database to the AWS Cloud. Database specialist must choose one or more AWS services to run the company's workloads. Which solution will meet these requirements in the MOST operationally efficient manner?

Options

  • AUse Amazon Redshift for relational data. Use Amazon DynamoDB for JSON data
  • BUse Amazon Redshift for relational data and JSON data.
  • CUse Amazon RDS for relational data. Use Amazon Neptune for JSON data
  • DUse Amazon Redshift for relational data. Use Amazon S3 for JSON data.

How the community answered

(58 responses)
  • A
    3% (2)
  • B
    84% (49)
  • C
    9% (5)
  • D
    3% (2)

Explanation

https://docs.aws.amazon.com/redshift/latest/dg/super-overview.htm

Topics

#SQL Server migration#relational data#JSON data#advanced analytics#Amazon Redshift

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice