You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point. A. T-SQL B. DAX EC. C. Spark SQL D. PySpark Answer: C, D

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do? A. Reference the columns in the Python code by index. B. Modify the Sort Column By property for all columns. C. Add a unique field to each row. D. Modify the Summarize By property for all columns. Answer: C

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows. You have a Microsoft Power Bl report named Report1 that uses the model. Report! contains visuals on multiple pages. You need to reduce the query execution time for the visuals on all the pages. What are two features that you can use? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point. A. user-defined aggregations B. automatic aggregation C. query caching D. OneLake integration Answer: A, B

You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first? A. At the semantic model level, set Large dataset storage format to Off. B. At the tenant level, set Create and use Metrics to Enabled. C. At the semantic model level, set Large dataset storage format to On. D. At the tenant level, set Data Activator to Enabled. Answer: C

You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode. You suspect that some DAX queries load unnecessary columns into memory. You need to identify the frequently used columns that are loaded into memory. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point. A. Use the Analyze in Excel feature. B. Use the Vertipaq Analyzer tool. C. Query the $system.discovered_STORAGE_TABLE_COLUMN-iN_SEGMeNTS dynamic management view (DMV). D. Query the discover_hehory6Rant dynamic management view (DMV). Answer: B, C

You have a Fabric tenant that contains a semantic model. You need to prevent report creators from populating visuals by using implicit measures. What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point. A. Microsoft Power BI Desktop B. Tabular Editor C. Microsoft SQL Server Management Studio (SSMS) D. DAX Studio Answer: A, B

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files into the delta format that has V-Order optimization enabled. What should you do from Lakehouse explorer? A. Use the Load to Tables feature. B. Create a new shortcut in the Files section. C. Create a new shortcut in the Tables section. D. Use the Optimize feature. Answer: A

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains an unpartitioned table named Table1. You plan to copy data to Table1 and partition the table based on a date column in the source data. You create a Copy activity to copy the data to Table1. You need to specify the partition column in the Destination settings of the Copy activity. What should you do first? A. From the Destination tab, set Mode to Append. B. From the Destination tab, select the partition column, C. From the Source tab, select Enable partition discovery D. From the Destination tab, set Mode to Overwrite. Answer: B

You have a Fabric tenant that contains a warehouse. Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring? A. the Capacity settings B. the Monitoring hub C. dynamic management views (DMVs) D. the Microsoft Fabric Capacity Metrics app Answer: B

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point. A. Update rows when the non-key attributes have changed. B. Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed. C. Update the effective end date of rows when the non-key attribute values have changed. D. Insert new records when the natural key is a new value in the table. Answer: A, D