DA-100 무료 덤프문제 온라인 액세스

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

• A.Change the data type of the Date column to Text.
• B.Round the hour of the Date column to startOfHour.
• C.Trim the Date column.
• D.Split the Date column into two columns, one that contains only the time and another that contains only the date.

You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

What is the minimum number of datasets and storage modes required to support the reports?

• A.two DirectQuery datasets
• B.two imported datasets
• C.a single imported dataset
• D.a single DirectQuery dataset

You have a Power BI tenant.
You have reports that use financial datasets and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?

• A.dataset certifications
• B.Microsoft Intune policies
• C.sensitivity labels
• D.row-level security (RLS)

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?

• A.Create a workspace for development and a workspace for production. From the production workspace, publish an app.
• B.Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• C.In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
• D.Create one workspace for development. From the new workspace, publish an app for production.