DA-100 QUESTIONS & ANSWERS 100%
CORRECT
1
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:A
2
Case Study 1 - Litware, Inc.
,Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:A
Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able
to see the
month in reports as shown in the following example: Feb 2020.
,3
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:A
4
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
, leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:B
5
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
CORRECT
1
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:A
2
Case Study 1 - Litware, Inc.
,Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:A
Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able
to see the
month in reports as shown in the following example: Feb 2020.
,3
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:A
4
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
, leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a
format of yyyymm.
The week column in the Date table and the weekid column in the Weekly_Returns table have a
format of
yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the
sales data for
negative sales amounts.
Reporting Requirements
Litware identifies the foll - Answers:B
5
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The
company plans to
leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several
other data
sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
