Database Management > A-Level Question Paper > CCPR Study Workbook Questions 696 Questions with 100- Correct Answers (All)

CCPR Study Workbook Questions 696 Questions with 100- Correct Answers

Document Content and Description Below

QUESTION 83 You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd. You create a new Power... BI Desktop model that uses 120 tables from SQLDev. You plan to publish the Power BI file to the Power BI service. You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort. What should you do from Query Editor before you publish the model? A. Create a new connection to SQLProd, and then import the tables from SQLProd. B. Delete the existing queries, and then add new data sources. C. Configure the Data source settings. D. Edit the source of each table query. Answer: D Explanation: QUESTION 84 You have a Power BI model that has a date table. A sample of the data shown in the following table. You need to add a column to display the date in the format of December 01, 2014. Which DAX formula should you use in Power BI Desktop? A. FORMAT([Date], “MMM”) & ” ” & FORMAT([Date], “DO”) & “, ” & FORMAT([Date], “YYYY”) B. FORMAT([Date], “MM”) & ” ” & FORMAT([Date], “DO”) & “, ” & FORMAT([Date], “YYYY”) C. [Date].[Month] & ” ” & FORMAT([Date], “D”) & “, ” & [Date].[Year]) D. FORMAT([Date], “MMMM DO, YYYY”) [Show More]

Last updated: 1 year ago

Preview 1 out of 7 pages

Buy Now

Instant download

We Accept: