I want to read XML from drive path using SQL Query in table format

I want to read XML from drive path using SQL Query in table format. below is my XML code :

in below code, I have face issue in split records from option id, QuestionID as attached below.PNG.

I have this type of many XML which are I want to dump in the database directly.

<Root>
  <DeviceType>A</DeviceType>
  <PregnancyId>1</PregnancyId>
  <Questions>
    <Question>
      <QuestionId>1</QuestionId>
      <QuestionInputTypeId>1</QuestionInputTypeId>
      <SubQuestionId>0</SubQuestionId>
      <Options>
        <Option>
          <DropdownOptionId>0</DropdownOptionId>
          <OptionId>5</OptionId>
          <OptionValue>Very good</OptionValue>
        </Option>
        <Option>
          <DropdownOptionId>0</DropdownOptionId>
          <OptionId>6</OptionId>
          <OptionValue>Very good</OptionValue>
        </Option>
      </Options>
    </Question>
    <Question>
      <QuestionId>2</QuestionId>
      <QuestionInputTypeId>1</QuestionInputTypeId>
      <SubQuestionId>0</SubQuestionId>
      <Options>
        <Option>
          <DropdownOptionId>0</DropdownOptionId>
          <OptionId>7</OptionId>
          <OptionValue>Life, in general</OptionValue>
        </Option>
      </Options>
    </Question>
  </Questions>
  <QuizTypeId>5</QuizTypeId>
  <UserId>10</UserId>
</Root>

I have prepared below query but not getting exact output.

DECLARE @XMLwithOpenXML TABLE
(
Id INT IDENTITY PRIMARY KEY,
XMLData XML,
LoadedDateTime DATETIME
)


INSERT INTO @XMLwithOpenXML(XMLData, LoadedDateTime)
SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE() 
FROM OPENROWSET(BULK 'D:\new_6.xml', SINGLE_BLOB) AS x;

SELECT * FROM @XMLwithOpenXML

DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)
SELECT @XML = XMLData FROM @XMLwithOpenXML
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML



SELECT DeviceType,   PregnancyId,  QuestionId,   QuestionInputTypeId, 
SubQuestionId,       DropdownOptionId,    OptionId,     OptionValue,  
QuizTypeId,   UserId

FROM OPENXML(@hDoc, 'Root/DeviceType')
WITH 
(
DeviceType                        varchar(200) '../DeviceType',
PregnancyId                       varchar(200) '../PregnancyId',
QuestionId                        varchar(200) 'QuestionId',
QuestionInputTypeId        varchar(200) 'QuestionInputTypeId',
SubQuestionId              varchar(200) 'SubQuestionId',
DropdownOptionId           varchar(200) 'DropdownOptionId',
OptionId                          varchar(200) 'OptionId',
OptionValue                       varchar(200) 'OptionValue',
QuizTypeId                        varchar(200) 'QuizTypeId',
UserId                   varchar(200) 'UserId'
)
EXEC sp_xml_removedocument @hDoc
GO

I want the output in SQL as below :