16_Creating a Report Using the Report Builder Quiz

What is the component of SQL Server Reporting Services used to create custom reports?

• SSCM Site Database

• Configuration Manager

• SQL Server Management Studio

• Report Builder

Answer explanation

The component of SQL Server Reporting Services used to create custom reports is Report Builder.

What is the URL of the report server mentioned in the text?

• httpsccm-nug/reportserver

• https://sqlserver/reportbuilder

• https://configmanager/reports

• https://fileserver/reportbuilder

Answer explanation

The correct URL of the report server mentioned in the text is httpsccm-nug/reportserver.

Which view is used to create a report around site distribution points?

• V distribution points

• V site codes

• V server names

• V report builder

Answer explanation

The correct view used to create a report around site distribution points is 'V distribution points'. This view specifically focuses on distribution points within the site.

What type of authentication is used for the SQL Server connection in the text?

• LDAP Authentication

• SQL Authentication

• Windows Authentication

• OAuth Authentication

Answer explanation

The correct type of authentication used for the SQL Server connection in the text is Windows Authentication.

What is the name of the data set created for the report in the text?

• DS Report

• DS DP

• DS SQL

• DS SCCM

Answer explanation

The name of the data set created for the report in the text is 'DS DP', as mentioned in the answer choices. Therefore, the correct choice is 'DS DP'.

Which layout option is chosen for the report in the text?

• Subtotals and Grandtotals

• Aggregates and Totals

• Hierarchical Layout

• Tabular Layout

Answer explanation

The correct layout option chosen for the report in the text is Subtotals and Grandtotals, as indicated in the answer choices.

What is added to the report to provide a visual element?

• Graph

• Chart

• Table

• Image

Answer explanation

To provide a visual element, an image is added to the report. Images can enhance the presentation and make the report more engaging for the audience.

What is the title of the custom report created in the text?

• Custom SQL Report

• Configuration Manager Report

• Site Distribution Report

• SCCM Site Database Report

Answer explanation

The title of the custom report created in the text is the Site Distribution Report, as mentioned in the answer choices.

Which tab is used to enable PXE for a distribution point in Configuration Manager?

• PXE

• General

• Properties

• Security

Answer explanation

The correct tab to enable PXE for a distribution point in Configuration Manager is the 'PXE' tab.

What is the default value set for the SMS site code filter in the report?

• 123

• ABC

• XYZ

• NUG

Answer explanation

The default value set for the SMS site code filter in the report is 'NUG'. Therefore, the correct answer is NUG.